I'm trying to restrict a certain tables to on...

expressions
(WAN AHMAD SHAILFULDDEEN BIN WAN NAWI) #1

I’m trying to restrict a certain tables to only two users. Is this expression correct : USEREMAIL()= abc@email.com, def@email.com correct?

Please advice.

(Bellave Jayaram) #2

IN(USEREMAIL(), LIST(“abc@email.com”, “def@email.com”))

(Simon Adcock) #3

@Bellave_Jayaram can you use this expression with just the domain part of the email?

(Bellave Jayaram) #4

@Simon_Adcock you can use CONTAINS instead of IN.

CONTAINS (LIST(“domain1”, “domain2”), USEREMAIL ())

(WAN AHMAD SHAILFULDDEEN BIN WAN NAWI) #5

Thanks guys. I tried using the IN (USEREMAIL(), LIST and it works.

(Aleksi Alkio) #6

How about CONTAINS(USEREMAIL(),“appsheet.com”) or IN(RIGHT(USEREMAIL(),(LEN(USEREMAIL())-FIND("@",USEREMAIL()))),{appsheet.com,gmail.com})