List of email addresses

Hi - just being a bit lazy but here’s an easy one

What is the correct expression syntax for this, which gives an error;

USEREMAIL()=MEMBERS.MYNYDD@GMAIL.COM OR
USEREMAIL()=MEETS.MYNYDD@GMAIL.COM OR
USEREMAIL()=CHAIR.MYNYDD@GMAIL.COM

I am trying to only show a data field if the users email is one of a list of 3.

Try:
IN( USEREMAIL(), {"MEMBERS.MYNYDD@GMAIL.COM", "MEETS.MYNYDD@GMAIL.COM", "CHAIR.MYNYDD@GMAIL.COM"} )

2 Likes

the IN() function helps, as well as noting that a list can be constructed with curly brackets. So this works:

IN(useremail(), {"MEMBERS.MYNYDD@GMAIL.COM", "MEETS.MYNYDD@GMAIL.COM", "CHAIR.MYNYDD@GMAIL.COM"} )

2 Likes

Perfect ! Thankyou.

Also, you’re using OR() wrong:

Good point. It took me several failed attempts to remember the curly brackets.