Sign up for free
Functions

ADD_OR_UPDATE_RECORD_AIRTABLE

Add or update data columns in an Airtable base by defining the base ID, the table name, and the name of the columns.

icon of AirtableAirtable
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
ADD_OR_UPDATE_RECORD_AIRTABLE(base_id, table_name, field, value, 
[field2, value2]
)
base_id

The ID of your Base on Airtable. For example: "appqK4jJW4C1Rp2G0".

table_name

The table name from your Base. For example: "Design projects".

field

The name of the field to be added or updated. For example: phone. Must exactly match the name in Airtable. This field is used as the key to find the record to change.

value

The field value to be added or updated. For example: "3402 8908".

[optional] field2

Additional field to be added or updated. Must exactly match the name in Airtable.

More details

Follow Airtable's guide to get your API key.

To get your Base ID, log in to your Airtable REST API portal and select the base you want to access.

Examples

ADD_OR_UPDATE_RECORD_AIRTABLE("appqK4jJW4C1Rp2G0", "Contacts", "Email", "john.doe@mycompany.com", "Age", 25) returns the record that was added or updated in the `Contacts` table on Airtable.