You need to sign in to do that
Don't have an account?
Lee Beardshaw
Can I create my own Icons for use in Salesforce and assign them using a formula field based on a picklist value?
I have created two icons which I'd like to use in Salesforce based on the value selected in a picklist... Can anyone point me in the right direction of how to do this?
I have seen some formula fields which use Salesforce fields (I'm asuming text formula) and work something like this...
LEAD( ISPICKVAL(Enquiry_Type__c) ,
"Business", IMAGE( "/servlet/servlet.FileDownload?file=01550000000N4NG", "Green"),
"Personal", IMAGE( "/servlet/servlet.FileDownload?file=01550000000N4NY", "Yellow"),
"")
The first thing I need to do is get the formula working which I can' seem to do. The picklist is called Enquiry_Type__c and has the options Business and Personal. I'm happy to show the two images detailed above (or even Salesforce images for the time-being).
Onmce I have the formula field working, I'm assuming I can upload my images to Salesforce and reference them instead?
I have seen some formula fields which use Salesforce fields (I'm asuming text formula) and work something like this...
LEAD( ISPICKVAL(Enquiry_Type__c) ,
"Business", IMAGE( "/servlet/servlet.FileDownload?file=01550000000N4NG", "Green"),
"Personal", IMAGE( "/servlet/servlet.FileDownload?file=01550000000N4NY", "Yellow"),
"")
The first thing I need to do is get the formula working which I can' seem to do. The picklist is called Enquiry_Type__c and has the options Business and Personal. I'm happy to show the two images detailed above (or even Salesforce images for the time-being).
Onmce I have the formula field working, I'm assuming I can upload my images to Salesforce and reference them instead?
https://help.salesforce.com/articleView?id=000007604&type=1
And use this formula:
CASE(Enquiry_Type__c ,
"Business", IMAGE( "/servlet/servlet.FileDownload?file=01550000000N4NG", "Green"),
"Personal", IMAGE( "/servlet/servlet.FileDownload?file=01550000000N4NY", "Yellow"),
"")
Thanks
Gulshan Raj