Solved: Permission of action(s) in slice of data - Page 2

Gash · 07-24-2023 01:41 AM

Hi team,

I would like to control user permission of my data in slice to only add, but cannot be deleted from my users. I can add action but cannot find where or how to limit to only add.
I would like admin role to be able to delete while user role only view and add.

Many thanks

Suvrutt_Gurjar

For table level permissions, please take a look at the article

Control add, update, and delete operations - AppSheet Help

At slice level delete you could control through action 's following setting by using same expression as slice filter and by adding user email based expression to the over all expression, something like

AND( [Order Status]= "Complete",

ANY(SELECT(Users[Role],[Email]=USEREMAIL()))="Admin"

)

Where Users table is a table with a single row per user with user roles defined in the table.

Also for managing user roles in a better way, please take a look at the following landmark tip by @MultiTech

Current User (Slice) | How to conform your app a... - Google Cloud Community

View solution in original post