Conditional Dropdown from column addition

[Orcua]

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?

[Marc_Dillon]

You’ll have to build your own dependent dropdowns using SELECT(), instead of relying on Appsheet’s automatic ones.

help.appsheet.com

SELECT()

Gather column values from row in table or slice

Something like:

SELECT( table1[column3] , xxx )
+
SELECT( table2[column3] , xxx )
+
...

[Orcua]

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.

[Wesley]

[_thisrow].[column1]?

[Orcua]

thanks for the clarification!