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