Bubble Docs
  • Introduction
  • New? Start Here
  • What is Bubble?
  • The Glossary
  • User manual
    • Getting started
      • What is Bubble?
      • Building your first app
        • Planning features
        • Database structure
        • Design and UX
        • eCommerce and payments
          • Shopping cart
          • Checkout page
          • One-time payments
          • Subscriptions
          • Marketplace
      • Creating and managing apps
      • The Bubble editor
        • Tabs and sections
          • Design tab
            • The element tree
            • The property editor
          • Workflow tab
          • Data tab
          • Styles tab
          • Plugins tab
          • Settings tab
            • Application settings
              • Custom headers/body
              • Visual settings
              • Social media sharing
              • Translating your app
              • Email settings
              • Collaboration
            • Custom domain and DNS
          • Logs tab
        • Tools
          • Key features
          • The search tool
          • The Issue Checker
          • The element tree
          • The element property editor
          • The debugger
          • Notes
        • Previewing your app
      • Transitioning to Bubble from...
        • JavaScript
        • HTML and CSS
        • SQL
    • Design
      • Elements
        • The element hierarchy
          • The element tree
        • The page
        • Containers
          • Groups
          • Repeating groups
          • Table elements
          • Popups
          • Floating groups
          • Group focus
        • Visual elements
        • Input forms
          • Text and numbers
          • Dates and time
          • File uploads
          • Selection controls
        • Reusable Elements
      • Styling
        • Color variables
        • Font variables
        • Styles
        • Custom Fonts
      • Responsive design
        • Building responsive pages
        • Legacy articles
          • The Basics (Legacy)
          • Building Responsive Pages (Legacy)
          • Migrating Legacy Pages
          • Tips When Designing (Legacy)
      • Templates
      • The Component Library
      • Importing from Figma
    • Data
      • The database
        • Data types and fields
        • Creating, saving and deleting data
        • Finding data
        • Displaying data
        • Protecting data with privacy rules
        • The database editor
        • Export/import data
          • Exporting data
          • Importing data (CSV)
        • Working with location data
        • Using Algolia
        • Database structure by app type
          • Marketplace Apps
          • Directory & Listings Apps
          • Social Network Apps
          • SaaS Apps
          • Project Management Apps
          • CRM Apps
          • Professional Services Apps
          • On-demand Apps
          • Documentation/ CMS Apps
          • Applicant Tracking System (ATS) Apps
          • Portfolio Apps
          • Gallery Apps
          • Online Store / Ecommerce Apps
          • Blog Apps
          • Messaging App
          • Dashboards
          • Building Block Apps
          • Bubble as a backend
      • Files
      • Images
      • Static data
        • App texts (translations)
        • Option sets
      • Temporary data
        • Custom states
        • URL parameters
      • User accounts
        • Authentication plugins
          • Facebook plugin
          • Fitbit plugin
          • Google plugin
          • Instagram plugin
          • LinkedIn plugin
          • Pinterest plugin
          • Slack plugin
          • Wistia plugin
          • YouTube plugin
        • Cookies set by Bubble
      • Time, dates and time zones
    • Logic
      • The frontend and backend
      • Workflows
        • Events
          • Frontend events
            • Recurring workflows
            • Custom events
          • Backend events
            • Database trigger events
        • Actions
        • API Workflows
      • Dynamic expressions
      • Conditions
      • Navigation
        • Single-page applications (SPA)
        • Multi-page applications
        • Page slugs
    • Workload
      • Understanding workload
        • Activity types
        • The workload calculation
        • Client-side and server-side processing
      • Tracking workload
        • Measuring
          • Using App Metrics
        • Monitoring
          • Workload notifications
          • Infinite recursion protection
      • Optimizing workload
        • Optimization framework
        • Optimization checklist
          • Page load
          • Searches
          • Workflows and actions
          • Backend workflows
        • Agency showcases
          • Minimum Studio
          • Neam
          • Support Dept
    • Security
      • Bubble's security features
      • Planning app security
      • Client-side and server-side
      • Bubble account security
      • App security
      • Page security
      • Database security
      • API security
        • API Connector security
        • Data API security
        • Workflow API security
      • Flusk
        • Overview
        • Flusk plan features
        • Getting started with Flusk
        • Flusk security tools
          • The Issues Explorer
          • Issue details
          • Tools and settings
            • Pages rating
            • Database rating
        • Flusk FAQ
      • Cookies
      • Security checklist
    • Publishing your app
      • Web app
      • Native mobile app
        • Global native mobile settings
        • iOS App Store
        • Google Play Store
        • Publishing FAQ
    • AI
      • Generate apps with AI
        • About AI app generation
      • AI page designer
      • Connect to AI agents
    • Maintenance
      • Collaborators
      • Version control
        • Best practices: Version control
        • Transitioning from the legacy version control
        • Terminology: Version control
        • Version Control (legacy)
      • Commenting
      • Database maintenance
        • Copying the database
        • Restoring database backups
        • Bulk operations
          • Bulk operation methods compared
        • Wiping change history
      • Performance
        • Hard limits
        • Capacity Usage (legacy)
        • Notes on queries
      • SEO
        • Introduction to SEO
        • SEO: App
        • SEO: Page
      • Testing and debugging
        • Introduction to testing and debugging
        • The debugger
        • The server logs
        • Supported browsers
      • API workflow scheduler
    • Integrations
      • API
        • Introduction to APIs
          • What is a RESTful API?
        • The Bubble API
          • Bubble API terminology
          • Authentication
            • How to authenticate
            • No authentication
            • As a User
            • As an admin
          • The Data API
            • Data API Privacy Rules
            • Data API endpoints
            • Data API requests
          • The Workflow API
            • Workflow API privacy rules
            • Workflow API endpoints
            • API workflows
              • Creating API workflows
              • Scheduling API workflows
              • Recursive API workflows
              • API Workflow Scheduler
              • Case: Stripe notifications
        • The API Connector
          • Authentication
          • API Connector security
          • API guides
            • OpenAI
              • Authentication
              • Calls
                • ChatGPT
                  • Chat
            • Google Translate
              • How to setup Google API keys
          • Streaming API
        • API security
        • Plugins that connect to APIs
        • API Glossary
      • Plugins
        • What Plugins Can Do
        • Installing and using Plugins
        • Authentication plugins
        • Special Plugins
      • SQL Database Connector
      • Bubble App Connector
      • WorkOS
        • WorkOS SSO
        • WorkOS API
    • Infrastructure
      • Sub-apps
      • Bubble release tiers
      • Hosting and scaling
        • How Bubble hosting works
        • Scaling with Bubble
        • CDN (Cloudflare)
        • Bubble app names
        • Domain and DNS
      • Compliance
        • GDPR
        • SOC 2 Type II
        • HIPAA
        • Other frameworks and standards
    • Bubble for Enterprise
      • Hosting and infrastructure
        • Dedicated instance
          • The Dedicated editor experience
          • Technical specs
          • Main cluster dependencies
          • Customizable options
          • Migration process
            • Pre-migration
            • During migration
            • Post-migration
      • Security and compliance
        • Single sign-on (SSO)
        • GDPR
        • SOC 2 Type II
        • HIPAA
        • Other frameworks
        • Bubble's security features
      • Admin and collaboration
      • Priority support
      • Billing and Payment Guideline for Dedicated Instances
  • Core Reference
    • Using the core reference
    • Bubble's Interface
      • Design tab
      • Design tab (Legacy)
      • Workflow tab
      • Data tab
      • Styles tab
      • Styles tab (Legacy)
      • Plugins tab
      • Settings tab
      • Logs tab
      • Template tab
      • Toolbar
      • Top and context menu options
      • Deployment and version control
        • Deployment & Version Control Dropdown (legacy)
      • Notes
    • Elements
      • General properties
      • General properties (Legacy)
      • Styling properties
      • Styling Properties (Legacy)
      • Responsive Properties
      • Responsive Properties (Legacy)
      • Conditional formatting
      • States
      • Page Element
        • Page Element (Legacy)
      • Visual Elements
      • Containers
      • Container Layout Types
      • Containers (Legacy)
      • Input Forms
      • Reusable Elements
      • Element Templates (legacy)
    • Workflows
    • Events
      • General events
      • Element events
      • Custom events
      • Recurring event
      • Database trigger event
    • Actions
      • Account
      • Navigation
      • Data (things)
      • Email
      • Element
      • Custom
    • Data
      • Data Sources
      • Operators and comparisons
      • Search
      • Privacy
    • Styles
    • API
      • The Bubble API
        • The Data API
          • Authentication
          • Data API endpoints
          • Data API requests
        • The Workflow API
      • The API Connector
        • Authentication
        • Adding calls
    • Bubble-made Plugins
      • AddtoAny Share Buttons
      • Airtable
      • API Connector
      • Blockspring
      • Box
      • Braintree
      • Bubble App Connector
      • Chart.js
      • Circle Music Player
      • Draggable Elements
      • Dropzone
      • Facebook
      • Fitbit
      • Full Calendar
      • Google
      • Google Analytics
      • Google Optimize
      • Google Places
      • Ionic Elements
      • iTunes
      • Slidebar Menu
      • LinkedIn
      • Localize Translation
      • Mixpanel
      • Mouse & Keyboard Interactions
      • Multiselect Dropdown
      • Progress Bar
      • Rich Text Editor
      • Rich Text Editor (Legacy)
      • Screenshotlayer
      • SelectPDF
      • Slack
      • Segment
      • Slick Slideshow
      • SQL Database Connector
      • Star Rating
      • Stripe
      • Tinder-like Element
      • Twitter
      • YouTube
      • Zapier
    • Application Settings
      • App plan
      • General
      • Domain / email
      • Languages
      • SEO / metatags
      • API
      • Collaboration
      • Sub-apps
      • Versions
  • Account & Marketplace
    • Account and billing
      • Pricing and plans
        • Plans and billing
        • Billing cycle
        • FAQ: Pricing and Workload
      • Account Management
      • Building Apps for Others
      • Selling on the Marketplace
      • Plans & Billing (legacy)
    • Official Bubble Certification
      • Hiring certified developers
    • Building Plugins
      • The Plugin Editor
      • General Settings
      • Updating to Plugin API v4
      • Adding API Connections
      • Building Elements
      • Building Actions
      • Loading Data
      • Publishing and versioning
      • Github Integration
    • Building Templates
    • Application and data ownership
    • Marketplace policies
    • Bug reports
  • Beta features
    • About the Beta features section
    • Native mobile apps 🔒
      • Introduction
        • What is a native mobile app?
        • Native mobile vs. web development
        • Differences in native and web elements
        • Native mobile app terminology
      • Building
        • Views and navigation
        • Native mobile actions
        • Components and gestures
        • Device resources
          • Location services
          • Camera/photo library
      • Previewing
      • Publishing
Powered by GitBook
On this page
  • Create a new Record
  • Type
  • Delete a Record
  • Type
  • Record
  • Modify a Record
  • Type
  • Record
  • Setup
  • Install & configure
  • Create a token
  • Add the token to the plugin
  • Add tables
  • Use Airtable as a data source & workflow action
  • FAQ
  • What are these special field types for the field dropdowns in the schema popup?
  • Why can’t I filter on all of my fields?
  • Why can’t I create or modify all of my fields?
  • Why aren’t all of my tables showing up in Airtable actions or when I search data from an external API?
  • How do I create or modify special Airtable fields, such as attachments, linked records, collaborators, and barcodes?
  • What type of fields can I send to Airtable?
  • What happens if I rename my table in Airtable?

Was this helpful?

  1. Core Reference
  2. Bubble-made Plugins

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.

While it's possible to use Airtable as your sole database with Bubble, we don't recommend that approach. The built-in Bubble database will generally be more performant (since it doesn't require API calls to be sent via Bubble's server), and it lets you control privacy using .

Create a new Record

Add new records to your Table. To use this action, check the box to “Create & Modify” this Table in the Plugins tab.

Type

Enter the type of record to create. This will match the name of the Table where you want to add the record.

Delete a Record

Remove existing records from your Table. To use this action, check the box to “Delete” from this Table in the Plugins tab.

Type

Enter the type of record to delete. This will match the name of the Table where you want to remove the record.

Record

The existing record to delete. For example, if you are displaying a list of records from Airtable in a repeating group, this could be the current cell’s thing.

Modify a Record

Type

Enter the type of record to modify. This will match the name of the Table where the record exists.

Record

The existing record to modify. For example, if you are displaying a list of records from Airtable in a repeating group, this could be the current cell’s thing.

Setup

In the first half of 2023, Airtable announced that they would be phasing out support for API Keys and moving everyone to use Personal Access Tokens instead by February 2024. The Airtable plugin already supports Personal Access Tokens and we’ve updated the UI on the plugin to reflect the right terminology.

Install & configure

Install the Airtable Plugin in the Plugins tab of the editor. Click “Add another Account” and fill out your Account Label and Personal Access Token.

The Account Label can be a label of your choosing.

Create a token

Set up the and settings, give the token a and again click Create token.

The token will be created and displayed once – keep the token securely stored. We recommend using an encrypted password manager to store tokens.

Add the token to the plugin

After you have created the token, you can add it to the plugin settings. Copy the string and paste it into the Personal Access Token field in the plugin settings:

Add tables

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.

Use Airtable as a data source & workflow action

Once set up, the app will be able to read and write to the connected Airtable base(s). For example, in a dynamic statement, you can use "Get data from an external API" to select the Airtable base as the API provider. Upon doing so, you can even add search constraints.

You will also be able to write changes back to Airtable, via workflow actions that will show up in the "Plugins" section of the action selector.

FAQ

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.

What happens if I rename my table in Airtable?

If you rename a table that you have previously connected, this can cause existing references to fail until Bubble knows the updated name. You can resolve this by going into your Plugins tab, finding the particular instance whose table name you want to update, and clicking the Base dropdown as if you would select a different base but selecting the same base again. You should now see the new table name.

Last updated 1 year ago

Was this helpful?

External link:

To create a Personal Access Token, log into your Airtable account, navigate to and click Create token.

Note that the scopesand are required for the plugin to work correctly.

When you are configuring a table, you must also add the appropriate scopes and access to the relevant Personal Access Token through the.

Airtable announcement post
https://airtable.com/create/tokens
schema.bases:read
data.records:read
Airtable console
The token will only be displayed once – keep it securely stored somewhere.