Hi
There is an app for checking and recording the same 10 facilities every day. The inspection items for each facility are all the same. The facility to be inspected is set by the ENUM. I don't want to see the facilities that have already been inspected that day in the selection list, what should I do?
Solved! Go to Solution.
It will depend upon how the tables are related and how you are setting up enum and other columns.
A general approach could be to
1) Use Valid_if in the enum to list all facilities
2) substract list of facilities from the list of all facilities in the enum valid_if
So enum valid_if can be something like
LIST (" All facilities") - LIST( Completed Inspection Faclities for the day")
https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if
https://help.appsheet.com/en/articles/4575802-list-subtraction
Found a sample app that could be useful to you.
It will depend upon how the tables are related and how you are setting up enum and other columns.
A general approach could be to
1) Use Valid_if in the enum to list all facilities
2) substract list of facilities from the list of all facilities in the enum valid_if
So enum valid_if can be something like
LIST (" All facilities") - LIST( Completed Inspection Faclities for the day")
https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if
https://help.appsheet.com/en/articles/4575802-list-subtraction
Found a sample app that could be useful to you.
Thank you for your advice. It will be useful as a reference.
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |