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 | 100 |
Text field character limit | 2000 |
Collection name character limit | 50 |
Field name character limit | 50 |
Update data | Automatically |
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 SiteBuilder 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
The following table outlines the supported Airtable fields, the corresponding SiteBuilder fields, and examples.
Airtable Field | SiteBuilder Field | Example |
---|---|---|
Text | Text | Welcome to my dentist office. |
Long Text | Text | |
Checkbox | Boolean | |
Attachment with one image | Image | Image added through Airtable. |
URL | Link | https://goo.gl/maps/F81HPm4CBTQSTsJ5A |
URL or text | Video | https://www.youtube.com/watch?v=8EsYwAKxAFU |
Phone number or text | Phone | 123456789 |
Email or text | email@email.com | |
Text | Location | streetAddress, postalCode, region, city, country
577 College Ave, 94306, CA, Palo Alto, US |
Text | Business Hours | SAT, SUN: 08:00-20:00; THU, FRI: 08:00-12:00; |
Attachment with multiple images | Inner collection that contains one image field | Images added through Airtable. |
Number | Text | |
Currency | Text | |
Percent | Text | |
Rating | Text | |
Formula | Text | |
Autonumber | Text |
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.
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.
The following is an example of the URL before adding the view name:
https://api.airtable.com/v0/appbiL1pCyvFcW8WG/Feedback%20Session
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.