Airtable
Learn how to build an app in Noloco around your Airtable base

If you're storing data in Airtable, you can easily connect your Airtable base(s) to your Noloco apps and allow your team or customers to read, update and create records in Airtable directly from your Noloco app.

  1. 1.
    Add your Airtable data source Navigate to the data tab in your Noloco app and click to add a new data source. From the list, choose Airtable.
2. Name your data source It's best practice to call the data source the same name as your base to help you keep track.
3. Find & enter your Airtable API key Follow the link to your Airtable account page. Copy your personal API key from the API section.
4. Enter the Sharing link to your Airtable base Navigate to the Airtable base that you want to connect to Noloco. Click 'Share' near the top right of the page in Airtable. Select 'Base' from the first pop-up that says 'Add collaborators'.
Create a 'Shared link to the whole base'. Choose the 'Private read-only link' option. Finally, copy the shared base link and paste into Noloco.
Note: if your base is password protected, hit the toggle in Noloco and enter the password
Once you've entered all this information from Airtable, click 'Next'.

Noloco will analyse the data in your Airtable base and will automatically create tables and views in your app around your data from Airtable. For example, if you have a table with Properties data in Airtable, we'll automatically create a collection list view, record view to edit individual records and a form to add new Properties data. You can then use our App Builder to configure the display, add filters and set user access levels (i.e. which users can see and update what information).

When your app users update data from Noloco, it will be reflected instantly in your Airtable base. If an update is made to your Airtable base directly (e.g. via an automation), the updated data should be reflected in Noloco in less than 1 minute.

Yes - you can connect multiple Airtable bases to the same Noloco app. You can also mix and match with other data sources as well (e.g. Noloco Collections or Google Sheets).

If you have tried doing a manual sync of your Base's schema but one of your fields still won't appear in Noloco this can mean one of two things:
  • We don't support that type of field Buttons, URLs and collaborator fields are currently unsupported
  • The name of the field clashes with a previous name of an existing column If you ever renamed a column and now the new field has the same name as that older column we will not be able to sync that field to Noloco until the older, existing field is deleted, or the new field's name is changed (in any way).

Sometimes Airtable will choose different default formatting to Noloco for formula fields. For instance a formula field that is formatted as an integer in Airtable may appear as a decimal when synced to Noloco.
If this happens to one of your fields there is a simple fix to force Airtable to tell us about how we should format the field:
  1. 1.
    Open up the type configuration for your formula field in Airtable
2. Navigate to the formatting options
3. Click save Make sure to save the settings even if the selected format is what you currently see on Airtable; this will make Airtable explicitly tell Noloco how to format your field.

If your lookup field is based on a multi-relationship field (either many-to-many or one-to-many), when we sync it into Noloco we will convert it to a TEXT field and sync its contents as a comma-delimited list of values. The reason for this is that Noloco does not support array or collection types, except for relationships. At the same time we want to make sure that you can see all data for a field displayed in it. To achieve this balance we convert these fields to comma-delimited lists and store the raw data from Airtable inside them, meaning you won't see your formatting applied.
Lookups based on single relationships (one-to-one or many-to-one) will be synced as their underlying type with any formatting brought along. If you need formatting to be applied to a multi-lookup we recommend you look at your data model to see if you can use relationship or single-lookup fields instead.
Copy link
On this page
Overview
Connect your Airtable base
What happens next?
FAQs