Capture the Attention of Salesforce Users with Image Formulas

Ever wonder how to get those cool looking images such as the stop lights and colored flags to display statuses in Salesforce?  Well, they are actually formula fields (image formulas, to be exact) and this month we are going to provide you with the steps required to build them.

Essentially, displaying these images requires a couple of steps: saving the images you want to display within the Documents tab in Salesforce, and building the formula that references them. Suppose, for example, I have a check box field called “Credit Hold”. When this field is checked, I want to display a warning image on the screen.  The first thing I’ll do is save the warning image to the documents tab:

Documents Tab










Next, it’s time to build the formula that references the image we just saved.  I navigate through the Setup menu to create a new custom formula field on my Accounts object called “Credit Hold Indicator”, using the output type of Text. This new will reference my Credit Hold check box field and display my image when it is checked. Here is a snapshot of my formula:

Image Formula

The reference to the image comes from the URL of the image itself. From the image record within the Documents tab, I simply copy/paste the Id of the Document record into my formula as highlighted above.

I save my formula, and here are my results:

Image Formula Result








May seem a little complicated for new users, but trust us, once you get through the first couple they are a breeze and the use cases for these are endless!

You can share this article by using your social accounts:

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *