Can I show traffic light status from multiple choice field?

  • 0
  • 2
  • Question
  • Updated 1 year ago
  • Answered
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? 
Photo of Nikole Bordato

Nikole Bordato

  • 80 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 2
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
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
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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\">",
"")