Airtable

The Airtable Plugin can be used to pull data from Airtable into Bubble, as well as update Airtable records from Bubble workflows. The ideal use case for this plugin is to supplement your Bubble application with Airtable data, or vice versa. We don’t recommend using Airtable as your sole database because using your Bubble database will generally be more performant, since it won’t require API calls.

To connect an Airtable Table to Bubble, follow these steps

  1. Install the Airtable Plugin in the Plugins tab of the editor. Click “Add another Account” and fill out your Account Label and API Key.

The Account Label can be a label of your choosing. To find your API key, log into your Airtable account and navigate to https://airtable.com/account. Your API Key is here:

2. Start adding your Tables! Click “Add another Table”, then configure your Table information by first selecting a Base, then selecting a Table from the dropdowns. You can also optionally specify a View - this will impact the order in which your data returns from Airtable. For example, if you wish to see your records in the same order as they appear in your Table’s Grid view, specify this when you save your Table.

After you’ve saved your Table, you’ll see a popup where you can see your schema, make necessary changes, and specify which Tables your linked records refer to.

That’s it! You’re ready to use Airtable data in Bubble. If you’re having trouble with any aspect of the Airtable plugin, check out these FAQs before filing a support ticket:

FAQs

What are these special field types for the field dropdowns in the schema popup?

The field type dropdowns in the initialization popup have four special data types unique to Airtable: Attachment, Collaborator, Barcode, and Link to Record(s). This is for ease of use, to make it easier for you to map your Airtable columns to Bubble types. In practice, Attachment fields can be used like a list of images or files. Barcodes can be used like text. Since Collaborators and Links are native to Airtable, these fields must be pulled directly from Airtable when using a Table as data or creating/modifying records.

Why can’t I filter on all of my fields?

The filtering mechanism is done in the request we send to Airtable, so we have done as much as we can using the current API.

Why can’t I create or modify all of my fields?

Some fields in Airtable are generated by other fields, such as Rollups or Counts. Therefore, these cannot be altered or created via API calls.

Why aren’t all of my tables showing up in Airtable actions or when I search data from an external API?

Make sure your permissions are set accordingly. To use a Table in the Create and Modify actions, you must give it Create & Modify permissions. The same stands for the Delete action.

How do I create or modify special Airtable fields, such as attachments, linked records, collaborators, and barcodes?

You can use files or images in Bubble to create or modify Attachment fields in Airtable, and you can use text to create or modify barcodes. For linked records and collaborators, you must pull this directly from Airtable. For example, if you want to create a new record with a collaborator field, you would have to have that collaborator on another record already and pull from that.

What type of fields can I send to Airtable? Currently you can only send text and numbers over to Airtable. All other types, like the Date field, will cause an error as it is not yet supported.