Alternating row colors

[Paul_Danyliuk]

Indeed, when applying sorting on a table, the data (.First(), .Nth(…) etc) remains in the same order.

But if you go this way then you’ll have your sorting applied on always that one helping column, and you can use that column in a formula to determine sort-agnostic rank: thisTable.Sort(true, Sort).Find(thisRow)

Sort / group table with external controls

There was a question in the community recently whether it was possible to control sorting and grouping of the table without having to edit table settings. This could be useful to e.g. make usage of the doc simpler for someone less familiar with Coda, and also to limit (make harder) to sort/group on columns that are not meant to be grouped/sorted. Unfortunately the group/sort dialog doesn’t allow for formulas. So the trick is to use two dedicated columns for grouping and sorting, and then use fo…

P.S. Just updated the example to reflect this