Find matching handover entries - j5 - 28.0 - Administration & Configuration - Hexagon

j5 IndustraForm Designer Help

Language
English
Product
j5
Search by Category
Administration & Configuration
j5 Version
2019

In our example so far we have used a filter on the handover status field for "Open for Approval". This is useful while creating and testing IndustraForm designs, as it means that it is easy to modify the data that is being imported. However, this approach requires the handovers to be completed in a very precise sequence, which is not practical in production.

For this reason, it is recommended that the filters are changed from:

=FILTER(<...>, "status=?", "Open for Approval")

to

=FILTER(FILTER(<...>, "shift_date=?", shift_date), "shift=?", shift)

This requires specially named Elements in the form design named ‘shift_date’ and ‘shift’ that will be populated automatically by the Shift Handover application when the form is created. We added these in the previous step when we needed the ‘start_time’ and ‘finish_time’ Elements.