Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Sync Two Table Bases Into One?

160 0
cancel
Showing results for 
Search instead for 
Did you mean: 
triplexmen
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

 

I manage two different teams - Team A & Team B. Both of these teams have their own separate base with their own projects. 

How I capture all of their projects into one grid table without having to do manual entry? I would like to have them sync together since their projects can associate with eachother. 

2 Replies 2

If you've got a Business plan, multi-source syncing would be the way to go: https://support.airtable.com/docs/multi-source-syncing

You'd create one new base and sync the Projects table from Team A and Team B into a single table like you want

---

If you're on a Teams plan, you'd need to sync those Projects tables to one table each in the new base, and then use an automation to consolidate it.  Here's how it'd end up looking:

Screenshot 2025-01-31 at 10.41.06 AM.png

And your automation would trigger whenever a new record gets created in the synced table, and it'd create a new record in the 'Combined' table and link it back to the new record:

Screenshot 2025-01-31 at 10.41.03 AM.png

I've created an example here for you!

matthew_b
7 - App Architect
7 - App Architect

Hi!

If you just want the data to go from Base 1 to Base 2 (one-way) then you can use Airtable's native Sync feature.

If you want the data to sync between Base 1 and Base 2 bi-directionally (two-way) then you might opt for Whalesync which handles that for you:

https://www.youtube.com/watch?v=KZC_zKcHXek

 

Here's how to connect and integrate two Airtable bases. In this step-by-step guide, we'll first show you how to use Airtable's native "sync" feature which sends data from one Airtable base table to another. This is extremely simple but also limited. We'll then show you the more advanced way to set