CSV Template ignores ORDERBY()

AppSheet AppSheet Q&A
,
1

Hey everyone.

I’m playing around with the CSV export workflow, but I’ve found that if you have a START expression in your template with an ORDERBY, the orderby is ignored.

I created a sample app showing this in action:
https://www.appsheet.com/samples/OrderBy-is-ignored-in-CSV-template-export?appGuidString=dfe27db2-ecc5-4187-bf87-f35eadf5d9e9

Here’s a video showing what I’m talking about:

2

This:

ORDERBY(Sheet5[_rowNumber], Order)

should be this:

ORDERBY(Sheet5[_rowNumber], [Order])

Note the square brackets. That argument is actually an expression, not a column name.

2 Likes
3

It’s been awhile since I’ve pulled one of those all night building marathons. There’s a trade off, lol: you get silly minor mistakes like this, but get a ton done in one shot.

Thanks man! Works perfectly.

1 Like