Proposal Calender that list start and end dates, how do I make each active proposal a different colour?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I'm making a calender that lists all proposals start and end dates but it looks confusing when each proposal is the same colour. How can I give each active proposal a different colour so it can be read easier?

Photo of Hannah

Hannah

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,670 Points 50k badge 2x thumb
Do you actually mean a calendar report Type? Just want to clarify.
Photo of Hannah

Hannah

  • 0 Points
yes, its a Calender Report. Right now every proposal is blue
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,670 Points 50k badge 2x thumb
I will give you a partial answer, but I can't write out the code for you on this forum.
There is not an easy way to do that.
If you have a single field that you are showing on the calendar report you can color it.
Here is an example. In my case i wanted three fields to list so I had to concatenate them to make it into one field.

To make them different colors you would need to have your users choose a color for each Proposal or else try to write a formula which cycle through say 10 colors based on the randomness of the Record ID#


var text TextBlock=
List(" | ",
"<b>" & If([Start Time]<ToTimeOfDay ("10:00 am"),"0") & ToText([Start Time]) & "</b>",
[Physician : Location : Report Type],
[Patient Name / Available]);

If(
Begins([Appointment Status],"No Show"),"<font color = red>",
Begins([Appointment Status],"Cancel"),"<font color = red>",

[Patient Name / Available]="Available","<font color = green>") & $TextBlock