Help with user role/access to a Table

[Robert_Addo_Dar]

I need help with a formula or code that grants specific useremail() access to edit a table.

The table is currently READ_ONLY to all USEREMAIL() but need a code that will allow USER1 only to edit Table whiles it still remains READ_ONLY to USER2, USER3 & so on…

Any help will be appreciated very much

[Suvrutt_Gurjar · Accepted solution]

Hi @Robert_Addo_Darko,

Welcome to AppSheet community.

Please go to Data --> Table option --> Are Updates Allowedoption and please write an expression something like below

SWITCH(USEREMAIL(),
“user1@mydomain.com”, “UPDATES_ONLY”,
“READ_ONLY”)

If you wish USER 1 to only edit the records and not add to it. Here “user1@mydomain.com” is the email of the USER1. Other users will have READ_ONLY access.

OR

SWITCH(USEREMAIL(),
“user1@mydomain.com”, “ALL_CHANGES”,
“READ_ONLY”)
If you wish USER 1 to add, edit and delete the records. Here “user1@mydomain.com” is teh email of the USER1. Other users will have READ_ONLY access.

Please take a look at following articles too.

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

help.appsheet.com

Controlling Add, Update, and Delete

How to determine how much your app users can modify data.

[Robert_Addo_Dar]

This means a lot. Thanks for the help. Tried to use this expression earlier but didn’t understand it. Thanks for the explanation.

Much much appreciated