Forum Discussion

ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
6 years ago

Color coding by user on a calendar report

So we have about 6 sales people, and I'd like to generate a calendar report to see what they're all doing each week at a glance. That's easy enough. However, their activities are all the same color, s...
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Your field [Scheduled For] is likely in fact a User field type, not text.

Case([Scheduled For],"USER1 NAME","#3cc151", "USER2 NAME","#a874cb",)​

You can try this
Case(UserToEmail([Scheduled For]),
"fflintstone@bedrock.com", "#hex code", "brubble@bedrock.com", "other hex code")
)



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • ChrisNewsome's avatar
    ChrisNewsome
    Qrew Captain
    6 years ago
    Once again Mark saves the day. Worked perfectly. I couldn't find an instance of this issue anywhere on the discussions. Hopefully this helps many more people.

    ------------------------------
    Thanks,
    Chris Newsome
    ------------------------------