Skip to main content
Question

Can I show traffic light status from multiple choice field?

  • June 27, 2017
  • 0 replies
  • 128 views
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? 
    This topic has been closed for replies.

    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
    • MCFNeil
    • Registered
    • June 28, 2017
    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\">",
    "")
    Terms & ConditionsAccessibility statement