Hey community! I need to create a form in which there 2 dependent dropdowns that refer to the same column in the spreadsheet.
An example
I think you’re experiencing what I would call an “edge case” of Appsheet’s automatic dependent dropdown functionality. Basically, it is filtering the dropdown options in the second column, by what you selected in the first. Of course that doesn’t make sense in this scenario. So, as described by the following article, to disable the dependent dropdown functionality, just replace:
Table[Column]
…with:
SELECT( Table[Column] , TRUE )
User | Count |
---|---|
43 | |
28 | |
24 | |
21 | |
13 |