Mar 28, 2024 03:10 AM
Hello, On my Database I have a table called "inventory".
On my work spase i have two users, me as an admin and the second as an Editor user only.
In the Inventory table i want that the second user will be able to create his own records and edit them, but cannot edit my records- right now he cannot delete the whole record but he can delete the values in his fields.
Is this possible?
Mar 28, 2024 05:52 AM
Yeap, you'd need to use an Interface for this though. You'd create an Interface page with a Grid filtered to only show records that were created by the current user:
This would only let them see their own records though
If you wanted to let them see their own records and edit them, and also see everyone else's records without being able to edit them, you could do it with two Grid elements like so:
The first Grid is filtered like so:
While the second Grid is filtered like this:
Mar 31, 2024 03:02 AM
Thank you very much for the help, I've actually didn't manage to do it yet but i'll try again and hope to succseede.