How to remove finished items from the enum list

[Yoichi_Sakurai]

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?

[Suvrutt_Gurjar · Accepted 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.

https://www.appsheet.com/templates/Only-allow-values-that-havent-been-chosen-in-dropdown?appGuidStri...

[Yoichi_Sakurai]

Thank you for your advice. It will be useful as a reference.