Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to Sync Data Between Two Airtable Bases Using the API?

Topic Labels: Formulas
562 1
cancel
Showing results for 
Search instead for 
Did you mean: 
MackoSawko
4 - Data Explorer
4 - Data Explorer

Hi everyone,

I have two bases in Airtable: "Employees" and "Projects". Previously, I managed everything in a single base, but I decided to split the data for better clarity. Now, I want to fetch data from the "Employees" table in one base and automatically add it to the "Projects" table in another base using the API.

In the "Projects" table, I have an "Employee" field where multiple employees can be assigned to a single project (e.g., Project 1 has Employee 1 and Employee 2). I'd like these employees to be displayed as a list.

I already have an API token set up, but I'm not sure how to fetch the data and display it in the "Employee" field so that they can be added to a project. Could someone guide me on how to do this?

Thanks for your help!

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

With Airtable, it’s typically best & most convenient to keep everything in one base unless there is a security reason for separating the data.

However, if you’d like to keep the 2 tables in 2 separate bases, you don’t need to use the API to sync data. You can just use Airtable’s Sync feature to sync the data.

More details here:  https://support.airtable.com/docs/sync-overview-articles

— ScottWorld, Expert Airtable Consultant