"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 ...
Forum Discussion
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
------------------------------
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
------------------------------
