alphabeticly sort items in REF-Dropdown

[Asheetbogo]

hi everyone,

how can i alphabeticly sort items of dropdown?

a) child-Table: dropdown of column "Street" (items comming from parent-table ...)

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

c) parent-table:

how can i alphabeticly sort items of dropdown?

thank`s in advance for any help!

[Suvrutt_Gurjar · Accepted solution]

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

[Suvrutt_Gurjar · Accepted solution]

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

[Aurelien · Accepted solution]

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_punctuati...

[Asheetbogo]

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