Discussions

Expand all | Collapse all

Can I show traffic light status from multiple choice field?

  • 1.  Can I show traffic light status from multiple choice field?

    Posted 06-27-2017 19:01
    I have a multiple choice field that has the traffic light status for a project (green, yellow, red), and I would like to have the selection display a traffic light image. It doesn't look like I can customize the display because it is multiple choice. Can I get this all into one field? Or do I need to do a field that will read the status and then display the image? 


  • 2.  RE: Can I show traffic light status from multiple choice field?

    Silver
    Contributor
    Posted 06-28-2017 05:35
    You can not show images into a multiple choice field.

    Yes, you will need a separate field that will read the selection and display the required image. Please let me know if you need any further help to setup the field.

    Thanks,
    Gaurav


  • 3.  RE: Can I show traffic light status from multiple choice field?

    Top
    Contributor
    Posted 06-28-2017 06:16
    You are correct that you will need a separate field to display the colors.

    You will need to make a formula-text field.  Then use a "Case" formula to display the appropriate image.

    Something like this:

    Case([Status],
    "Green", "<img src=\"https://images.quickbase.com/si/16/228-rect_green.png\"; alt=\"Project Status: Green\" title=\"Project Status: Green\">",
    "Yellow", "<img src=\"https://images.quickbase.com/si/16/229-rect_yellow.png\"; alt=\"Project Status: Yellow\" title=\"Project Status: Yellow\">",
    "Red", "<img src=\"https://images.quickbase.com/si/16/227-rect_red.png\"; alt=\"Project Status: Red\" title=\"Project Status: Red\">",
    "")