Forum Discussion

NikoleBordato's avatar
NikoleBordato
Qrew Member
8 years ago

Can I show traffic light status from multiple choice field?

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? 
Ask about Quickbase functionality
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    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's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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\">",
    "")
    • DirkRuana's avatar
      DirkRuana
      Qrew Captain
      4 years ago
      I have been able to modify this formula, but the displayed result is hyperlink to the image file, and not the image.

      I am just trying to display traffic light red, orange, yellow, or green dot.

      Dirk




      ------------------------------
      Dirk Ruana
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        Dirk, can you post your formula?  Is this a Formula Rich Text field type? It needs to be a Rich Text formula field.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------