Can I create my own Icons for use in Salesforce and assign them using a formula field based on a picklist value?

Question

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?

Gulshan Raj · Answer

Please refer this post:

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

Can I create my own Icons for use in Salesforce and assign them using a formula field based on a picklist value?

Formulas

관련 학습

도움 더 받기