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:
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