I have a table with many fields to be updated by users. However, one of the field/column must only be updated by 2 users, not all users. Other users can only view this field. What can I do to avoid other users to update this field/column? Please advise any easy way to do it. Thank you in advance…
Solved! Go to Solution.
Hi, you can set user’s email address with the option called “Editable?”. You can write for example…
IN(USEREMAIL(),{userA@gmail.com,userB@gmail.com})
Hi, you can set user’s email address with the option called “Editable?”. You can write for example…
IN(USEREMAIL(),{userA@gmail.com,userB@gmail.com})
I am not able to find this option “Editable”. Please enlighten me. Thank you…
I found it. Thank you…
I used above expression. After that, other users cannot see the field. Is it possible to make it visible, non-editable field for other users?
Now I realize that if the field does not have value, other users would not see the field. If there is value, other users can see, but not edit. This is what I want. Thank you…
You’re welcome
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |