Security settings


I am trying to accomplish the following:

I have one table for inventory management for several locations.
Each location has a specific user id, linked to that location via a column [useremail]

The users are only allowed to add/edit/delete their own entries (entries made with the user email that they are signed in with). I can get this right by using the security filter [useremail]=useremail(). This limits their visible data however only to their own location.

I am also trying to give them read only access to all other locations.

How can I get that done?


1 Like

That helped, thanks Steve

Was a bit of work reprogramming slices, security filters etc.
What mainly did the trick was the use of an expression in the update/edit behavior.