function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
BrunoMBrunoM 

Validation rule

Trying to prevent users from setting this custom object to 'Finished' status if the boolean field In_AddOn_Grp__c is checked off and either Description__c  or Customer_Contact__c  are blank. Any ideas?

 

AND (
In_AddOn_Grp__c ,
ISPICKVAL( Project_Status__c, "Finished" ) ,
OR (
ISNULL( Description__c ),
ISNULL( Customer_Contact__c )
)
)

JakesterJakester
Looks exactly right to me, except try changing the two IsNull() checks to Len()=0.
BrunoMBrunoM

Y'know I actually had my formula setup originally as 

 

AND ( 

In_AddOn_Grp__c , 
ISPICKVAL( Project_Status__c, "Finished" ) , 
OR ( 
Len(Description__c) < 1,

Len(Customer_Contact__c) < 1

) 
)

 

and both setups seem buggy, like Salesforce is randomly ignoring validation rules.

 

I'll give it another try, thanks. 

Message Edited by BrunoM on 07-07-2009 07:20 PM