I am new to sfdc .I got a requirement like when user selects any option in the picklist,that value has automatically filled in the other standard text field.I tried validation rule and workflows and even i trigger on that lead object but nothing works because text field is a standard text field.My lead object has a recordtype it may leads to any problem.Because company field is required in lead page.Please help  

  • you can create a formula field for that purpose – Himanshu Jan 22 '16 at 19:36
  • ya tried it before but it cant possible because,I have to get value from picklist it shows error like Channel_Name__c is a picklist field. Picklist fields are only supported in certain functions @Himanshu please help me... – Pavan tej Jan 22 '16 at 19:46

You can't access picklist value directly inside the formula field so you need to wrap this around the another function that is TEXT Here is the definition of this function

Converts a percent, number, date, date/time, or currency type field into text anywhere formulas are used. Also, converts picklist values to text in approval rules, approval step rules, workflow rules, escalation rules, assignment rules, auto-response rules, validation rules, formula fields, field updates, and custom buttons and links.

So your formula will be

  • Hey i tried like this company is a standard field in lead object. Company = TEXT(Channel_Name__c). when i tried create like this it shows me an error like Error: Formula result is data type (Boolean), incompatible with expected data type (Text). But i choose text in formula category. Please help thanks in advance @Himanshu – Pavan tej Jan 22 '16 at 20:13
  • Select text as formula instead of boolean – Himanshu Jan 22 '16 at 20:33
  • Ya i select return type text in formula.But it's returned boolean @Himanshu – Pavan tej Jan 22 '16 at 20:34
  • ya i tried with formula field with comapny=text(picklist_c).But while creating a lead i got an error like it's mandatory field.So,i have to create a new custom visualforce page right..@Himanshu – Pavan tej Jan 22 '16 at 20:57
  • what do you mean by new visualforce page? – Himanshu Jan 23 '16 at 4:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.