2 dependent dropdowns in a single form

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

  • there is a spreadshet named ‘Product’ that has a column named ‘List of products’ its values are Product_a, Product_b, Product_c
  • there is a form that has the field Product_1 in which I filled in Valid If field with Product[List of product] . So far it works as expected.
  • when setting in the same form a 2nd field named Product_2, in which I filled in Valid If field with Product[List of product] . There it doesnt work as expected, there it shows the option choosen in Product_1 field
1 Like

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 )
2 Likes