Just one quick question about Table Sync.
Since we are new to Airtable and just started exploring it, trying to build our workflows and see if it can fit our needs, we thought to start utilizing this sync from the start for updating and maintinging some shared information.
Basically, we wanted to have on “Global” base where we could put tables with our clients, contacts, suppliers etc. and then sync those tables to other bases for our other departments. This way we won’t need to make separate tables for each department and would have single point that needs to be updated and maintained.
Question here is, there is no way for people in those other departments to update for example client list from their base (where they would have clients table synced from “Global”), only option is to update existing fields with button column option?. They would need to have access to “Global” database and directly add new client in origin table? Idea was to restrict access to this “Global” base so we don’t have lot of people adding, deleting etc., and just make it so that each department can add their own new clients to this centralized table from their own base where it is synced. Is there any possibility to setup something like this or this sync is strictly one-sided? Are there any plans maybe to make a two-way sync?
I hope I didn’t make it too complicated to understand
Thanks in advance!