Skip to main content
Topics#Data ManagementQuestion de Jacob Kohler
Jacob Kohler (Textura Corporation) a posé une question dans #Data Management
12 févr. 2016, 20:38

How to display image to account field based on selected picklist

Below is what I'm attempting, but it obviously doesn't work. On the account page (not the case object), based on one of three picklist items (i.e. Good Standing, Pending Verification, Fraudulent) I need to figure out how to create a formula to display a green light, yellow light, or red light, respectively in a formula field on th eaccount page based on the picklist selection.

 

This is what I have so far... but I don't know what is wrong. Should this somehow be an IF/OR statement?

 

ACCOUNT (Fraudulent_Activity__c,

 

  "Good Standing", IMAGE("/img/samples/light_green.gif"),

 

  "Pending Verification", IMAGE ("/img/samples/light_yellow.gif"),

 

  "Fraudulent",   IMAGE ("/img/samples/light_red.gif")

 

)

 

 
5 réponses
  1. Mayank Srivastava (eVerge Group)
    12 févr. 2016, 20:54

    Ah, use this then:

    CASE(
       Fraudulent_Activity__c,
      "Good Standing", IMAGE("/img/samples/light_green.gif", "Green"),
      "Pending Verification", IMAGE ("/img/samples/light_yellow.gif", "Yellow"),
      "Fraudulent",   IMAGE ("/img/samples/light_red.gif", "Red"),
       NULL
    )
Rédiger une réponse...
0/9000