Gallery
ModifyRows
Share
Explore

icon picker
ModifyRows

Formula: ModifyRows()
Category: Action
edit-row.svg
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:
row (3).svg
Rows

ModifyRows(Rows, Column, ColumnValue)

The rows you want to modify

select-column (2).svg
Column

ModifyRows(Rows, Column, ColumnValue)

The column in which you want to change values.

add-column (2).svg
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
1
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

reminder

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
Name
Bicycles
Check Out
Check In
1
The Jones Family
Road Bike
Road Bike
Commuter Bike
2
The Turner Family
Kids Bike
E-Bike
3
Susie and Don
There are no rows in this table
Bicycles
cycling-mountain-bike.svg
Mountain Bike
Available
scooter.svg
E-Bike
Available
cycling-mountain-bike.svg
Mountain Bike
Available
cycling-track.svg
Road Bike
Checked-Out
protected-bike-lane.svg
Commuter Bike
Available
scooter.svg
E-Bike
Available
tricycle.svg
Kids Bike
Available
cycling-track.svg
Road Bike
Checked-Out
protected-bike-lane.svg
Commuter Bike
Checked-Out
cycling-mountain-bike.svg
Mountain Bike
Available
Done
Done
Done

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.