Hey community! I need to create a form in which there 2 dependent dropdowns that refer to the same column in the spreadsheet.
- 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