JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Gallery
AddOrModifyRows
Share
Explore
Gallery
AddOrModifyRows
AddOrModifyRows
Database
DB Months
The Coda School
AddOrModifyRows
Formula
:
AddOrModifyRows()
Category
: Action
AddOrModifyRows()
Modify matching rows or add another row if none match
or stated otherwise...
Hey Coda, check if this column value in a row matches these criteria; if not, then create a new row.
AddOrModifyRows()
has
four
parameters:
Table
AddOrModifyRows
(
Table
, Expression, Column, ColumnValue)
The table you want to modify.
Expression
AddOrModifyRows
(Table,
Expression
, Column, ColumnValue)
Filter to rows you want to modify.
Column
AddOrModifyRows
(Table, Expression,
Column
, ColumnValue)
The column to add values to.
ColumnValue
AddOrModifyRows
(Table, Expression, Column,
ColumnValue
)
The value to put in the column.
When pressed, a button using this action will:
→
Check for a matching row based off a key column:
If there is
a matching row - Modify/update that rows values
If there is no
matching row - Add a new row with the stated value
Explore the activity below and watch how add/modify row works!
Select a Person:
Angela Hill
Age
:
11
Birthday
:
11/7/2006
Favorite Icon
:
fill color
AddOrModify says:
Oh! Hey, I checked the table below for a matching key column by name and
there was a match!
Ill go ahead and update the rows values for
Angela Hill
They've already been updated! Select a new person
Name
Age
Birthday
Favorite Icon
Icon
Favorite Animal
Annual Salary
Email
Name
Age
Birthday
Favorite Icon
Icon
Favorite Animal
Annual Salary
Email
1
Ronnie Gross
3
8/5/2000
bear
Cattle
$84,636
rgross@live.com
2
Bryan Johnson
11
11/9/2002
snow
Dog
$55,193
bjohnson@optonline.net
3
Angela Hill
11
12/1/2009
fill color
Donkey
$72,046
ahill@comcast.net
4
Matthew Smith
77
1/15/2021
checklist
Goat
$56,925
msmith@outlook.com
5
Megan Smith
30
12/3/2007
note
Horse
$28,865
msmith@gmail.com
6
Daniel Ayers
18
11/10/2004
ladder
Rabbit
$104,956
dayers@icloud.com
7
Bradley Alexander
66
1/1/2018
boy
Fancy rat varieties
$136,306
balexander@hotmail.com
8
Robert Serrano
29
9/29/2007
chicken
Chicken breeds
$128,227
rserrano@outlook.com
9
Lisa Saunders
30
12/30/2007
computer
Goose breeds
$79,170
lsaunders@mac.com
10
Robin Pugh
7
9/10/2001
christmas tree
Aardvark
$29,831
rpugh@comcast.net
There are no rows in this table
Practice
:
Use add/modify row action successfully in a table
Done
Create a workflow that will keep two different tables always in sync
Done
Gallery
Share
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.