Forum Discussion

MarkGlevicky's avatar
MarkGlevicky
Qrew Cadet
7 years ago

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

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 "Truc...
Formulas and functions
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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.