Skip to content
Check for a matching row based off a key column:If there is a matching row - Modify/update that rows valuesIf there is no matching row - Add a new row with the stated value
Share
Explore
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:
→
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
Ronnie Gross
3
8/5/2000
bear
Cattle
$84,636
rgross@live.com
Bryan Johnson
11
11/9/2002
snow
Dog
$55,193
bjohnson@optonline.net
Angela Hill
11
12/1/2009
fill color
Donkey
$72,046
ahill@comcast.net
Matthew Smith
77
1/15/2021
checklist
Goat
$56,925
msmith@outlook.com
Megan Smith
30
12/3/2007
note
Horse
$28,865
msmith@gmail.com
Daniel Ayers
18
11/10/2004
ladder
Rabbit
$104,956
dayers@icloud.com
Bradley Alexander
66
1/1/2018
boy
Fancy rat varieties
$136,306
balexander@hotmail.com
Robert Serrano
29
9/29/2007
chicken
Chicken breeds
$128,227
rserrano@outlook.com
Lisa Saunders
30
12/30/2007
computer
Goose breeds
$79,170
lsaunders@mac.com
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
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.