Skip to main content
Topics#Data ManagementPregunta de Myra Wilson
Myra Wilson ha preguntado en #Data Management
18 ene 2018, 21:57

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 respuestas
  1. Till Klotz (EMPAUA)
    18 ene 2018, 22:24
    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
Escribir una respuesta...
0/9000