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 |
Collection name character limit | 50 |
Field name character limit | 50 |
Page item URL | 350 characters |
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 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
The following table outlines the supported Airtable fields, the corresponding Website Builder fields, and examples.
Airtable Field | Website Builder Field | Example |
---|---|---|
Rich Text | Text | Welcome to my dentist office. |
Long Text | Text | |
Plain Text | Text | welcome to my office |
Number | Numeric | 10,000 |
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. For more information, see 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.
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.