Let’s say I want each user to see only their own data. As far as I understand, I need to create a separate base for each of them.
Are there any internal NocoDB mechanisms so that I can synchronize data from a common base as well as collect data from an employee’s base into the common one or admin’s base? Without using external tools.
If I have to use external tools, what software can help me synchronize and copy data?
Cheers!
@oshliaer Welcome to NocoDB community!
As you have rightly pointed out, you will have to create a separate base for each user if you wish them to see only their own data.
For sync between bases, there are no internal mechanisms supported.
Can you add little more details about your use-case?
I would also like to note that I might be able to make a service that would sync databases using webhooks or REST APIs. I just wanted to know if it was possible to do it, for example, via the NocoDB internal API (you already answered No, thanks).
Do you think I could try to use a database API, for example, functions, to do this? Or does the NocoDB structure require more attention than just copying data?
Yes, of course.
Let’s imagine that I have a CRM. My managers should not see other clients, only those they work with. I should see all clients in my system.
For example,
Manager 1 sees Client 1, Client 2, and Client 3
Manager 2 sees Client 4, Client 5, and Client 6
I, as an administrator, see all clients