Forum Discussion

arleta's avatar
arleta
Qrew Member
1 year ago

How to check if all emails in the list have one or another domain?

Hi, 

I am trying to set up a field which will check if all of the emails provided in another field of the form have got @X.com or @Y.com domains.

The example of list of emails

[email protected];[email protected];[email protected]

I would like to have a formula that would tell me that email [email protected] has got a wrong domain and can't be accepted and that only domains @X.com and @Y.com can be accepted.

formulas

1 Reply

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    1 year ago

    not tested but try something like this.

    var text AllEmails = [My semi delimited email list field]);

    var text EmailOne= Trim(Part($AllEmails,1,";"));
    var user UserTwo =Trim(Part($AllEmails,2,";"));
    var user UserThree= Trim(Part($AllEmails,3,";"));

    etc

    List("\n",

    IF(not contains($EmailOne, "X.com") and not contains($EmailOne, "Y.com"), $EmailOne),

    IF(not contains($EmailTwo, "X.com") and not contains($EmailTwo, "Y.com"), $EmailTwo),

    IF(not contains($EmailThree "X.com") and not contains($EmailThree, "Y.com"), $EmailThree),

    etc .. )