ModifyRows

Explore

Gallery

ModifyRows

⁠

Formula: ModifyRows()

Category: Action

⁠

ModifyRows()

Changes values in chosen rows

or stated otherwise...

Hey Coda, I want you to change the information I have in these rows. In this column I want this info, etc.

ModifyRows() has three parameters:

⁠

Rows

ModifyRows(Rows, Column, ColumnValue)

The rows you want to modify

⁠

Column

ModifyRows(Rows, Column, ColumnValue)

The column in which you want to change values.

⁠

ColumnValue

ModifyRows(Rows, Column, ColumnValue)

The value to place in that column.

⁠

ModifyRows() is one of the most used actions within Coda, but 95% of people only use it in elementary ways. Are you ready to master this action?

What is it?

ModifyRows() does exactly what it states: It modifies selected column values within a row. Go ahead and press the change color button below!

Modify this row

Color

Change Color

There are no rows in this table

⁠

How to use it

ModifyRows() can modify anywhere from 1 to 10,000 rows in a single button push. It can modify the row that it exists on or any other rows in any other tables. Here’s how you set it up:

1. Create a button and choose ModifyRows() as its action

⁠

2. Choose the target for your action

The end target must be either a row or a collection of rows but you can approach this in two ways:

⁠

3. Choose your columns and their corresponding values

⁠

Helpful Tip

While you can use the visual editor for setting up your button, The Coda School prefers to always use the formula editor.

The more you become comfortable with the formula editor, the more flexibility you will find in terms of the actions you can set up.

One other immediate benefit is that if you are looking to modify rows in a doc with a large number of tables, the formula editor lets you search for the table name while the visual editor for a button forces you to scroll through them all until you find it.

Advanced Use-Cases

One thing most people don’t realize is that ModifyRows() can modify every row that is linked to its parent row. Take this situation for example:

You own a bicycle shop where tourists come to rent out bicycles by the hour. You use Coda to manage your inventory to have better insight into what bikes are available. You've set up the system below.

This is your time to learn by exploration! Try clicking around into the button below to see how they behave, then click into the buttons formulas to see how they work behind the scenes

Tourists