Creating a drop-down filed dependent of another one

AppSheet AppSheet Q&A
1

Basically I have two fields with drop-downs. I want to make it so when I fill one, the other only shows values that corresponds the one that I’ve filled before.

To this second drop-down I’ll have a table with two columns: one with unique values and one with values that matches the ones on the first drop-down.

2

Hello please check this article https://support.google.com/appsheet/answer/10106620?hl=en&ref_topic=10102053#:~:text=Dependent%20drop%2Ddowns%20allow%20you,a%20Country%20within%20that%20region.

also, check the TEMPLATE APP

https://www.appsheet.com/templates/How-to-create-a-dropdown-menu-with-values-that-depend-on-earlier-choices?appGuidString=55e8571c-49a5-425d-91be-e79424370ca8

1 Like
3

Thank you, it worked.

There’s only one problem: the values on the second field are not sorted.

If I use a sort function inside the valid_if, the field loses its relation with the other field. If I just put the name of the table and column in the valid_if, it works as intended but then the values are shown in a very random order.

Any way to fix this?

4

check out function ORDERBY()

https://support.google.com/appsheet/answer/10107362?hl=en

1 Like
5

I’ve managed to get the sort working by making the drop-down myself instead of just naming the column, like this:

SORT(SELECT(FÁBRICAS_PUPS[PUP], [FÁBRICA]=[_THISROW].[FAB]))

1 Like