Sample Image Link Formulas

For details about using the functions included in these samples, see Formula Operators and Functions.

Yahoo! Instant Messenger™ Image

This formula displays an image that indicates whether a contact or user is currently logged in to Yahoo! Instant Messenger. Clicking the image launches the Yahoo! Instant Messenger window. This formula uses a custom text field called Yahoo Name to store the contact or user’s Yahoo! ID.

1IF(ISBLANK(Yahoo_Name__c),"", HYPERLINK("ymsgr:sendIM?" & Yahoo_Name__c, 
2IMAGE("http://opi.yahoo.com/online?u=" & Yahoo_Name__c & "&m=g&t=0", " ")))

Flags for Case Priority

This formula displays a green, yellow, or red flag image to indicate case priority.

1IMAGE( 
2CASE( Priority, 
3"Low", "/img/samples/flag_green.gif",
4"Medium", "/img/samples/flag_yellow.gif",
5"High", "/img/samples/flag_red.gif", 
6"/s.gif"), 
7"Priority Flag")

Color Squares for Case Age

This formula displays a 30 x 30 pixel image of a red, yellow, or green, depending on the value of a Case Age custom number field.

1IF( Case_Age__c > 20, 
2IMAGE("/img/samples/color_red.gif", "red", 30, 30),
3IF( Case_Age__c > 10,
4IMAGE("/img/samples/color_yellow.gif", "yellow", 30, 30),
5IMAGE("/img/samples/color_green.gif", "green", 30, 30)
6))

Traffic Lights for Status

This formula displays a green, yellow, or red traffic light images to indicate status, using a custom picklist field called Project Status. Use this formula in list views and reports to create a “Status Summary” dashboard view.

1IMAGE( 
2CASE(Project_Status__c, 
3"Green", "/img/samples/light_green.gif",
4"Yellow", "/img/samples/light_yellow.gif",
5"Red", "/img/samples/light_red.gif", 
6"/s.gif"), 
7"status color")

Stars for Ratings

This formula displays a set of one to five stars to indicate a rating or score.

1IMAGE( 
2CASE(Rating__c, 
3"1", "/img/samples/stars_100.gif",
4"2", "/img/samples/stars_200.gif",
5"3", "/img/samples/stars_300.gif", 
6"4", "/img/samples/stars_400.gif", 
7"5", "/img/samples/stars_500.gif", 
8"/img/samples/stars_000.gif"), 
9"rating")

Consumer Reports™—Style Colored Circles for Ratings

This formula displays a colored circle to indicate a rating on a scale of one to five, where solid red is one, half red is two, black outline is three, half black is four, and solid black is five.

1IMAGE( 
2CASE(Rating__c, 
3"1", "/img/samples/rating1.gif",
4"2", "/img/samples/rating2.gif",
5"3", "/img/samples/rating3.gif", 
6"4", "/img/samples/rating4.gif", 
7"5", "/img/samples/rating5.gif", 
8"/s.gif"), 
9"rating")

Horizontal Bars to Indicate Scoring

This formula displays a horizontal color bar (green on a white background) of a length that is proportional to a numeric score. In this example, the maximum length of the bar is 200 pixels.

1IMAGE("/img/samples/color_green.gif", "green", 15, Industry_Score__c * 2) & 
2IMAGE("/s.gif", "white", 15, 
3200 - (Industry_Score__c * 2))