Member-only story
Modify Rows in Coda
Simple & more complex cases
One the core functionalities of a button is to modify a value in a column. The label Modify Rows is a bit misleading since you can also modify a complete list — all items living in a column, see example 2.
A button prints a value in a cell. With printing we mean that the value shown in the cell can be the result of a function, but has — once printed — no longer a link with the function that generated the outcome. This implies that you can easily alter (manually or via a button or automation) the generated value. Tables filled out with only text values without formulas calculating them, run faster. This is one of the aspects that makes buttons interesting. Other advantages are:
- check changes
- update values
Example 01 — Modify this row
We start with an easy example. We modify a row based on a value living in an other row. The code below states that we use the value living in cb_src1 and that we show this value in cb_trgt1. Since this is a checkbox it is either true or false (for details check this blog) we see the box checked or unchecked in the target check box.
