Readers: For information on the parameters in this dialog that are common to all readers, see:
Writers: For information on the parameters in this dialog that are common to all writers, see:
When writing to an Airtable table, if the user attribute type listed in the writer schema does not match the field type on the server, the server field type will be used instead. User attributes that cannot be matched to fields on the Airtable server will be omitted from the writer.
Please see Airtable Field Types Overview for a list of field types supported by Airtable.
|
Name |
Read |
Write |
Description |
Additional Representation Notes |
|---|---|---|---|---|
|
barcode |
Yes |
Yes |
A JSON containing barcode information. |
|
|
button |
Yes |
No |
A JSON representing a button field in Airtable |
|
|
checkbox |
Yes |
Yes |
A yes/no checkbox in Airtable. |
This corresponds to a boolean value in FME. |
|
computedCollaborator |
Yes |
No |
An Airtable user who has access to the table. This value is set by Airtable and is likely to represent the last user to modify/create a record. |
Only the email of the collaborator will be represented. |
|
computedInt |
Yes |
No |
An integer value computed by Airtable. This corresponds to Airtable fields such as autonumber. |
|
|
computedTime |
Yes |
No |
An ISO formatted string representing a date or datetime value computed by Airtable. This represents read-only fields in Airtable like created time and last modified time columns. |
|
|
computedValue |
Yes |
No |
A value computed by Airtable. This could be the result of a formula. |
|
|
currency |
Yes |
Yes |
A currency value. |
In FME, this value will be displayed without the symbol. |
|
date |
Yes |
Yes |
An ISO-8601 formatted datetime string. |
The writer also accepts FME-formatted dates in addition to ISO formatted dates. |
|
datetime |
Yes |
Yes |
An ISO-8601 formatted datetime string |
The writer also accepts FME-formatted datetimes in addition to ISO-formatted timestamps. The inclusion of a timezone offset is optional – if it is omitted, all input will be treated as though it is UTC. |
|
duration |
Yes |
Yes |
A duration of time. |
In FME, this value will be displayed as the number of seconds represented by the duration. For example, a field that is configured to show h:mm will show 3:30 in Airtable and 210 in FME. |
|
|
Yes |
Yes |
An email address. |
|
|
externalSyncSource |
Yes |
No |
An Airtable computed value used for integrated apps. |
|
|
multipleAttachments |
Yes |
Yes |
The URL to an attachment which will be uploaded to Airtable. |
|
|
multilineText |
Yes |
Yes |
A multi-line string. |
|
|
multipleCollaborators |
Yes |
Yes |
One or more Airtable users who has access to the table. |
This is displayed in FME as the email of the collaborator. |
|
multipleLookupValues |
Yes |
No |
Field values for records linked to by a multipleRecordLinks field. |
This is mapped to a list attribute in FME |
|
multipleRecordLinks |
Yes |
Yes |
A list of Airtable record IDs. |
This is mapped to a list attribute in FME. |
|
multipleSelects |
Yes |
Yes |
One or more options from a list of predefined field values. |
This is mapped to a list attribute in FME. |
|
number |
Yes |
Yes |
A numeric value. This could be a float or an integer. |
The precision settings for a column in Airtable will not be used. Instead, the underlying value will be displayed |
|
percent |
Yes |
Yes |
A numeric value displayed as a percentage in Airtable. |
In FME, the percent sign will be removed and the underlying value will be displayed. For example, a field value of 75% in Airtable will be 0.75 in FME. |
|
phoneNumber |
Yes |
Yes |
A phone number. |
|
|
rating |
Yes |
Yes |
An integer between 0 and the field maximum (at most 10). |
|
|
richText |
Yes |
Yes |
A multi-line string. |
|
|
singleCollaborator |
Yes |
Yes |
An Airtable user who has access to the table. |
This is displayed in FME as the email of the collaborator. |
|
singleLineText |
Yes |
Yes |
A short string. |
|
|
singleSelect |
Yes |
Yes |
A single string option from a list of predefined field values. |
|
|
url |
Yes |
Yes |
The URL to a website. |
|