Oct 23, 2024 10:30 AM
Is it possible to create a base that pulls in different tables from different bases?
For example, if there are 4 different workspaces (brand) with it's own unique base, and each base has a tab called "X" - is there a way to create a net new base or interface that pulls in "X" tabs from the different bases so that this base can see all 4 "X" tabs in one place?
If yes, if/when any changes are made in "X" tab in the original base, will it update/sync with the net new base or interface?
Trying to find a solution in Airtable that can help with increased team access and visibility across teams that work on different brands to minimize duplicative work and increase cross-sharing, thus improve overall efficiency and productivity.
Oct 23, 2024 04:33 PM
Oct 23, 2024 05:26 PM
Yep! Check out the docs on sync.
You can even do two-way sync and multi source sync (many different tables to one table).
Specific functionality depends on what plan you're on.
Oct 23, 2024 06:41 PM
On a Business / Enterprise plan, yeap
You'd use multi source syncing to pull data from different tables into one table: https://support.airtable.com/docs/multi-source-syncing
Changes in the original X tables will show up in the new base / consolidated X table
---
I think you could also turn on two way syncing so that you can make changes in the consolidated X table and have it show up in the original X tables too
https://support.airtable.com/docs/two-way-syncing-in-airtable