- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 18, 2024 08:29 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 18, 2024 12:43 PM
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
