Using Airtable as a Collection

Modified on Mon, 30 Mar, 2020 at 12:51 AM

Airtable can be used as a collection for generating Dynamic Pages. For more information on collections, see Define a Collection for Dynamic Pages.

Follow the steps below to create a collection for Dynamic Pages using Airtable:

Navigate to Content > Business Content > Collections and click New Collection.
Select 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 and paste it in the field under your API credentials.
Click Import Fields.
Define the correct data type for each field (see Supported Data Types below).
Click Continue.

Supported Data Types

The following table outlines the supported Airtable field types, the corresponding Website Builder field types, and an example.

AirTable Field Type	Website Builder Field Type	Note/Example
Text	Text	Welcome to my dentist office.
Long Text	Text	Note: Supports HTML and row breaks
Checkbox	Boolean	Note: Only for custom widgets.
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@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	Note: Display only the number, without $ sign.
Percent	Text	Note: Displayed with decimal and without % sign.
Rating	Text	Note: Will display the number.
Formula	Txt	Note: The result of the formula can be a string.
Autonumber	Text

Using Airtable as a Collection

Airtable can be used as a collection for generating Dynamic Pages. For more information on collections, see Define a Collection for Dynamic Pages.

Follow the steps below to create a collection for Dynamic Pages using Airtable:

Navigate to Content > Business Content > Collections and click New Collection.

Select 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 and paste it in the field under your API credentials.

Click Import Fields.

Define the correct data type for each field (see Supported Data Types below).

Click Continue.

Supported Data Types

The following table outlines the supported Airtable field types, the corresponding Website Builder field types, and an example.

AirTable Field Type

Website Builder Field Type

Note/Example

Text

Text

Welcome to my dentist office.

Long Text

Text

Note: Supports HTML and row breaks

Checkbox

Boolean

Note: Only for custom widgets.

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@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

Note: Display only the number, without $ sign.

Percent

Text

Note: Displayed with decimal and without % sign.

Rating

Text

Note: Will display the number.

Formula

Txt

Note: The result of the formula can be a string.

Autonumber

Text

Note: Due to API limitations, fields that don't have content in the first 10 rows will not be imported.

The next step is to create or convert a Dynamic Page so you can connect it to your newly created Collection.