+ Start a Discussion
lsatonylsatony 

make multiple fields required based on picklist value

hi,

 

for some reason validation rules just will not sink in for me.

 

i'm trying to make a set of 3 fields required based on a certain selection in a picklist.  the 3 fileds are a number, phone and text.  i tried a bunch of different things and nothing works properly.

 

thanks for your help!

SteveMo__cSteveMo__c
Can you copy & paste your Source Code, so that we can take a look at it?
lsatonylsatony

thanks

 

 

AND( ISPICKVAL(Item_Type__c ,"Desk Reference Card (Custom)"), ISNULL( Account_Code__c ), ISNULL( Dedicated_800__c ), LEN( Caller_Data_Capture_Instructions__c )=0 )

 

 

 

SteveMo__cSteveMo__c
Try this one

AND(ISPICKVAL(TriggerField,"TriggerValue"),
OR (
ISNULL(ReqNumberField_1),
LEN(ReqPhoneField_2)=0,
LEN(ReqTextField_3)=0))

 

***  My bad, I pasted in the wrong formula, try the updated one.
Message Edited by Stevemo on 02-25-2009 11:17 AM