Hi, this time I am having a problem with the edit permissions. My goal is to make a field editable only for supervisors or managers and not for employees. So I create a new sheet in my database called “Supervisors” and I include their email addresses.
In the “Editable If” field I use the following expression:
(USEREMAIL()) is one of the values in the list (Supervisors[Email])
Then I test in the section “Preview App as” the mails of the supervisors that are inside my sheet “Supervisors”. The first email takes it correctly and lets me edit the field. The second email does not recognize it and does not let me edit the field.
I have been trying with several expressions but I always get the same thing. With one email I have permissions to edit and with the other one I don’t, when it is supposed that with all the emails that are in that list I should have those permissions to edit.
Could it be that I am doing something wrong? Or am I missing some expression?
As you can see below with the email firstname.lastname@example.org it does not let me edit the field.