+7Hello,
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.
+31If 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:
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:
I've created an example here for you!
+17Hi!
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.