Ordering and Sorting

[Hannes_Rohregge]

Hi All,

I have a few reference tables, let’s give example:

One table is the Personnel table, which is linked to “cars” and “houses” and “bicycles” tables.

So when i view Personnel, i have the three reference tables underneath.

Questions:

1. How do i change the order of the three reference tables underneath
2. When i go into “car” and i want to select a Person from the Personnel table, how can i change the order of the list of Persons?

Thanks!

[Aleksi]

#1 - You can reorder them with the option called “Column order”. You can find it under your detail view’s definition.
#2 - You can use an expression ORDERBY… like ORDERBY(Personnel[KeyColumnName],[NameColumn],FALSE)

[Steve · Accepted solution]

As @Aleksi mentioned:

help.appsheet.com

ORDERBY()

Sort row references

[Hannes_Rohregge]

Thanks guys!

I’m struggling with this scenario : I have a car REF column in the Personnel table which references the Car table.
How do i order this list of cars in the dropdown that pops up?
I’m not sure where to put the ORDERBY(…) ? In the column formula? initial value? suggested value? somewhere else?

[Aleksi]

Use it with the Valid If option.