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?
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)