Not sorted as in the spreassheet document

J_jvs
Participant V

Hi team,
I have a list of users sorted by quantity of times that it appears en main database.
But when I want to create a new row the drop list of users to select appears sorted as I created in the initial spreadsheet document.
How can i solve it?

thks

0 4 233
  • UX
4 REPLIES 4

You need a list sorted by the order that they are in the spreadsheet?

ORDERBY( list , [_rownumber] )

Where list is a list of key column values from the rows to sort.

See also:

No Marc, I need the opposite, I want to sort (max to min) as a โ€œcount of timesโ€ (row of my appsheet) that one user has been selected.

I attached example of spreadsheet. In appsheet appears in same order and i want to sort by counts from max to min.

2X_2_2101d9926102d09c9583e20f302025dfbdce3743.png

Missatge de Marc Dillon via AppSheet Creator Community appsheet@discoursemail.com del dia dt., 31 de marรง 2020 a les 20:26:

Please review the article for ORDERBY() that @Steve supplied above. There is an optional argument you can supply to sort in descending order.

Top Labels in this Space