Strict right of allow other value to admin

How can I restrict rights of allow other value in drop down list to admin only or any specific user

5 REPLIES 5

What I did was create a Slice Only Read from the table

I Just want to know whether it is possible to allow other value in any list to Admin only, only admin can create new item in list and user only get the option from existing list

 

As per my understanding, within the column setting itself one will not be able to make it possible based on user's email or profile.

There are of course somewhat longish workarounds.

You can restrict items shown on a list based upon user, put an expression in the Suggest Values field for the list column. In the expression you would define the list values (either hard coded list or selecting from another table) and restrict the values to specific users with conditional statements.

 

appsheet_rebrand_logo.pngSuggested Values for a Column

How to suggest a dynamic list of values for a column

 

LOOKUP(USEREMAIL(),'Employee','Email','Role)='ADM'

an idea is in the behavior to put permission to add new values of for ADM

 

Top Labels in this Space