Skip to main content
Question

How to get a color calendar to be colorful?

  • Apr 17, 2018 11:51 PM UTC
  • 0 replies
  • 87 views
Question?  The new color calendars all start our pretty boring looking.  How can I add some color just to make overlapping entries stand out nicely?  The colors do not need to mean anything, just stand out especially when viewing multiple day entries which are un-labeled for the subsequent days of that week?
    This topic has been closed for replies.

    No problem,

    Just enable the checkbox for Color-code events using a formula and use this formula (or a best practice in fact would be to make this as a formula-test field and then use the formula field itself as the formula for the Color calendar).

    This will randomize across 20 colors based on the last 2 digits of the [Record ID#]

    var number LastTwo = ToNumber(Right(ToText(Rem([Record ID#],20)),2));

    Case($LastTwo,
    1, "e6194b", // red
    2, "3cb44b", // green    
    3, "ffe119", // yellow
    4, "0082c8", //blue
    5, "f58231", //Orange
    6, "911eb4", //purple    
    7, "46f0f0", // Cyan
    8, "f032e6", // maganta    
    9, "d2f53c", //lime    
    10, "fabebe", //pink    
    11, "008080", // teal    
    12, "e6beff", // lavender    
    13, "aa6e28", // brown    
    14, "fffac8", // beige
    15, "800000", // maroon
    16, "aaffc3", // mint
    17, "808000", //olive
    18, "ffd8b1", //coral
    19, "000080", // navy
    20, "808080") //grey"


     
    Terms & ConditionsAccessibility statement