+ Start a Discussion
JPINOJPINO 

Validation Rule Help

I am new to Salesforce and would appreciate some help with a validation rule:

 

I currently have:

 

AND (
OR (
ISPICKVAL (Level_of_Interest__c, "Enrolled")),
ISBLANK (Date_of_First_Class__c))

 

But I need to add another AND condition:

 

Campaign_Master__r.Campaign_Name__c  contains the text 'Cert II Tourism'

 

Thanks in advance.

Best Answer chosen by Admin (Salesforce Developers) 
Naveen NelavelliNaveen Nelavelli

second AND condition is

 CONTAINS(Campaign_Master__r.Campaign_Name__c, 'Cert II Tourism')

 

 

**above function is case sensitive..

if you want to compare with both casesensitive and caseinsensitive you can use this one

 

CONTAINS(upper(Campaign_Master__r.Campaign_Name__c), 'CERT II TOURISM')

All Answers

Naveen NelavelliNaveen Nelavelli

second AND condition is

 CONTAINS(Campaign_Master__r.Campaign_Name__c, 'Cert II Tourism')

 

 

**above function is case sensitive..

if you want to compare with both casesensitive and caseinsensitive you can use this one

 

CONTAINS(upper(Campaign_Master__r.Campaign_Name__c), 'CERT II TOURISM')

This was selected as the best answer
JPINOJPINO
Thanks very much Naveen