Security settings

[TomD]

Hi,

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?

Thanks

[Steve]

help.appsheet.com

Limiting Users to Their Own Data

You can use Security Filters to control which records a user can see and update.

help.appsheet.com

Limiting Users to Particular Tables, Views, and Actions

How to make sure that your users can see and do only what they need to

[TomD]

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.

Cheers!