Sort Row Orders in Template with Start Expres...

AppSheet AppSheet Q&A
1

Sort Row Orders in Template with Start Expression.

I m trying to sort the row orders in Template.

<<Start:SELECT(Fixtures For Report[_RowNumber],[Fixture Date]>(Today()-7))>>

This is Expression to pull the data from the tables contains the records to show in template and it is working fine.

On “Fixtures For Report” table, we have column with name [Load ID]. What I m trying to do is to sort this table by two columns. First priority is given to Load ID column and secondary sort is [Fixture Date]

How can we alter the expression to use select and orderby all together at the same time?

2

<<Start:ORDERBY(SELECT(Fixtures For Report[_RowNumber],[Fixture Date]>(Today()-7)),[Load ID],[Fixture Date])>> should do the work.

3

@Aleksi_Alkio Hi Aleksi, thank you. I put this on template and test it, but it wont pick up any data, the space is left blank…

4

@Aleksi_Alkio I tested with only primal column sort (remove secondary sort) like this .

<<Start:ORDERBY(SELECT(Fixtures For Report[_RowNumber],[Fixture Date]>(Today()-7)),[Load ID])>>

It worked, but when I added secondary column, [Fixture Date] at the end, it wont…

5

Try with <<Start:ORDERBY(SELECT(Fixtures For Report[_RowNumber],[Fixture Date]>(Today()-7)),[Load ID],TRUE,[Fixture Date],TRUE)>>

6

@Aleksi_Alkio Working perfect now!! Thank you for your excellent help as usual!

7

Thank you for opening this topic!! And thank you @Aleksi_Alkio for sharing the solution!

For the next people reading this post, It’s also important to keep in mind that
[Load ID],TRUE sorts the Load ID rows in descending (high-to-low/9-0/Z-A) order, while [Load ID],FALSE sorts the Load ID rows in ascending (low-to-high/0-9/A-Z) order