Automated record roll up from multiple bases into one base

767 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

2 Replies 2


You may apply synchronization to achieve your goal

4 - Data Explorer
4 - Data Explorer

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)