Skip to main content
Topics#Data ManagementT O の質問
T O が「#Data Management」で質問
2015年11月19日 12:15

Validation rule clarification

Hi

 

I have created the below validation rule, however the error is still firing on the field. Is there something not right on the rule?

 

Thanks

 

AND( 

 

Request_for_an_SA__c = TRUE, 

 

ISBLANK( SA_Signatory__c ), 

 

OR( 

 

RecordType.Id = "01224000000ENsM", 

 

RecordType.Id = "012b0000000DjUB", 

 

OR( 

 

TEXT( Sales_Stage__c )="Proposal",TEXT( Sales_Stage__c )="Ops Compliance Check",TEXT( Sales_Stage__c )="Scoping",TEXT( Sales_Stage__c )="Negotiate", 

 

AND( 

 

DATEVALUE( CreatedDate ) > DATE(2015, 10, 01) 

 

) 

 

)))
4 件の回答
  1. Sunil Sarilla (M&G Investments)
    2015年11月19日 12:29
    Hi,

     

    Please try the below

    AND( 
    Request_for_an_SA__c = TRUE, 
    ISBLANK( SA_Signatory__c ), 
    OR( 
    RecordType.Id = "01224000000ENsM", 
    RecordType.Id = "012b0000000DjUB"
    ),
    OR( 
    TEXT( Sales_Stage__c )="Proposal",
    TEXT( Sales_Stage__c )="Ops Compliance Check",
    TEXT( Sales_Stage__c )="Scoping",
    TEXT( Sales_Stage__c )="Negotiate"
    ),
    DATEVALUE( CreatedDate ) > DATE(2015, 10, 01) 
    )

     

     
回答を記入...
0/9000