Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
Thx
On that theme, here was my formula for randomly colorizing the New Calendars.
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", // namy
20, "808080") //grey
On that theme, here was my formula for randomly colorizing the New Calendars.
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", // namy
20, "808080") //grey