Re: Non-Admin user can only edit his records

365 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

2 Replies 2

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:

Screenshot 2024-03-28 at 8.48.55 PM.png

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:

Screenshot 2024-03-28 at 8.51.01 PM.png
The first Grid is filtered like so:

Screenshot 2024-03-28 at 8.51.05 PM.png

While the second Grid is filtered like this:

Screenshot 2024-03-28 at 8.52.38 PM.png
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.