How to Highlight a Calendar based on a field

[#1]

I have created a custom application including a set of daily events which I display in a calendar report. I would like to be able to highlight these events in the calendar view based on certain fields contained within the event but cannot see a way of doing this.

The Forward Schedule of Change Calendar Report appears to include this functionality - it has a section above the calendar with 3 radio buttons allowing the user to select 'Escalation', 'Priority' or 'Approval'. The functioality then highlights the calendar entries according to the value for those entries for the field selected and using the colors assigned in the Reports -> Color Charts module.

I have assigned Color Values to the values within the fields in the events I wish to highlight but I do not see the 'Highlight based on: ...' text at the top of my new calendar report and as such am unable to select the fields to highlight.

Is anyone able to advise on how to use the report highlighting functionality for calendars and whether I can repolicate the 'Highlight based on' functionality as used in the FSC report?

Many thanks, Dan

[john_roberts]

The calendar report highlight options are created from the field styles on the table. You need to 'personalize styles' for the fields you are interested in coloring then they should appear as 'highlight based on' in the calendar report. I'm not sure if it works on all field types.
You can review the change field styles as a reference.

[marcguy]

while we're on the subject of calendars, am I right in thinking, currently there is no way to personalise which fields are shown on calendars, I have a LEAVE application with a calendar but LEAVE NUMBER and SHORT DESCRIPTION are not much use to me, I would like REQUESTOR and LEAVE TYPE but don't think that's possible currently?
thanks
Marc

[#4]

John - that works perfectly!

Many thanks for this - do you think this informnation could be added to the Wiki for future reference?

Marc,

You can specify what appears as the display field for a table
(see Wiki http://wiki.service-now.com/index.php?title=How_to_change_the_display_values_of_reference_fields)
and this display field will then appear as the default name on the calendar - you can also create a custom field which is calculated using for example

current.u_associate.u_name + ' (' + current.u_location + ' - ' + current.u_shift + ')'

and then set this as the display field and this will display the caluclated merged fileds - does this help?

[john_roberts]

I'm not aware of any settings that would control which fields are displayed on the calendar.