I intend on recreating my company’s current system in Airtable.
I have two separate departments that share the same customers. How could I create one base for each department but having a shared table of customers? Furthermore, both departments should be able to add a new customer to the shared table on the fly.
Sharing a table between bases is easy with the sync feature:
As for adding a new customer, that’s also pretty easy. Make a form view in the source table, and share that form with both departments. The form will add a new customer record to the table, which will then be synced to the other bases.