Formula Help for a Calendar Report

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

I have a report type Calendar and I want the text of the items on the calendar to display a color based on the region they are from. I have a region field that list (United States, Europe and Asia). Is there a way to do this in a calendar report?  For example if a product is from the United States I want the text on the calendar for that product to be red.  If a product is from Europe I want the text to turn blue and if from Asia I want the text on the calendar to be green.  Any ideas?

Photo of Derek

Derek

  • 30 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,670 Points 50k badge 2x thumb
I suggest making a single concateted field with any fields that you want to show on the calendar and then color that field.  Here is an example

var text Color = Case ([Region],

"US", "<font color=red>",

"Europe", "<font color=blue>",

"Asia", "<font color=green>");



var text TextBlock=

List(" | ", 

[field 1], [field 2], [field 3]);

$Color & $TextBlock
Photo of Derek

Derek

  • 30 Points
Thanks for the response.  I'm not sure I fully understand what you mean by making a single concateted field with any fields that you want to show on the calendar. Can you provide more info on this?