You need to sign in to do that
Don't have an account?
Nikhil Vodapally 5
Country Classification
Hi All,
I'm looking for some ideas to solve the below:
Problem: I have a spreadsheet with a list of all Countries and their grading i.e. RED, AMBER and GREEN. We have a custom picklist field called Country on the Account object and whenever a new Account is created, our User selects a Country. I want to display the RAG status to the User upon creation of the Account record as an RAG Image.
Also, I get the spreadsheet on a monthly basis so need to be able to update the grading every month via the Data Loader.
Does anyone have any ideas on how to achieve this?
Regards,
Nikhil
I'm looking for some ideas to solve the below:
Problem: I have a spreadsheet with a list of all Countries and their grading i.e. RED, AMBER and GREEN. We have a custom picklist field called Country on the Account object and whenever a new Account is created, our User selects a Country. I want to display the RAG status to the User upon creation of the Account record as an RAG Image.
Also, I get the spreadsheet on a monthly basis so need to be able to update the grading every month via the Data Loader.
Does anyone have any ideas on how to achieve this?
Regards,
Nikhil
You can create a formula field and based on the selection you can choose the color needs to be shown and save the images in static resource.
Please see the link below:
https://developer.salesforce.com/forums/?id=906F000000096qdIAA
https://developer.salesforce.com/forums/?id=906F00000008n1qIAA
if you want to show that picklist selection just in the chart then there is something called chart color when you edit the picklist value.
https://help.salesforce.com/articleView?id=updating_picklists.htm&type=0