Member-only story
How to Coda ‘thisRow’ on the Canvas?
How to replace thisRow in a Filter?
In a previous blog I already wrote on this matter. A question of a client made me realize that something simple requires still some explanation.
The question was about a rather simple calculation. The turn over per month in any given year on the canvas. There is a table with turn over, a table with months and that is it.
The calculation in the table is a basic one. We compare all items in the list ‘month’ per row with the item(s) living each row, thus on ‘thisRow’. In the example above we have only one item per row in the list ‘month’. The second part of this blog shows how to deal with multiple items per row. First the function you can write with your eyes closed:
This works as it does because between the table reference and the ‘month’ reference we have put a Filter to evaluate each item in the list. Writing ‘thisTable.month’ outputs per row all months, because when you reference ‘thisTable’ you ask for the…
