Skip to main content
Ian Taylor 님이 #Sales And Marketing에 질문했습니다
I have a forumla set up to add "OVERDUE" to a column in the leads list if the Lead has been in a status for a certain amount of time. I would also like to change the background color of the rows that contain the "OVERDUE" text or even just change the custom fields background color itself, is this possible?
답변 1개
  1. 2011년 10월 25일 오후 5:14
    It is posible in visual force page but not in standard UI.

     

    You can consider to use formula with Image to animate particular record.

     

    Image Links

    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.

    IF(ISBLANK(Yahoo_Name__c),"", HYPERLINK("ymsgr:sendIM?" & Yahoo_Name__c,

    IMAGE("http://opi.yahoo.com/online?u=" & Yahoo_Name__c & "&m=g&t=0", " ")))

    For details about using these functions, see IF, LEN, HYPERLINK, and IMAGE.

    “Skype Me™” Auto Dialer Button

    This formula displays an image that looks like a push button. Clicking the button automatically dials the specified phone number.

    HYPERLINK("callto://" & "+1" & Phone,

    IMAGE("http://goodies.skype.com/graphics/skypeme_btn_small_blue.gif",

    "Click to Skype"))

    For details about using these functions, see HYPERLINK and IMAGE.

    Flags for Case Priority

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

    IMAGE(

    CASE( Priority,

    "Low", "/img/samples/flag_green.gif",

    "Medium", "/img/samples/flag_yellow.gif",

    "High", "/img/samples/flag_red.gif",

    "/s.gif"),

    "Priority Flag")

    For details about using this function, see IMAGE.

    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 text field.

    IF( Case_Age__c > 20,

    IMAGE("/img/samples/color_red.gif", "red", 30, 30),

    IF( Case_Age__c > 10,

    IMAGE("/img/samples/color_yellow.gif", "yellow", 30, 30),

    IMAGE("/img/samples/color_green.gif", "green", 30, 30),

    ))

    For details about using these functions, see IF and IMAGE.

    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.

    IMAGE(

    CASE(Project_Status__c,

    "Green", "/img/samples/light_green.gif",

    "Yellow", "/img/samples/light_yellow.gif",

    "Red", "/img/samples/light_red.gif",

    "/s.gif"),

    "status color")

    For details about using these functions, see IMAGE and CASE.

    Stars for Ratings

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

    IMAGE(

    CASE(Rating__c,

    "1", "/img/samples/stars_100.gif",

    "2", "/img/samples/stars_200.gif",

    "3", "/img/samples/stars_300.gif",

    "4", "/img/samples/stars_400.gif",

    "5", "/img/samples/stars_500.gif",

    "/img/samples/stars_000.gif"),

    "rating")

    For details about using these functions, see IMAGE and CASE.

    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.

    IMAGE(

    CASE(Rating__c,

    "1", "/img/samples/rating1.gif",

    "2", "/img/samples/rating2.gif",

    "3", "/img/samples/rating3.gif",

    "4", "/img/samples/rating4.gif",

    "5", "/img/samples/rating5.gif",

    "/s.gif"),

    "rating")

    For details about using these functions, see IMAGE and CASE.

    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.

    IMAGE("/img/samples/color_green.gif", "green", 15, Industry_Score__c * 2) &

    IMAGE("/s.gif", "white", 15,

    200 - (Industry_Score__c * 2))

    For details about using this function, see IMAGE.

0/9000