Assign random colors to events in new Calendar report

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