function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Zane Prater 15Zane 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)
Best Answer chosen by Zane Prater 15
Andrew GAndrew G
Hi Zane, 

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: 
IF(
  CONTAINS(
    "lincare.com:ndc-inc.com:preferredhomecare.com", 
    SUBSTITUTE(SuppliedEmail, LEFT(SuppliedEmail, FIND("@", SuppliedEmail)), NULL)
  ),
  mod(value(CaseNumber),3)+1,
  0
)

As noted by Mahajarn, you could switch the format to multiple contains 


Formula is untested, but the logic should work

regards
Andrew
 

All Answers

Maharajan CMaharajan C
Hi Zane,

Otherwise use like below:
  
If(
OR
(CONTAINS(Email__c, "lincare.com") , 
CONTAINS(Email__c, "ndc-inc.com"),
CONTAINS(Email__c, "preferredhomecare.com")),
mod(value(CaseNumber),3)+1,
0)

Thanks,
Maharajan.C
Zane Prater 15Zane Prater 15
Thanks Maharajan, but I am trying to avoid an OR statement because there are over 200 domains that need to be evaluated and the character limit would exceed for the formula if I go that route.  
Andrew GAndrew G
Hi Zane, 

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: 
IF(
  CONTAINS(
    "lincare.com:ndc-inc.com:preferredhomecare.com", 
    SUBSTITUTE(SuppliedEmail, LEFT(SuppliedEmail, FIND("@", SuppliedEmail)), NULL)
  ),
  mod(value(CaseNumber),3)+1,
  0
)

As noted by Mahajarn, you could switch the format to multiple contains 


Formula is untested, but the logic should work

regards
Andrew
 
This was selected as the best answer
Zane Prater 15Zane Prater 15
Thanks Andrew, worked perfect!  
narinder singh 37narinder singh 37
Sarkari yojana https://nvsp.co.in/
https://mooncricket.xyz/
https://best-hair-salon-near-me.com/
https://insurance-meme.com/
Ken SKen S
@Andrew Z What if you don't want to search using a specific symbol where you can truncate the text (e.g. not an email address) but just find instances of IF(CONTAINS("value1:value2:vlaue3",{!varValue}),doA,elsedoB) in a flow entry criteria or decision tree?  Doesn't seem to work in flow like it does in validation rules. Is there any way to reconcoginize a semi-colon delimited list of values in flow without creating hundreds of OR lines?