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
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!

Steve :-/Steve :-/
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
)
 
 
 


Steve :-/Steve :-/
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