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! Go to Solution.
@Bruno_Colorado
Try with this:
OR(
USEREMAIL()=[EMAIL_COLUMN_A],
CONTAINS([EMAIL_COLUMN_B],USEREMAIL())
)
@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:
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |