Airtable Integration

Airtable Integration

In this article, we will cover how to create and set up an Airtable listing with permissions, search, filters.
 

Airtable Personal Access Token

Before you can start create listings with Airtable, you must create and add your personal access token to your workspace on Pory.
  1. Go to Personal Access Tokens on Airtable
  1. Create a new token with the following scopes:
    1. data.records:read
    2. data.records:write (include if you want to support user actions)
    3. schema.bases:read
  1. Add your new personal access token under the Airtable integrations from your workspace settings in Pory
    1. notion image
 

Creating a Airtable Listing

Pory provides the option to add Airtable blocks to your app for displaying information in either a listing, grid or table format. To get started:
  1. Click on the Add Section button
    1. notion image
  1. Select Airtable under the Display Data section and select a layout for the listing.
    1. notion image
  1. Hover over the section and click on the Edit Listing button
    1. notion image
 

Connecting Airtable Data

Connecting your Airtable data is simple, in the next few steps we’ll go over who this listing is for, where the data comes from and how we should display it.
 
  1. Selecting who this listing is for. A listing for everyone means everyone will see the same data and a listing for an authenticated user means they will see data that belongs to them based on linked records.
    1. notion image
  1. Where should we get your data? Select your Airtable base and table we should get your data from
    1. notion image
  1. Select how we should display your data. We support displaying data from Airtable views.
    1. notion image
  1. Click Connect Data
 

Listing View

Once you connect your data, you will be able to set up your listing and detailed view. The listing view are the records from your table displayed in a list of 12 by default. The detailed view is what the user sees when they select a record to view more information about.
 

Displaying Content

  1. Select the Fields option from the toolbar to start selecting the fields you would like to display in the listing.
    1. notion image
 

Search Settings

  1. Select the Search option from the toolbar and select which fields are searchable for the listing. E.g. Full Name, Title, Email
    1. notion image
  1. Configure placeholder and no results text (optional)
  1. Switch to the Styles tab to update the look and feel of your search bar
 

Filters Setting

  1. Select the Filters option from the toolbar and select a method for creating your filters. E.g. Generate using Single or Multiple Select fields.
    1. notion image
      Learn more about the methods here:
      ⚙️
      Filter methods
  1. Select the Settings tab for your filters (optional) to select a placement, placeholder and type of filters.
  1. Select the Styles tab to change the look and feel of your filters
 

Listing Appearance Settings

Supports editing the card appearance and layout of the listing.
  1. Select the Appearance option from the toolbar
 
Card Styles
  1. Update the card background, style, shadow and/or number of records to display
    1. notion image
 
Card Layout
1. Switch to Layout to update the layout of the listing
notion image
 

Permissions (Viewing / Creating / Editing / Removing Records)

Adding permissions will prevent the public or the wrong user group from viewing, creating, editing or removing records from your listing.
notion image
To set up permissions:
  1. Select the Permissions option from the toolbar
  1. Select a User Group to update what they can view, create edit or remove from the listing
  1. Select a user group to Preview as to learn more about their view
 

Detailed View

The detailed view is what the user sees when they select a record from the listing. You can build out this view using drag and drop blocks.
notion image
 

Appearance Settings

Here you can change the view type, background and layout of your detailed view
  1. Select the Appearance option from the toolbar
    1. notion image
 

SEO Settings

Dynamically create meta title, description and image for each detailed view using data from Airtable. This is especially useful if the selected view type is a page.
  1. Select the SEO option from the toolbar
  1. Select which field you would like to use for the title, description and image
 
Now when you share your detailed page, the meta information will be generated in the preview link.
notion image
 

Pretty URLs

By default, your listing uses the Airtable ids to generate a unique page link for each record. To override each link with a “pretty” url
 
Follow this guide to set this up here:
🔗
Pretty URLs
 

Permissions

This is the same global settings from the Listing View. Setting up permissions enables you to control what different user groups and view, create, edit or remove from your listing.
  1. Select the Permissions option from the toolbar
  1. Select the User Group you would like to edit permissions for