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:
|Collection Number per Site||100|
|Text field character limit||2000|
|Collection name character limit||50|
|Field name character limit||50|
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.
The following table outlines the supported Airtable fields, the corresponding Website Builder fields, and examples.
|Airtable Field||Website Builder Field||Example|
|Text||Text||Welcome to my dentist office.|
|Attachment with one image||Image||Image added through Airtable.|
|URL or text||Video||https://www.youtube.com/watch?v=8EsYwAKxAFU|
|Phone number or text||Phone||123456789|
|Email or email@example.com|
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.|
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:
The following is an example of the URL after adding the view name:
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.