Color calendar if field *contains* a certain word or character

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
I'm wondering if I can assign a color to a line on my calendar if the field just contains a word or phase in it...not the entire field text?  For example, my field has the phrases "Truck 1" or "Truck 2" in them, followed by verbiage on time frame we are to be at that customer.  I'd like all the ones that say "Truck 1" to be the same color, regardless of what comes after that phrase.  Same with "Truck 2".  Can this be done with a formula some how?  Thx, Mark
Photo of Mark Glevicky

Mark Glevicky

  • 516 Points 500 badge 2x thumb

Posted 3 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
There are several ways to do this but I suggest making a field like this, as a formula text field type called [Truck Color]

IF(
Contains([My field],"Truck 1"), "Red", 
Contains([My field],"Truck 2"), "Yellow")

Now you have a text field.  The just use the native options to select a color for each of those choices.   Any text or checkbox field can be used to set a color.



Photo of Mark Glevicky

Mark Glevicky

  • 516 Points 500 badge 2x thumb
Thank you.  I'll give it a try soon!  Now if I can find a way to change the icon marker colors in the map for different trucks I'll be batting 1000!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
if you need a map report with different color pins and ability to have different letters on the pins, Juiced has an add on.

https://www.juicedtech.com/qb-maps

Photo of Mark Glevicky

Mark Glevicky

  • 516 Points 500 badge 2x thumb
Thank you!  I'll check it out!