Automated record roll up from multiple bases into one base

[Chris_Conant]

I have three subcontractors working in separate (but similar) bases. For NDA reasons they can’t work out of the same base. However, for better admin, I would like to roll up all their records into a single base? And I would like it to be automatic, so whenever they make a change to a record in their base it updates it in the master base. Is this possible?

[Alexey_Gusev]

Hi,

You may apply synchronization to achieve your goal
https://support.airtable.com/hc/en-us/articles/360052933854-About-syncing

[Brendon_Thwaite]

I have a similar challenge to this. In my case I am the contractor and I am trying to consolidate billable hours across all of my client projects which are each in separate bases. I have managed to use table sync to pull information into my master base for each project however I have no idea how to represent a consolidated view or a chart with combined data. A chart option in a dashboard interface doesn’t seem to allow me to span across multiple tables at the same time and consolidate the info. 

Month / client / hours (this info is grouped in a sync table for each project)