Forum Discussion

NikoleBordato's avatar
NikoleBordato
Qrew Member
7 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 cu...
Ask about Quickbase functionality
MCFNeil's avatar
MCFNeil
Qrew Captain
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
3 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
    Qrew Champion
    3 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
    ------------------------------
    • DirkRuana's avatar
      DirkRuana
      Qrew Captain
      3 years ago
      Mark:

      I had read somewhere on here to use Formula Text.  Converting to Rich Text Formula solved the issue.

      Thank you,

      Dirk

      ------------------------------
      Dirk Ruana
      ------------------------------