If a column is selected as Email should it not stopped illegal characters ?
Engineer entered this and stops form from actioning email workflow which sends to this field and our own receipt address
Should I have a separate workflow rule for our email address to ensure we get receipt if the illegal character is not trapped by the form ?
Yep, Iโd call that a bug. Will escalate internally.
A work-around is to use this in the columnโs Valid If expression:
ISBLANK(EXTRACTEMAILS([_THIS]) - LIST([_THIS]))
Thanks Steve I will implement - can you explain what that work-around does ?
Dean
Eek! That expression was wrong! This one should work:
IN([_THIS], EXTRACTEMAILS([_THIS]))
This answers the question, does the current column value ([_THIS]
) match any of the valid email addresses in the current column value as recognized by EXTRACTEMAILS()?
See also:
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |