Oct 09, 2023 08:37 AM
Hi! I'm looking for a way to combine multiple Sync'd Table Views into a single Table. I feel like this should be relatively easy, but i'm not thinking about the solution properly. I'll explain below
I have 3 Project Teams, and each team has their own AirTable Base for tracking their staff, and a bunch of fields relevant to that.
I have a Studio Leadership Base, that has all 3 of these Projects syncing a view upwards so Leadership can see everything combined and create more holistic studio reports.
The Leadership Base looks like this:
Combined Studio Table / Project 1 Sync / Project 2 Sync / Project 3 Sync /
I'm a little stumped how to take Project 1, 2, and 3 tables and have all of that information appear in a single view in the Combined Studio Table
thanks in advance!
Solved! Go to Solution.
Oct 09, 2023 10:46 AM
Airtable calls it multi-source syncing:
Oct 09, 2023 10:21 AM
Hi @zlowery - can you give more examples of the reports that leadership wants to generate from the project information? For example, is it a bunch of relevant dates relating to the projects, numbers, or qualitative information?
My first thought would be to have the "Combined Studio Table" to have the first field be the project team i.e: Project 1, Project 2, Project 3. Then the next field would be a linked filed that connects the associated record you're tracking from the original project table. Then, depending on the data you're collecting, you could create a fourth table that links to the "Combined Studio Table" that consists of mostly rollup field to summarize the information you're looking for. Let's connect on LinkedIn - I'm always looking to expand my network with fellow Airtable users and enthusiasts
Oct 09, 2023 10:21 AM
That is a built-in feature of the Business Plan, but Airtable has unfortunately removed that from all lower plans.
Oct 09, 2023 10:36 AM
Im on the business plan, but I'm not seeing an easy way to do this...
Oct 09, 2023 10:46 AM
Oct 09, 2023 10:59 AM
Very helpful! Thank you