Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
Can I color records in a calendar report?
Yes you can!
You can create a formula text field that will display the value you want to see on the calendar as well as being a colored. In other words, if you want to see the Status of a record in red on your calendar, you could create a formula text field that displays the value from the field Status and is colored red. You would then display this formula text field on your calendar report.
Step 1. Create a Formula - Text field. If you're not familiar with creating a field, the following link explains the steps.
Step 2. Enter the field properties of your formula field. The following link explains how to enter the field properties of a field.
Step 3. Check the "Allow some HTML tags" checkbox in the Text Options section.
Step 4. Enter the following formula into the formula field with the exceptions listed below.
[User Initials]="AC","<div style=\"background-color:#FF9999;\">"&"AC"&"</div>",
[User Initials]="SR","<div style=\"background-color:#99FFCC;\">"&"SR"&"</div>",
[User Initials]="AE","<div style=\"background-color:#FFFF99;\">"&"AE"&"</div>")
The formula above says, "If the value in the field User Initials is blank, do nothing. If the value in the field User Initials is AC, color the field background red and show the text AC. If the value in the field User Initials is SR, color the field background green and show the text SR. If the value in the field User Initials is AE, color the field background yellow and show the text AE." See example color output:
What you need to change to the formula:
1. Replace the words User Initials (everywhere they appear) with the name of the field whose value you want to display on your calendar. If I take my original example where I wanted to show the value from the field Status, I would replace everywhere I see User Initials with the word Status.
2. Replace AC, SR, and AE (everywhere you see them) with those values in your field you want to see on your calendar. Returning to my example of the field Status, I would replace AC with Overdue, SR with In Progress, and AE with Not Started.
3. If you like, you can change the colors that the formula displays. Below is a link to the Wikipedia page describing the hexadecimal codes for colors.
Step 5. Now that you've created your formula and saved the Formula - Text field, the final step is to display the field on your calendar report. The following link explains how to create a calendar report and how to set which fields display on the calendar.
Browse by Category
Knowledge Base Categories
- Accounts (35)
- Application (46)
- E-Mail (7)
- Fields (42)
- Forms (20)
- Formulas (18)
- General (69)
- Other Product (7)
- Pages (1)
- Product (5)
- Reports (15)
- Roles (4)
- Search (1)
- Tables (6)