Color-Coding Help

Question

Hi,I'm trying to color code my team's calendar so that the user sees their events in one color, and the rest of the teams events in another color.&nbsp;&nbsp;For example, is Ryan is looking at the calendar all the events he's created are blue, and the rest of the team's events are green.Thank you!------------------------------Elizabeth Frenis------------------------------

austink · Answer

You would need a way to compare the current user to the employee that owns the record I believe. You would create a relationship between your Employees table and whatever table you wanted to filter on. The reference field in the child table for this relationship will be a formula user field that is simply User() to grab the current user at the time they are using the app.

Then in your colorization formula you would want the top most option to be that [Employee] = [Current User] and color code on that. I think that would work for this.

markshnier__you · Answer

Try thisIf([Employee Userid On Record field] =User(), "green", "yellow")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Color-Coding Help

Related Content

Color Code Date Field based on Formula

Color Coding based on field value

Color coding report based on Date Modified

Color coding formula

Color-coding a field returns field name