Are "Deep" Dynamic Dropdowns Possible? Here...

(ABC Admin) #1

Are “Deep” Dynamic Dropdowns Possible?

Here is our scenario:

Our table (sheet) is setup with 4 columns labeled #1,#2,#3,#4. Our app has a form with 4 fields/questions. Each field is a drop down that is filtered based on the previous selection. After we select an option for question #1, the next field for #2 is filtered correctly using this Valid_If format (table[column]), After a selection is made for question #2, the options for question #3 are also filtered correctly.

The issue is question #4. We want that to be filtered based on the selection of question #2 and not #3. Right now using the format of Table[Column] works but forces #4 to look at #3

Is there a way to have dynamic dropdowns look at a specific input?

Any helps appreciated.

(Praveen Seshadri (AppSheet)) #2

Yes, see the details in this article. - Dependent Dropdown

You use a Valid_If expression that is more explicit. Instead of just saying Table[Column4] you say:

SELECT(Table[Column4], AND([_THISROW].[Column1] = [Column1], [_THISROW].[Column2] = [Column2]))

Notice I didn’t mention Column3 in the filter condition Dependent Dropdown

(ABC Admin) #3

Praveen, thanks for the information. I was able to get it to work.