function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Nikhil Vodapally 5Nikhil 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 
$hwet@$hwet@
Hi 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