Dynamic Pages: Using Airtable to Create a Collection
One option for creating collections is Airtable. To select this option, select “Content,” “Business Content,” and “Collections.”
Note: you must have an Airtable account and populate your database prior to connecting in Without Code. Visit Airtable.com for more information.
Click “+New Collection.”
Select Airtable and follow these steps:
- Click the blue hyperlink that reads "Airtable account page"
Your Airtable account page will open in a new tab, from there click the "Go to developer hub" button.
- Click Create Token
Click the blue Create Token
- Setup your personal access token using the following settings:
Name: This will be the name of the token, this can be whatever name you want.
Scopes: These are the permissions that the token will have access to.
You will want to select both:
data.records:read
&
data.records.write
Access: This is where you will set the specific airtable bases that this token will have access to. You can set a specific base needed, however for ease of use and convenience we recommend simply setting the access to All current and future bases in all current and future workspaces
Finally, click the blue Create Token button.
- In the new popup you can now copy your token and paste it into your builder's Access Token field
Note: It is important to keep your access token key private.
Back in the builder from the New Airtable Collection screen, click the blue hyperlink for Airtable API Page, then from the new tab select the table you wish to use as the collection, this will open the Airtable API documentation.
Under “Authentication” copy the example link
Return to the site editor and paste this link into the second field
- Click “Import fields”
Define the data type for each field and click continue. The following table outlines the Airtable field types and corresponding Without Code field types:
Airtable Field Type | Without Code Field Type | Details |
Text | Plain Text | |
Long Text | Text | Supports HTML and row breaks |
Checkbox | Boolean | Note: Only for custom widgets. |
Attachment with one image | Image | Image must be added through Airtable |
URL | Link | e.g. www.wocode.com |
URL or text | Video | e.g. https://www.youtube.com/watch?v=H9aIidxFxcI |
Phone number or text | Phone | e.g. 4036454798 |
Email or text | e.g. help@email.com | |
Text | Location | Format: streetaddress, postalcode, region, city, countrye.g. 666 Home St, 12345, CA, San Diego, US |
Text | Business Hours | e.g. SAT, SUN: 06:00-22:00; WED, THU, FRI: 09:00-11:00; |
Attachment with multiple images | Inner collection that contains one image field | Images added through Airtable. |
Number | Number | |
Currency | Text | Displayed without $ sign. |
Percent | Text | Displayed with decimal and without % sign. |
Rating | Text | |
Formula | Text | The result of the formula can be a string. |
Autonumber | Text |
Note: The builder will not import fields that are empty in the first 10 rows. This is due to API limitations.
Now, you can move on to Dynamic Pages, which will allow you to connect your collection.