I am trying to add red, yellow and green as an action based on a value selected from a field. Can anyone help me with this code?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Erin

Erin

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Can you clarify with a more specific example. What Action?  What specific result?  Are you asking for a result in words, or background shading, or icons?
Photo of Eric

Eric

  • 0 Points
I too am trying to turn a record green upon the toggling of the status field to completed.  What do I need to do?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
In a regular Table Report, look for the checkbox for Row Colorization.

The formula would be like

IF([Status] = "Completed", "green")

You can also use hex codes for colors.

IF([Status] = "Completed", "#FFF000")

Laura Hillier, another QuickBase Solutions Provider, had a great app for choosing colors.

https://laurahillier.quickbase.com/db/bhy8pumtp