How to set a field (column) editable bases on user email

[AppSheet_Lectra]

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…

[Aleksi · Accepted 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})

[AppSheet_Lectra]

I am not able to find this option “Editable”. Please enlighten me. Thank you…

[AppSheet_Lectra]

I found it. Thank you…

[AppSheet_Lectra]

Aleksi:

IN(USEREMAIL(),{userA@gmail.com,userB@gmail.com})

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?

[AppSheet_Lectra]

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…

[Aleksi]

You’re welcome