Skip to main content
Topics#Data ManagementJacob Kohler의 질문
Jacob Kohler (Textura Corporation) 님이 #Data Management에 질문했습니다
2016년 2월 12일 오후 8: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개
  1. Mayank Srivastava (eVerge Group)
    2016년 2월 12일 오후 8: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
    )
답변을 작성하세요...
0/9000