The lack of this function is a fundamental flaw that contradicts the universal organization of a business.
Business is fundamentally about coordinating tasks between different facilitators (employees) to produce a product. A product has lifecycle stages (production, marketing, sales, customer service) that require different departments to facilitate it’s fulfillment, as well as departments to facilitate internal business items (legal, finance, admin, biz dev, R&D). Departments are grouped based on common skillsets and knowledge and have their own systems/procedures/data/assets etc which require different access levels - because you don’t want your production team looking at your sales pipeline and seeing how much money you make in your financials or viewing employee reviews and sensitive data in HR.
All business data is created around one central thing: the business! Therefore, a business’s data must be collective and relational, yet must be compartmentalized via different departments.
This is the problem with project management software - it is usually created with only one or 2 departments in mind, because it’s extremely challenging to make something that indeed does combine all data yet compartmentalize: you need a database program to do it…
Airtable is nearly the unicorn where you can actually run an entire business with all tasks and data in one place between different departments. The visualizations and functions are unbelievably amazing - yet you don’t allow the compartmentalization of departments through different bases, which fundamentally contradicts business.
To properly have collective relational data you must currently have all departments in one base, which means 1x base is theoretically the equivalent to 1x entire company, which makes Workspaces obsolete, and violates the rule of the need for department compartmentalization.
I would say the day is saved if zapier had a ‘update record then updates another record’ capability to sync records but I only see ‘new record updates another record’ so that means records cannot sync between bases through zapier… I hope I’m wrong and there’s a solution here…???
If you fix this one function a teenager could run a fortune 500 conglomerate from a Starbucks… hope it happens!
** Edit - just found @openside.com so that’ll prob do the trick, def a little pricey but well worth it I’m sure.