Skip to main content
Topics#Data ManagementMyra Wilson's Question
Myra Wilson asked in #Data Management
Jan 18, 2018, 9:57 PM

Not contains in validation rule with multiple fields and record types

We have two fields on two record types where the value should always contain the letter A. I wrote this validation rule to fire when the "A" is not present but for some reason its not working. 

 

and ( 

 

OR ( 

 

NOT(CONTAINS(Firm_External_ID__c ,"A")), 

 

NOT(CONTAINS(Office_External_ID__c ,"A")), 

 

OR( 

 

$RecordType.Name = "Intermediary_Firm_Equity", 

 

$RecordType.Name = "Intermediary_Office_Equity")))

 

 
12 answers
  1. Till Klotz (EMPAUA)
    Jan 18, 2018, 10:24 PM
    Hi Tara,

     

    then this could work: 

    IF(
    AND( 
    	NOT(CONTAINS(Firm_External_ID__c ,"A")), 
    	NOT(CONTAINS(Office_External_ID__c ,"A")),
    	$RecordType.Name = "Intermediary_Firm_Equity"),
    	TRUE,
    	IF(
    		AND(
    			NOT(CONTAINS(Firm_External_ID__c ,"A")), 
    			NOT(CONTAINS(Office_External_ID__c ,"A")),
    			$RecordType.Name = "Intermediary_Office_Equity"),TRUE,FALSE))

     

    Cheers,

     

    Till
Write an answer...
0/9000