Share
Explore
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
Name
Bicycles
Check Out
Check In
The Jones Family
Road Bike
Road Bike
Commuter Bike
The Turner Family
Kids Bike
E-Bike
Susie and Don
There are no rows in this table
Bicycles
Mountain Bike
Available
E-Bike
Available
Mountain Bike
Available
Road Bike
Checked-Out
Commuter Bike
Available
E-Bike
Available
Kids Bike
Available
Road Bike
Checked-Out
Commuter Bike
Checked-Out
Mountain Bike
Available
Practice: Modify a status column to Done
Done
Challenge: Help define a ritual of reflecting on projects completed in a week
Done
Challenge: Create counter buttons on a table to add or subtract 1
Done
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.