How to ORDER inline items

AppSheet AppSheet Q&A
1

Hi,

I’m trying to figure out where and how I need to ORDER an inline collection of objects.

MarkingApp2024_-_AppSheet.png
MarkingApp2024_-_AppSheet.png3002×1732 528 KB

In the example above a Rubric has both Sections and Marks Bands. I first group them by Sections (Content & Structure, Vocabulary, Grammar etc) but then want to order the Marks Bands by a numerical column called Upper. You can see the red item is a Fail item with an Upper of 40 but comes before Pass because F comes before P. They seem to be only orderable by name.

I tried wrapping a ORDERBY around the REF_ROW but that doesn’t work.

ORDERBY([Upper], REF_ROWS(“Criteria”, “Marks Band”))

Any clues as to the best way to do this? I might have expected it to be in the View Options, but there I can only define the Table, not the Column within the table.

Thanks

Tom

2

Then why not specify [Upper] as the sort column instead of [Marks Band]?

You do not need ORDERBY, you can achieve all of the sorting in the view definition. When you apply Grouping, the Groups always set the PRIMARY sort columns. The Sort by property will then sort the detail rows.