You need to sign in to do that
Don't have an account?
Kushal Mishra
conditional based Picklist
Hi all,
i need to create a picklist wirh Green,Yellow, Red Values on Opportunity object .Green would be by default and if the value of the Type field under related Account is equals to Customer then it would be green and if that condition is not satisfied then i would be yellow. However, the field should be editable by users, who can select another value from the picklist. please gyes help.
i need to create a picklist wirh Green,Yellow, Red Values on Opportunity object .Green would be by default and if the value of the Type field under related Account is equals to Customer then it would be green and if that condition is not satisfied then i would be yellow. However, the field should be editable by users, who can select another value from the picklist. please gyes help.
1. Create a process builder on Opportunity object for on creation process and check related account condition and update the opporunity picklist field
2. Create a process builder on Account object, like whenever 'Type' field under the account changed then you want to update the related opportunity picklist value also. [Consider this only if you have any business criteria like this]
Check this link to know, more details about process builder - https://developer.salesforce.com/trailhead/force_com_declarative_beginner/business_process_automation/process_builder
Thanks,
http://karanrajs.com
Here are some steps which you can use to achive the desired functionality.
1. Create a formula field on opportunity of return type "text".
2. Click on advance formula button.
3. Paste the below code. 4. Save this and keep this fields visible to the layout on which you are going to see.
5. "Customer - Direct", "Prospect" etc are the values on account's type field.
6. I've used two type of symbol which is inbulit images of salesforce. Use whatever you like. Please find below the name of images.
A. color_green.gif
color_red.gif
color_yellow.gif
B. light_green.gif
light_red.gif
light_yellow.gif
Please mark solved if it'll be helpful for you.
Regards,
Kapil