Getting Duplicates in drop down menu using row label

AppSheet AppSheet Q&A
1

I have a table (CITY) of cities with multiple venues per city. I would like to choose a city then have a dependent dropdown with the venue. I currently have a separate column in the CITY table as a unique key and using row label to have the CITY names in the dropdown referenced from the main table. This is so users can add new venues or I would just use an easy VALID_IF reference.
It seems I could use the UNIQUE(CITY[CITY]) but cannot figure out where to put it??

Any help would be appreciated, THANKS!

2

Hi @Clifford, if I understand you correctly, you want a dropdown enum type from the CityColumn of the CityTable to be unique.

You may try something like this in the Valid_If:

SELECT(CityTable[CityColumn], TRUE, TRUE)

Which should give you only those unique city from the CityTable.

And to make easier for selecting the enum City name with an alphabetic selection, you may want to consider also to wrap it with SORT(), such as:

SORT(SELECT(CityTable[CityColumn], TRUE, TRUE))
2 Likes
3

Heru:

auto> SELECT(CityTable[CityColumn], TRUE, TRUE)> >

Thanks Heru -
The problemn I am encountering is that it is the CITY Column from the MainTable is REF column -
so for the Valid_if I need to use CityTable[KEY] (key being a unique id), and cannot find a way to then filter duplicate city names. Is there a way to combine both conditions?

Thanks!

4

Clifford:

CITY Column from the MainTable is REF column

Please inform your actual table names and also column names, sorry for misunderstanding from my side.

5

2X_3_3d65cb1724c455e01e6ed695597536d4e6f92014.png
2X_3_3d65cb1724c455e01e6ed695597536d4e6f92014.png2628×2310 338 KB

2X_1_13bd535644af821200c7b32dcaf01ee8e1cb9b7d.png
2X_1_13bd535644af821200c7b32dcaf01ee8e1cb9b7d.png552×898 28.7 KB

Apologies - The Valid_If of the MAIN TABLE CITY Ref type column is CITY[KEY], I need to somehow then filter the duplicates…

Thanks!

6

I see your table structure, however @Clifford I have to say that I need to learn more to be able to do what you want with that table structure. Maybe others can give better suggestion on this.

Unless, if you want to change the [CITY] of the MAIN TABLE to enum type, you could use something like CITY[CITY] in the Valid_If dropdown setting. It will give you the unique city name.

1 Like