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:

  1. In the left panel, click Content, click Collections, and then click + New Collection.

  2. Click Airtable.

  3. Enter your Airtable API credentials.

  4. In Airtable, select the table you want to use as your collection. This takes you to the Airtable API documentation.

  5. Under Authentication, copy the example link.

  6. Return to FantasticStay and paste it in the field under your API credentials.

  7. Click Import Fields.

  8. Define the correct data type for each field.

  9. Click Continue.

Supported Fields

The following table outlines the supported Airtable fields, the corresponding FantasticStay fields, and examples.

Airtable Field

FS Field

Example

Rich Text

Text

Welcome to my dentist office.

Long Text

Text

NOTE

This field supports HTML and row breaks.

Plain Text

Text

welcome to my office

Number

Numeric

10,000

NOTE

Must only contain numbers, and periods (for decimals).

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/

Phone number or text

Phone

123456789

Email or text

Email

[email protected]

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

Displays only the number, without $ sign.

Percent

Text

NOTE

Displays with decimal and without % sign.

Rating

Text

NOTE

Displays the number.

Formula

Text

NOTE

The result of the formula can be a string.

Autonumber

Text

NOTE

Due to API limitations, FantasticStay 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, 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.

WARNING

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

The following is an example of the URL after adding the view name:

https://api.airtable.com/v0/appbiL1pCyvFcW8WG/Feedback%20Session?view=Main View

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

Did this answer your question?