Multi-input dependent dropdowns

AppSheet AppSheet Q&A
1

Is it possible to have multiple selections from an EnumList be the input to a dependent dropdown?

I looked at Dependent Dropdown | AppSheet Help Center as a guide, so if I have 3 selections in my 1st dropdown, can I then return a filtered list of values in a dependent dropdown?

Use case:
User selects values EMEA, APAC from a region table from a list of values, EMEA, APAC, NORAM, LATAM.
I want to display all countries in EMEA and APAC region for a user to select a subset of these countries.

Thanks!

2

Enumlist dependent on previous enumlist (filtering) Questions

Oh I see. I guess Appsheet’s automatic dependent dropdown doesn’t work for EnumList. You’ll have to use SELECT() and IN() on your 2nd dropdown’s Valid_if. Something like: SELECT( other-table[col2] , IN( [col1] , [_THISROW].[enumlist1] ) )

3 Likes