Discussions

Expand all | Collapse all

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

  • 1.  Color calendar if field *contains* a certain word or character

    Posted 12-14-2018 14:13
    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


  • 2.  RE: Color calendar if field *contains* a certain word or character

    Posted 12-16-2018 20:41
    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.





  • 3.  RE: Color calendar if field *contains* a certain word or character

    Posted 12-17-2018 20:50
    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!


  • 4.  RE: Color calendar if field *contains* a certain word or character

    Posted 12-17-2018 22:57
    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



  • 5.  RE: Color calendar if field *contains* a certain word or character

    Posted 12-19-2018 14:28
    Thank you!  I'll check it out!