AddOrModifyRows
AddOrModifyRows
Formula: AddOrModifyRows()
Category: Action
AddOrModifyRows()Modify matching rows or add another row if none match
or stated otherwise...
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 HillAge:
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
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
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.