Looking for a direction please.
Is there a way to show a specific form to be completed based on the number of previous forms already completed.
For example, I only wish to complete a certain form once a different form has been completed 4 times.
The Scenario: I have a plant inspection that requires an ‘A’ service for 4 times and then a ‘B’ Service on the 5th inspection. I need the User to only see the ‘B’ service every 5th inspection.
I can’t relate it to a time frame or day of week as the inspections are based on the number of uses. The machine could be used only once a week or 5 days a week.
My thoughts so far are:
- Have one continuous Form for the 5 services and have a column count the number of previous ‘A’ services, and in the Form have a SHOW_IF expression for the 5th service.
- Not sure of a way to Display a Form menu if it’s the 5th service as the Display->Show if is not able to use columns in the expression.
- Some Action with LINKTOFORM but that will need User input to select the correct Form (I think)
Any guidance/direction would be appreciated. Thank you