Forum Discussion

TonyGonzalez's avatar
TonyGonzalez
Qrew Trainee
4 months ago

"Stoplight" Report

This is my first go at a Rich Text Formula, and I just think asking here will get the answer I can use to apply in other situations.  

I need to assign a Stoplight color to all open "Projects".  I can apply the Open Filter no problem.  For the stoplight, my team will use the field Condition2 to select "On-Track", "At Risk" or "Danger".  

The field named Condition2 will then display a Green, Yellow or Red circle, respectively.  

Also open to some other way of doing this by just using one field.  i.e. Can my multiple choice simply be the desired circles and not the equivalent text options?  I am fine if it needs to be the two field approach and got that idea from a previous.



------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------

2 Replies

Sort By
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    4 months ago

    Tony - 

    I would suggest starting with this example courtesy of the QB Exchange and see if you can swap it for your use case. 

    var text grayCircle = "https://exchange-cdn.quickbase.com/status-stoplights/10/grayCircle.png";
    var text greenCircle = "https://exchange-cdn.quickbase.com/status-stoplights/10/greenCircle.png";
    var text yellowCircle = "https://exchange-cdn.quickbase.com/status-stoplights/10/yellowCircle.png";
    var text redCircle = "https://exchange-cdn.quickbase.com/status-stoplights/10/redCircle.png";


    Case([Status],

    "Not Started", "<img src='" & $grayCircle & "' title='Not Started' style='width:24px;height:24px;'>",
    "Completed", "<img src='" & $greenCircle & "' title='Completed' style='width:24px;height:24px;'>", 
    "At Risk", "<img src='" & $yellowCircle & "' title='At Risk' style='width:24px;height:24px;'>", 
    "Late", "<img src='" & $redCircle & "' title='Late' style='width:24px;height:24px;'>")

    If you need to use multiple fields instead of the Case Statement above you could get rid of the Case statement and put in more complicated if statements - you can use whatever logic/combination of fields as needed to define the colors as you want. 



    ------------------------------
    Chayce Duncan
    ------------------------------

    • TonyGonzalez's avatar
      TonyGonzalez
      Qrew Trainee
      4 months ago

      Outstanding.  Thank you so much.



      ------------------------------
      Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
      IT Director City of New Braunfels
      ------------------------------