We are working with different clients on different Airtable bases. Also internally not everyone is working on every base. We do not want to change this (and include all client data in one base) also for security reasons.
But for Management I am trying to do a Base/View/Interface where the Management Team can access e.g. all upcoming campaigns for all clients, without clicking through multiple bases or tabs. Meaning this base should be feeding from all existing client bases. Being able to make changes in this base is not prio 1 (but would be a nice to have though).
All bases would have the same setup/columns based on the same template
If I would sync all client bases to e new tab within my "management view base", would Interfaces allow me to show everything at one glance?
Is this possible and if so, how would I do it?