You need to sign in to do that
Don't have an account?
Zane Prater 15
How to evaluate multiple values in a contains function via declarative formula
I am trying check if the suppliedemail field contains any of these domains but is not working.
If(CONTAINS("lincare.com:ndc-inc.com:preferredhomecare.com", SuppliedEmail),mod(value(CaseNumber),3)+1,0)
If(CONTAINS("lincare.com:ndc-inc.com:preferredhomecare.com", SuppliedEmail),mod(value(CaseNumber),3)+1,0)
CONTAINS (text, compare_text)
CONTAINS will return TRUE if "compare_text" is found in "text" and FALSE if not.
The issue with your CONTAINS formula is that the SuppliedEmail address will be "someone@lincare.com". As a "string", that does not appear in your List of Domains. You will need to strip the person component from the SuppliedEmail Address.
So something like:
As noted by Mahajarn, you could switch the format to multiple contains
Formula is untested, but the logic should work
regards
Andrew
All Answers
Otherwise use like below:
Thanks,
Maharajan.C
CONTAINS (text, compare_text)
CONTAINS will return TRUE if "compare_text" is found in "text" and FALSE if not.
The issue with your CONTAINS formula is that the SuppliedEmail address will be "someone@lincare.com". As a "string", that does not appear in your List of Domains. You will need to strip the person component from the SuppliedEmail Address.
So something like:
As noted by Mahajarn, you could switch the format to multiple contains
Formula is untested, but the logic should work
regards
Andrew
https://mooncricket.xyz/
https://best-hair-salon-near-me.com/
https://insurance-meme.com/