Airtable can be used as a collection for generating Dynamic Pages. For more information on collections, see Define a Collection for Dynamic Pages.
Airtable collections have the following limitations:
| Airtable |
Collection Number per Site | 100 |
Fields (columns) | 100 |
Collection name character limit | 50 |
Field name character limit | 50 |
Page item URL | 350 characters |
Update data | Automatically every hour |
To create an Airtable collection:
In the left panel, click Content, click Collections, and then click + New Collection.
Click Airtable.
Enter your Airtable API credentials.
In Airtable, select the table you want to use as your collection. This takes you to the Airtable API documentation.
Under Authentication, copy the example link.
Return to Website Builder and paste it in the field under your API credentials.
Click Import Fields.
Define the correct data type for each field.
Click Continue.
Supported Fields
Airtable made changes to their URL attachments (such as links and images) causing them to expire after two hours. Sites is not affected by this change since it pulls data from Airtable on an hourly basis.
The following table outlines the supported Airtable fields, the corresponding Sites fields, and examples.
Website Builder Field | Airtable Field | Example |
Text | Rich text | Welcome to my dentist office. Note Using Airtable's built-in link rich text field is not supported. For example, to add a link, use the HTML |
Text | Long text | Note This field supports HTML and row breaks. |
Text | Plain text | welcome to my office |
Numeric | Number | 10,000 Note Must only contain numbers, and periods (for decimals). |
Boolean | Checkbox | Note Only for custom widgets. |
Image | Attachment with one image | Image added through Airtable. |
Link | URL | |
Video | URL or text | |
Phone | Phone number or text | 123456789 |
Email or text | ||
Location | Text | streetAddress, postalCode, region, city, country 577 College Ave, 94306, CA, Palo Alto, US |
Business Hours | Text | SAT, SUN: 08:00-20:00; THU, FRI: 08:00-12:00; |
Inner collection that contains one image field | Attachment with multiple images | Images added through Airtable. |
Text | Number |
|
Text | Currency | Note Displays only the number, without $ sign. |
Text | Percent | Note Displays with decimal and without % sign. |
Text | Rating | Note Displays the number. |
Text | Formula | Note The result of the formula can be a string. |
Text | Autonumber |
|
Social account | Value | Must be formatted as name: value; name: value; email: my@gmail.com; whatsapp: 123456; facebook: Website Builder; Note Supported social networks: email, whatsapp, facebook, X (twitter), instagram, youtube, linkedin, yelp, pinterest, google_my_business, waze, vimeo, snapchat, reddit, tripadvisor, foursquare, rss.
|
Date & Time | Text | The default structure is YYYY-MM-DD HH:mm:SS, which displays as 2021-10-06 16:12:00. For a complete list of date and time formats and how they display, see Class DateTimeFormatter. Note
|
Multi Select | Multi Select | After defining the field as Multi Select, click Options to add options. Each row in the collection can be assigned one or more of the options you created. Note This field can be used to filter the displayed collection in widgets, such as photo gallery, list, accordion, and custom widgets that connect to collections. |
Due to API limitations, Sites will not import fields that do not have content in the first 10 rows.
Row Order
When using Airtable collections, the row order is being pulled in randomly due to an API limitation on Airtable's site. We ignore filters or sorting in Airtable.
To pull the row order in the same order that exists in Airtable, including filters and sorting, add the Airtable View name to the example URL that you are using to import their collection. For more information, contact Airtable Support.
To add the view, after the example URL is added, add '?view=View Name'. The view name is case sensitive and should be typed exactly how it's written in Airtable.
Deleting or changing the view name after importing the collection will break the connection.
The following is an example of the URL before adding the view name:
https://api.airtable.com/v0/appbiL1pCyvFcW8WG/Feedback%20Session?view=Main%20View
The following is an example of the URL after adding the view name:
https://api.airtable.com/v0/appbiL1pCyvFcW8WG/Feedback%20Session?view=Main View
For more information on adding the view name to the URL, see this video.
The next step is to create or convert a Dynamic Page so you can connect it to your newly created collection.