How do I color code a record that is on the Calendar Report based on a value?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Where would I add the formula so that the color coding would work on the calendar?

I want something like this:

If([Probation]="Yes",Red

If([Overtime Issued]="Yes",Green
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
You will have to make a new field to show on the Calendar report

Check out this help link

https://help.quickbase.com/user-assistance/color_field.html

If you do not want to write any code at all, look for my post in this thread here.  It could work if your drop down choices were from a relationship as opposed to a simple multiple choice field.

https://community.quickbase.com/quickbase/topics/december-2017-release-notes-new-ui-coming