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

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 Solved
0 6 140
  • UX
1 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})

View solution in original post

6 REPLIES 6
Top Labels in this Space