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.
Yes, see the details in this article. help.appsheet.com - 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 help.appsheet.com
Praveen, thanks for the information. I was able to get it to work.
User | Count |
---|---|
45 | |
29 | |
24 | |
22 | |
13 |