When creating or updating a new item imagine you have field 1 and field 2. Till you don’t choose a concrete value for field 1 field 2 does not have to be available. And once you have selected a concrete value for field 1 then field 2 only lists certain values filtered through a “select” according to the value choosen at field 1…
How to do these 2 things?
You can do this with a “Show?” condition. “Show?” can be edited in the “Columns” sections of “Data.” Here’s an example:
not(isblank([field 1]))
2 Likes
And how to filter the list of possible items shown at field 2 according to the value choosen in field 1?
You may wish to mention from where these option values for field 1 and field 2 are coming from?
If you have a different lookup table for the field 1 and field 2 values, please take a look at the concept of dependent dropdowns
4 Likes
I think you would use a SELECT() expression for this. Actually, though, I haven’t worked with the kind of form you are indicating. I think I’ll bow out and let others with more knowledge follow up. @Suvrutt_Gurjar’s suggestion looks very good to me.
2 Likes
AppSheet has a Dependent Dropdown solution for what you are looking to do as @Suvrutt_Gurjar mentioned above.
2 Likes
Very easy to solve thanks to your advise
Just filled the valid-if field with the expression
“FILTER(“Mandate”, ([ID_Ruler] = [_THISROW].[ID_Ruler1]))”
and the dropdown fills with the proper filteres refs
2 Likes