Gallery
AddOrModifyRows
Share
Explore
Gallery
AddOrModifyRows

icon picker
AddOrModifyRows

⁠
⁠
⁠
Formula: AddOrModifyRows()
Category: Action
insert-row-above.svg
⁠
⁠
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:
select-table (1) (1).svg
⁠
⁠
Table

AddOrModifyRows(Table, Expression, Column, ColumnValue)

The table you want to modify.
biosand-filter.svg
⁠
⁠
Expression

AddOrModifyRows(Table, Expression, Column, ColumnValue)

Filter to rows you want to modify.
select-column (1).svg
⁠
⁠
Column

AddOrModifyRows(Table, Expression, Column, ColumnValue)

The column to add values to.
add-column (1).svg
⁠
⁠
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
⁠
⁠
⁠
commercial.svg
⁠
⁠
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
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
⁠

⁠
⁠
⁠

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 (
CtrlP
) instead.