+ 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