alphabeticly sort items in REF-Dropdown

AppSheet AppSheet Q&A
1

hi everyone,

how can i alphabeticly sort items of dropdown?

a) child-Table: dropdown of column “Street” (items comming from parent-table …)

Asheetbogo_0-1673348058696.png
Asheetbogo_0-1673348058696.png296×540 10 KB

b) column: “Street” of child-table is connected with “REF” to column “Street” of parent-table:

Asheetbogo_1-1673349109735.png
Asheetbogo_1-1673349109735.png711×333 17.7 KB

c) parent-table:

Asheetbogo_2-1673349220409.png
Asheetbogo_2-1673349220409.png696×314 19.1 KB

how can i alphabeticly sort items of dropdown?

thank`s in advance for any help!

2

In the child table’s reference column [DD_Street[, please have the following expression in the valid_if setting

ORDERBY(DD_DropDownParent[DD_UniqueID], [DD_Street], TRUE) for sort descending

ORDERBY(DD_DropDownParent[DD_UniqueID], [DD_Street], FALSE) for sort ascending

ORDERBY() - AppSheet Help

3 Likes
3

Hi @Asheetbogo

You may want to use an ORDERBY() function in the Valid_If field of the column.

For reference:

ORDERBY() - AppSheet Help

and with a quick search:

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&filter=location&location=category:appsheet&q=sort%20dropdown

3 Likes
4

Hi @Suvrutt_Gurjar ,
Hi @Aurelien ,
thank you very much for hint with “Valid_If” field - i have tested it out - it works perfekt!

2 Likes