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. Personal access tokens allow you to more securely grant API access to Airtable data.
Connecting Airtable
You can connect to Airtable from the data tab on the left menu bar or from the data section within a UI component. You'll need to enter a valid personal access token, and choose a base.
Obtaining a personal access tokens
To obtain your personal access token on Airtable's Developer Hub, follow the steps below:
Go to Airtable's developer hub page
Click on 'Create token'
Create a new token
Copy and save the token in a safe place.
When creating a new 'personal access token', please make sure you choose the 'data.records:write' scope if you need to view, add, edit, and delete records on Jetadmin's side.
Connect Airtable to Jetadmin
On Jetadmin's builder side, click 'Add Resource' from the data section on the left-side menu
Choose Airtable
Click on 'Sign In to Airtable' button
Click on 'Add a base'
Choose the needed base or workspace
Click 'Grant access'
Choose the base needed
Click the 'Choose tables' button
Select/unselect the needed tables and choose a view for each table
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:
Click 'Edit resource' from the resource's settings menu
Click on 'Choose tables'
Select the needed views for each table
Click 'Update resource'.
Last updated
