Conditional Dropdown from column addition

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 )
+
...
1 Like

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!

1 Like