Hi, I am trying to show a specific Data colu...

(Timothy Martin) #1

Hi,

I am trying to show a specific Data column to only certain users of my app.

I want it to show data if the email address in the email colmn is the same as the logged in users email or if the logged in user email is one of the specified emails. I am using the below code in the show if field and it is not working. It does not show the data to anyone with the below. What am I doing wrong?

=[Email] = useremail()

=useremail() = "email1@email.com" =useremail() = "email2@email.com"

=useremail() = "email3@email.com"

(Timothy Martin) #2

I am actually figured it out. I am using an OR statement and now it works.

(Aleksi Alkio) #3

OR(USEREMAIL()=[Email], IN(USEREMAIL(),{email1@email.com,email2@email.com,email3@email.com}))