User Tools

Site Tools


transformations:exportairtable

EXPORT TO AIRTABLE

Category: Export / App & Cloud


Description

This action exports (appends) a dataset into an Airtable table.


Action settings

Setting Description
Connector*Select the pre-configured connector, or create a new connector, to the remote Airtable base.
Table nameEnter the name of the existing table in the remote Airtable base.
Disable automatic typecastPrevent Airtable from automatically converting text values within certain columns (data types).
See "Remarks" below for more details.
Column names in AirtableSelect whether to use the column names from the EasyMorph dataset in the Airtable table, or use column
names selected from the Airtable table. Options: Same as in EasyMorph or Other (click the "Load column
names" button and select the column names loaded from the Airtable table).

* Setting can be specified using a parameter.


Remarks

When loading the column names from the remote Airtable table, columns not currently having data will not appear in the list.

Values that do not match the data type of the Airtable column being exported to will result in empty (null) cells for those values.

The dataset result of the Export to Airtable action is the exported dataset with an additional column named "Operation result" that reflects the success or failure of each row being exported.

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.


See also

transformations/exportairtable.txt · Last modified: 2021/05/19 17:23 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki