Skip to main content
FeedFred Kampf's Question
Fred Kampf (Horizon BCBSNJ)
Jan 29, 2010, 4:47 PM

Validation Rule ?

I have the following validation rule on the account object.  The purpose is to ensure that the "Renewal_Participation_Audit_Contact" field on the account (which is a lookup to contact)  is populated with a contact from either the account that the field is on or the account with the id below. 

 

The problem is that the validation rule is firing when the field is blank.... I previously had  "Renewal_Participation_Audit_Contact <> null"  but that did not work either... I am using "AND" so shouldnt the validation rule not fire if the field is null?  Here is the validation... 

 

AND(Renewal_Participation_Audit_Contact__r.AccountId <> Id, Renewal_Participation_Audit_Contact__r.AccountId  <>'0017000000bZSfW',Renewal_Participation_Audit_Contact__r.AccountId  <> null,  Len(Renewal_Participation_Audit_Contact__c)>0)

 

Thanks!!
2 answers
  1. Neal Mengel (Attorneys' Title Fund Services, LLC)
    Jan 29, 2010, 5:02 PM
    Try using NOT(ISNULL) instead of LEN for Renewal_Participation_Audit_Contact__c

     

    AND(

     

    Renewal_Participation_Audit_Contact__r.AccountId <> Id, Renewal_Participation_Audit_Contact__r.AccountId <>'0017000000bZSfW',

     

    Renewal_Participation_Audit_Contact__r.AccountId <> null, 

     

    NOT(ISNULL(Renewal_Participation_Audit_Contact__c))

     

             )
Write an answer...
0/9000