Solved

Combine Multiple Syncd Table Views into a Single Table for holistic reporting

Forum|Forum|2 years ago
October 9, 2023
5 replies
251 views

+4

zlowery
Participating Frequently

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!

Best answer by ScottWorld

Airtable calls it multi-source syncing:

https://support.airtable.com/docs/multi-source-syncing

+5

salvadaor
Participating Frequently
Forum|Forum|2 years ago
October 9, 2023

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

Custom builds for your needs. Reach out if you want to talk!