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

Question

I'm wondering if I can assign a color to a line on my calendar if the field just&nbsp;_contains_ a word or phase in it...not the entire field text?&nbsp; 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.&nbsp; I'd like all the ones that say "Truck 1" to be the same color, regardless of what comes after that phrase.&nbsp; Same with "Truck 2".&nbsp; Can this be done with a formula some how?&nbsp; Thx, Mark

quickbasecoachd · Answer

There are several ways to do this but I suggest making a field like this, as a formula text field type called

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.

markglevicky · Answer

Thank you.&nbsp; I'll give it a try soon!&nbsp; Now if I can find a way to change the icon marker colors in the map for different trucks I'll be batting 1000!

quickbasecoachd · Answer

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

markglevicky · Answer

Thank you!&nbsp; I'll check it out!

Forum Discussion

Color calendar if field contains a certain word or character

Related Content

Calendar Reports not Loading

Help extracting text between unique character

Formula using Contain

Extract Text Between 2 special characters

Records that contain several sub items