Hello all! I have a two part problem for you.
Our team is trying to figure out a way of syncing multiple tables, across different bases, into a singular table that will collect project information ( specifically start and end dates, capacity hours, etc) about each project we have running across the different project bases. This newly created table should be dynamic in updating its information as it is actively changed within those exterior bases and tables.
With this newly developed table, we wanted to then create a timeline view that measures team capacity (in workable hrs per week vs. how many hours each task takes to complete) across all of the collective projects. Ideally, this information is synced from the newly created table that is acting as a hub and contains all of this information from other bases.
Is this at all possible within Airtable, or have any workarounds been found to tackle a similar problem?
Thank you!