Hi,
quick question, I need to create a dependent dropdown base on a first dropdown which is an addition of columns from multiple tables, lets say:
table1[column2]+table2[column2]+table3[column2]
the first dropdown works fine because Iโm getting all the options from the added columns of the different tables, but I need the second dropdown to be dependent of the first one value, if I add the same valid if condition appsheet doesnt detect it as a dependent dropdown
any advice?
Youโll have to build your own dependent dropdowns using SELECT(), instead of relying on Appsheetโs automatic ones.
Something like:
SELECT( table1[column3] , xxx )
+
SELECT( table2[column3] , xxx )
+
...
thanks for the answer Marc but what would be the condition of SELECT if I want it dependent of the first dropdown? Im confused, sorry.
[_thisrow].[column1]?
thanks for the clarification!
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |