Illegal characters allowed in email field?

Dean_Barrett · 01-18-2021 10:10 AM

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 ?

Steve

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]))

Dean_Barrett

Thanks Steve I will implement - can you explain what that work-around does ?

Dean

Steve

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()?