Search
K

Airtable

In this article, we'll review the integration with Airtable, and its characteristics and will go through the steps necessary to connect it to Jet Admin

API keys are deprecated by the end of January 2024.
Airtable's API keys stopped working and you will have to migrate to personal access tokens. However, you don't need a Personal access tokens to connect Airtable to Jetadmin. Just logging in with Airtable when creating a new resource is enough

Connect Airtable to Jetadmin

  1. 1.
    On Jetadmin's builder side, click 'Add Resource' from the data section on the left-side menu
  2. 2.
    Choose Airtable
  3. 3.
    Click on 'Sign In to Airtable' button
  4. 4.
    Click on 'Add a base'
  5. 5.
    Choose the needed base or workspace
  6. 6.
    Click 'Grant access'
  7. 7.
    Choose the base needed
  8. 8.
    Click the 'Choose tables' button
  9. 9.
    Select/unselect the needed tables and choose a view for each table
  10. 10.
    Click the 'Add Resource' button.

Choosing connection mode

After that, you need to choose how you'd like your Airtable to be integrated with Jet Admin. You can either connect directly or sync it with Jet's internal database to get extended functionality.
If you want to be able to combine your Airtable data with data from other data sources, such as Firebase, Google Sheets, or even REST API within the same tables, you should choose the "Sync" connection for Google Sheets. You can learn more about it here:
After having connected your Airtable, you'll be prompted to choose pages you want Jet Admin to generate an admin panel (CRUD pages) for.

Airtable Views

On Airtable side, you can create different views for each table. Each view allows you to filter and sort records. In Jetadmin you can choose to use only one view for each table when creating the resource. To view all records in each table, choose the main view 'All'.
The image below will show you the differences between the main view and the filtered views:

Switch Airtable's Views

To switch to other views for each table, follow the steps below:
  1. 1.
    Click 'Edit resource' from the resource's settings menu
  2. 2.
    Click on 'Choose tables'
  3. 3.
    Select the needed views for each table
  4. 4.
    Click 'Update resource'.