+ Start a Discussion
miteshsuramiteshsura 

enable field and make it mandatory on change of picklist value

Hello!

 

I am new to Salesforce, I am trying to enable and make a text field mandatory if picklist value is "Other". 

Saw few posts online, but nothing seemed to help, the solution lies in Triggers or Workflow, just not sure how to go about it. 

 

Thanks in advance.

Best Answer chosen by Admin (Salesforce Developers) 
ScoobieScoobie

Mitesh,

 

this can be simply achieved using a validation rule.

 

Use the ISPICKVAL formula method to check the value of the picklist and and ISBLANK on the field you want populating if the pickval is other.

All Answers

ScoobieScoobie

Mitesh,

 

this can be simply achieved using a validation rule.

 

Use the ISPICKVAL formula method to check the value of the picklist and and ISBLANK on the field you want populating if the pickval is other.

This was selected as the best answer
Pradeep_NavatarPradeep_Navatar

Find below a sample :

 

IF( AND( ISPICKVAL(HOC__Registration_Type__c, 'Sign Up'), ISBLANK(HOC__Maximum_Attendance__c)) , true, false)

Where HOC__Registration_Type__c  and HOC__Maximum_Attendance__c are field names.

 

Hope this helps.

miteshsuramiteshsura

Thanks 

miteshsuramiteshsura

Thanks Pradeep, after some trial and error on previous post, I was able to fig this out ..