Forum Discussion

ArletaMaæka_a's avatar
ArletaMaæka_a
Qrew Member
3 years ago

How to verify if list of emails has correct domain?

Hello, I am working on an app where I set up a form where users provide different data. One field that I have is an email field called Notification Recipients. In this field users can provide multi...
Formula and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
try this
var text EmailOne =   Part([Email String],1, ";");
var text EmailTwo =   Part([Email String],2, ";");
var text EmailThree = Part([Email String],3, ";");
var text EmailFour =   Part([Email String],4, ";");
var text EmailFive =   Part([Email String],5, ";");

List("\n",
IF(Trim($EmailOne) <>"" and not Ends($EmailOne, "@domaine"), "Bad " & $EmailOne),

IF(Trim($EmailTwo) <>"" and not Ends($EmailTwo, "@domaine"), "Bad " & $EmailTwo),

etc...

IF(Trim($EmailFive) <>"" and not Ends($EmailFive, "@domaine"), "Bad " & $EmailFive))



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • ArletaMaæka_a's avatar
    ArletaMaæka_a
    Qrew Member
    3 years ago
    Thank you so much Mark for your help! It worked as expected.

    ------------------------------
    Arleta Maæka³a
    ------------------------------