Skip to main content

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?

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:


Link to base


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:


Link to base


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. 


Reply