Hi Airtable gurus,
I'm working with a set of bases structured in the following logic:
- Partner base: list of partners and their metadata (e.g. legal status, primary contact, website etc.)
- Case base: list of cases and their metadata (e.g. region, industry, case manager etc.)
- Practice bases (multiple): combines where partners are impacting cases. (Yes ideally this would have been one master base, but for reasons outside of my control right now that is not something we can play with)
- Case x Partner rollup: base that rolls up all the individual practice base activity
We are now trying to build a single interface that can display the partner information and to display analytics for cases by partner (and for e.g. region and industry cuts of the case activity) but I'm finding it difficult to connect back the partner base to these transactional records of 'cases x partner' so that it can be displayed in a single interface. I have tried various hacks to aggregate and send case counts to the Partner table but have yet to find a solution that doesn't require me to manually add a partner name to a field every time a new row is added to the data set.
Should we be using 2 way sync to solve for this problem? Should I be changing where the interface is pulling from (Case x Partner?) Not necessarily looking for a silver bullet, but any recommendations or ideas on how to make this the most flexible for analytics/reporting of both data sets would be very helpful!