Forum Discussion

JonathanHeuer's avatar
JonathanHeuer
Qrew Cadet
8 years ago

Assign random colors to events in new Calendar report

The new Calendar chart offers the ability to assign colors to events. That is, I'd like to visually differentiate records on this chart by color, but I don't care what color they are. I'd like to assi...
App builders
Formulas and functions
Tips and tricks
SamJones3's avatar
SamJones3
Quickbase Staff
8 years ago
Hey Jonathan,
In testing the calendar out, I built several formulas of this type:
var number color = 4;  Case(Mod([Record ID#],$color),  1, "#60b54d", 2, "#694092", 3, "#00b0f1", 4, "#ff9511", 0, "#ff0001")
That'll assign one of 5 hex colors used throughout the Quick Base UI to the event. If you want to support more colors, add them as lines in the format:

5, "#ffffff", 

 and increase the variable accordingly.

Here's a version which includes 83 colors: https://www.pastiebin.com/5a9468a997bd4

Sam Jones
QuickBase Product Manager
JanaBaker's avatar
JanaBaker
Qrew Cadet
7 years ago
Sam, 

To follow up your comment about Jonathan's request #3, you said "Request 3 is already in there. You just need to make sure your start and end fields are both editable (not summary, formula, or lookup)."

Are you saying that if the User manually enters both the Start and End date, that on the Calendar report, the User can drag the Start Date in/out by X amount of days and/or drag the End Date in/out by X amount of days and the dates will adjust?  Right now I am just experiencing the date range moving when i drag it vs the date range adjusting in or out depending on which date you adjust.  Hopefully that makes sense.

Thank you in advance for the clarification.