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

Question

Where would I add the formula so that the color coding would work on the calendar?I want something like this:If([Probation]="Yes",RedIf([Overtime Issued]="Yes",Green

quickbasecoachd · Answer

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

Forum Discussion

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

1 Reply

Related Content

How to add list of attachments on child record from parent record

Report for Expired Training Records

Calendar Report

Calendar Report

Get Record IDs from Report Link

Recent Discussions

Many to Many too Many...

Are all QB notifications "No-Reply" emails

Bulk create child records from selection list

Selecting which fields to display from Formula URL searches

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting