Zebra Pattern in sorted or filtered tables

[Paul_Danyliuk]

Here’s the solution you’re looking for, with all the details.

You cannot get the currently visible row that would respect sorting (or filtering if it’s a master table and not a view), but you can sort with external controls and use their value to also calculate row position.

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…