Discussions

Expand all | Collapse all

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

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

    Posted 01-05-2018 02:04
    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


  • 2.  RE: How do I color code a record that is on the Calendar Report based on a value?

    Posted 01-05-2018 02:10
    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