Dependent Dropdown using Ref Type

AppSheet AppSheet Q&A
,
1

Hi Guys! Very Good day.
In AppSheet I like to use ref type of relation between tables as AppSheet handle the Key and the Description nicely. And my practice is to keep the ID in the Child/Transaction Tables instead of keeping the description as you can find it in the example below. So, in the ‘Company Inf’ table I want to filter State based on the Selected Country and show as dropdown…

3X_0_a_0a0f7becf03f6532fed69966ad5c397fdfc713f9.jpeg
3X_0_a_0a0f7becf03f6532fed69966ad5c397fdfc713f9.jpeg1200×390 53.1 KB

I want to know whether it is possible to do this if I keep country ID and State ID as Ref type in the Company Inf Table. I can not do. Available Demos, so far, are done using ‘Valid If’. Would any one please help me to create dependent dropdown based on my scenario.

Thanks.

2

I have followed a filter expression ( Solution offered by Steve in a thread) in the ‘Valid If’ event of ‘State ID’ column of the ‘Company Info’ Table after establishing the Ref Type relation between the parent and child tables. It seems it is working nicely. Thanks Steve. If I face any problem again I must come back to you.

1 Like