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
CirrusFCCirrusFC 

Salutation and First Name Required

I need help with a validation rule that requires a value Salutation which is a picklist and for First name which is a text field.
 
Any help would be appreciated.
 
thank you
AdminisaurusRexAdminisaurusRex

Try this:

 

AND (
           ISNULL (FirstName ) ,
          ISPICKVAL (  Salutation , "" )
         )
CirrusFCCirrusFC
Thanks I broke them up into two validation rules and used
 
Salutation = ISPICKVAL ( Salutation , "" )
 
and it worked but I am not able to use the ISNULL function for the First Name, I tried
 
ISNULL (FirstName )
 
but it didn't work.  Any thoughts on what I am missing?
 
Thank you
AdminisaurusRexAdminisaurusRex

You can keep them all together if you use the OR function instead of AND

 

OR(
       First_Name = "" ,
       ISPICKVAL( Salution , " )
       )



Message Edited by AdminisaurusRex on 11-18-2008 06:43 AM