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
JonathanHeuer's avatar
JonathanHeuer
Qrew Cadet
8 years ago
These works very nicely with my current data set Sam, thank you! But this still doesn't guarantee unique colors, right? Your formula with 82 colors would yield the same for a record ID of 83 as it would for 165, wouldn't it?

Not sure if you have a product management role for calendars, but here are some things I would love to see with calendar charts:
  • Dynamic filters. Please.
  • Chart settings to include hours of the day display options for Day/Month views. That is, the settings would include optional start and end times to display (because I never have events starting at 3am or going until 11pm :)
  • Drag to edit events. Drag start/end times to change. Drag entire event to change day or start time.
Yes I can put these in uservoice.