How can I restrict rights of allow other value in drop down list to admin only or any specific user
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.
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
User | Count |
---|---|
43 | |
27 | |
24 | |
22 | |
13 |