{{ transformations:ExportAirtableAction.png}}
====== EXPORT TO AIRTABLE ======
Category: Export / App & Cloud\\

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

\\ 
=====Action settings=====
^ Setting  ^ Description  ^
|Connector<sup>*</sup>|Select the pre-configured connector, or create a new connector, to the remote Airtable base.|
|Table name|Enter the name of the existing table in the remote Airtable base.|
|Disable automatic typecast|Prevent Airtable from automatically converting text values within certain columns (data types).\\  See "Remarks" below for more details.  |
|Column names in Airtable|Select 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).|
<sup>*</sup> Setting can be specified using a [[:parameters|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 [[https://community.airtable.com/t/how-import-via-api-a-text-string-into-a-linked-field/39125|this article]] for more details.

\\ 
=====See also=====

  * [[transformations:importairtable|Import from Airtable]]