What we do
Tools
Industries
Department
How we workLet's talk →
Home/Airtable/Airtable Sync
Airtable

Setting Up Airtable Sync, and Knowing Which Direction It Runs

Your team keeps a list in one base and needs it in three others, or wants Salesforce opportunities next to the project tracker. Airtable Sync puts a live copy of those records in a table of your own. Whether you can edit them, and whether edits go back, depends on where they came from and which plan you're on.

Airtable Sync in short

From another base, in the source: pick a grid view, then turn on syncing for it.

Share and sync Sync data to another base

In the destination base: add the shared view as a new table, choose all fields or some, then set editing, frequency and what happens to deleted records.

+ Add or import Airtable base

Direction: one way unless you allow edits from other bases, which is two-way sync and needs Business or Enterprise Scale. Syncs from outside apps such as Salesforce or Jira are always one way into Airtable.

Plans: Sync isn't on the Free plan. Team, Business and Enterprise Scale have it with different limits.

One-way and two-way Airtable sync, side by side

One-way

The source stays in charge

  • You can't add or delete records in the synced table, or edit the synced fields.
  • You can add your own fields beside them, link them to other tables, and build views, lookups and automations on them.
  • Your added fields stay in this base and never go back to the source.
  • The only option for Salesforce, Jira and every other outside app.
Two-way

Edits travel back to the source base

  • Turned on with Allow edits from other bases on the source view.
  • Airtable to Airtable only, on Business and Enterprise Scale.
  • In a multi-source sync, every source table needs it switched on.
  • Good for a central list that several teams keep up to date from their own bases.

If the record you want to change lives in Salesforce, Jira or Zendesk, two-way sync won't help: the change has to be written to that system through its own API. n-frames builds that write-back, so a status set in Airtable updates the source record too.

Where the records come from decides what Sync can do

The records live in How they get into your base Know this first
Another Airtable base Base-to-base sync, on all paid plans. Updates come through in real time. Two-way editing only on Business and Enterprise Scale. Team allows up to 10 synced tables per base, the higher plans 20.
Google Drive, Google Calendar, Box, GitHub or Miro A standard sync integration, on all paid plans. Automatic refresh as often as every 5 minutes, and a cap of 10,000 records per integrated source.
Salesforce, Jira Cloud, Zendesk, Tableau Online or emailed data A premium sync integration, on Business and Enterprise Scale. Always one way. A change made in Airtable never reaches the Salesforce or Jira record.
Jira Data Center or Server, Adobe Experience Manager An on-premises integration, on Enterprise Scale only. The source runs on your own servers, so plan for your IT team to be involved from the start.
An ERP, booking tool, warehouse system or your own database Not on the list. Use Airtable's Sync API (a premium source that takes rows your own code sends) or the regular Web API. Something has to pull from that system, shape the rows and send them on a schedule. n-frames builds and runs that pull.

When a synced table stops matching its source

It quietly stopped updating

How you'll know: The synced records are days old, though nothing shows an error.

Fix: Airtable eventually pauses automatic syncs on bases nobody has used lately. Use Sync now from the table's menu, which works on any plan, and expect it to happen again on quiet bases.

Records disappeared, along with your notes on them

How you'll know: Rows filtered out of the source view are gone, and so are the fields you'd added to them.

Fix: The table is set to Delete the records in this table. Switch it to Leave the records in this table, and clear old ones yourself with Delete unavailable records when you're ready.

Only part of the source came across

How you'll know: A Salesforce or Jira sync stops at a round number.

Fix: Integrated syncs cap at 10,000 records per source. Filter the source down to the records the base actually uses, or split it across sources.

The field won't let you type in it

How you'll know: Synced fields look locked, even for a base owner.

Fix: That's one-way sync working as designed. Add a field of your own next to it for local notes, or move to two-way if both sides are Airtable bases on a plan that allows it.

Questions people ask

What sources can Airtable Sync pull from?

Other Airtable bases, plus a set of sync integrations: Google Drive, Google Calendar, Box, GitHub and Miro on all paid plans; Salesforce, Jira Cloud, Zendesk, Tableau Online, emailed data and the Sync API on Business and Enterprise Scale; and Jira Data Center or Server and Adobe Experience Manager on Enterprise Scale.

Can I edit a synced table in Airtable?

Not the synced fields in a one-way sync, and you can't add or delete its records. You can add your own fields, links, views and automations around them. If the source is another base and you're on Business or Enterprise Scale, allowing edits from other bases makes the synced records editable.

Does Airtable Sync work in both directions?

Only between Airtable bases, and only on Business and Enterprise Scale plans. Sync integrations from outside apps always run one way, from the app into Airtable.

What if the system I need isn't on Airtable's supported Sync list?

On Business or Enterprise Scale, the Sync API lets your own code send rows into a synced table. On any plan, the Web API can create and update records directly. Either way something has to read the other system and run on a schedule, which is the part n-frames builds and looks after.

Is Airtable Sync included on every plan?

No. It isn't on the Free plan. Team has it with lower limits (10 synced tables per base) and no two-way sync. Business and Enterprise Scale allow 20 synced tables per base, two-way sync between bases, and the premium integrations.

How often does an Airtable sync refresh?

Syncs between bases update in real time. Sync integrations refresh automatically as often as every 5 minutes, and Sync now in the table's menu runs one by hand.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.