Expression Assistant - True False for cell with multiple, comma delimited values

Hello,

Thanks for any assistance! Will keep this brief. I have an Edit expression for a column:

OR(USEREMAIL()=[EMAIL_COLUMN_A], USEREMAIL()=[EMAIL_COLUMN_B])

If the user’s email matches the email in either column A or B, they can edit the record. So far so good.

Issue: I’d like to store more than 1 email addresses in EMAIL_COLUMN_B. However, if I try to add a 2nd email there (comma delimited), the 2nd email/user isn’t given edit rights.

Question: How do I modify this expression so that multiple records within 1 cell are parsed, instead of just the first.

I’ve tried to use IN LIST, but it only seems to allow text entries, not column references. Something like:

OR(USEREMAIL()=[EMAIL_COLUMN_A], IN(USEREMAIL()=LIST([EMAIL_COLUMN_B])))

No dice…

Regards,

-B

Solved Solved
0 4 279
1 ACCEPTED SOLUTION

LeventK
Participant V

@Bruno_Colorado
Try with this:

OR(
	USEREMAIL()=[EMAIL_COLUMN_A],
	CONTAINS([EMAIL_COLUMN_B],USEREMAIL())
)

View solution in original post

4 REPLIES 4

LeventK
Participant V

@Bruno_Colorado
Try with this:

OR(
	USEREMAIL()=[EMAIL_COLUMN_A],
	CONTAINS([EMAIL_COLUMN_B],USEREMAIL())
)

Simple & clean! this did the trick, thank you!!

You’re very welcome, my pleasure

CONTAINS() is a potential security risk here. Use IN() instead:

IN(USEREMAIL(), [EMAIL_COLUMN_B])

EMAIL_COLUMN_B must be of type EnumList.

See also:


Top Labels in this Space