I have an EnumList that suggests email addresses as it’s value taken from another column. The EnumList allows other values, too. Is there some way to check the user’s entry for email address?
In my “Valid If” I have taken the following snippet from User Email authentication error:
However, if a “correct” (containing “@” and “.”) email address is already selected, the check for the individual entry will fail.
Screenshot of EnumList Type Details:
My Valid If expression:
Solved! Go to Solution.
If EXTRACTEMAIL() recognizes only valid addresses, you could just use it as the entirety of the Valid If expression:
ISBLANK([_THIS] - EXTRACTEMAILS([_THIS] & ""))
Good call, @Suvrutt_Gurjar!
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |