Skip to main content
Question

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

  • January 5, 2018
  • 0 replies
  • 31 views

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
This topic has been closed for replies.

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