UPDATE/DELETE ROWS IN AIRTABLE

Category: Workflow / App/Cloud

This action connects to an Airtable database ("base") to delete or update rows in a specified table via API Key and Base ID.

^* Setting can be specified using a parameter.

Description: Rows in the Airtable table with Row IDs matching those in the EasyMorph table are deleted.

^* Setting can be specified using a parameter.

Description: Updates values in selected columns in the Airtable table where the Row IDs match those in the EasyMorph table.

^* Setting can be specified using a parameter.

Airtable Row IDs: These are unique row IDs generated by Airtable to identify individual rows. The Row IDs are retrieved from an Airtable table by using the Import from Airtable action and selecting the Import System ID option. This creates a field named "_id" in the imported dataset. Alternately, Row IDs can be made part of the table by creating a formula field in the Airtable table and using the "RECORD_ID()" function. This column can then be imported and used as the "Row ID" column without using the Import System ID option.

Keep/Remove row values: When "Remove the row values that are not updated" is selected, any values in the row that are not updated with a value from the EasyMorph table are blanked out. Use this setting when repopulating the entire record and columns without new values should be cleared. When updating single or select columns while keeping the rest of the record intact, choose "Keep the row values that are not updated" to retain the values in columns that are not being affected.

Automatic typecasting: Automatic typecasting is a process within Airtable for converting passed-in text values to "specialized" data/field types. For example, when passing a text value into a linked table field, Airtable will attempt to resolve the table link, or create a new one if the linked table doesn't already exist. Similarly, passing a text value into a single- or multi-select field will attempt to resolve the value in the current selection list, or create a new value if it does not exist. Refer to this article for more details.

EXAMPLE 1: Update the mountains' rounded heights in the source table with the actual height values from the EasyMoprh table.

Source table (Airtable): Five Tallest Mountains

Update table (EasyMorph):

Action parameters:

Connector is the connector to the Airtable base the table resides in.
Command is "Update"
Table name is "Five Tallest Mountains"
Row IDs is "_id"
When a row is updated "Keep the row values that are not updated"
Column names in Airtable are "Other"
Columns: Check "Height(m)_New" and select the "Height(m)" Airtable field.

Result table (Airtable):

EXAMPLE 2: From the "Five Tallest Mountains" source table, remove the shortest 2 mountain peaks using the Row IDs.

Source table (Airtable): Five Tallest Mountains

Delete rows table (EasyMorph):

Action parameters:

Connector is the connector to the Airtable base the table resides in.
Command is "Delete"
Table name is "Five Tallest Mountains"
Row IDs is "_id"

Result table (Airtable):

• Import from Airtable
• Export to Airtable