+ Start a Discussion
Shaker Kuncham 1Shaker Kuncham 1 

validation rule

Hi

I have two fields (1) Error__ message__C ( Pick list )     (2) other__  Error__ Message__C ( Text  Field )
for Eg: (1) if i select value from the Error__ message__C , user should not enter Text for other__ Error__ Message__c
any of the value say ( a,b,c, Other)
(2) If i select Value called Other from the Error__ message__C ,  user should enter text for other__ Error__ Message__c


Regards
Shaker
 
Best Answer chosen by Shaker Kuncham 1
KaranrajKaranraj
Shaker - Try the below validation rule
AND(TEXT(Error__ message__c )== 'Other', ISBLANK(other__  Error__ Message__c ))

 

All Answers

KaranrajKaranraj
Shaker - Try the below validation rule
AND(TEXT(Error__ message__c )== 'Other', ISBLANK(other__  Error__ Message__c ))

 
This was selected as the best answer
Shaker Kuncham 1Shaker Kuncham 1
Hi Karanraj

Its working fine,,, 
and also if the user select others  values instad of value called Other and tires to enter the text for other__  Error__ Message__c it should  also throw error. below is the validation rule i wrote 
AND( NOT( ISPICKVAL( Error_Message__c ,'other')) , NOT( ISBLANK( Other_Error_Message__c ) ) )



Regards
Shaker