Modify or add calendar report system properties

Specify system property values to override Task table highlighting in calendar events, limit the number of events in a calendar cell, or change the day the calendar week starts.

Override Task table field styles for highlighting calendar events

Highlighting for calendar report events is configured with field styles, which are defined for a particular table. You can configure whether calendar reports use field styles from the tables or report sources that they are based on.

Before you begin

Role required: admin

About this task

By default, field styles in the Task [task] table are applied to calendar reports. If calendar reports are configured to use field styles from their tables or report sources, these field styles override the Task table styles.

Procedure

  1. In the filter navigator, enter: sys_properties.list
  2. Select the glide.ui.report.extend_calendar_choices property to specify which field styles are used during calendar highlighting.
    • To use field styles in only the Task table, set the property to false.
    • To use field styles from the table that the calendar report is based on, set the property to true.
  3. Click Update.

Limit the number of events displayed on calendar days

For calendar reports, the maximum number of events that appear in some calendar views is configurable. When this maximum is exceeded a + <number> link appears, which opens a pop-up window with additional events. You can also configure the maximum number of events that appear in this pop-up window. When this maximum is exceeded, a + many link appears, which opens a list of events instead of a pop-up window.

Before you begin

Role required: report_admin, admin

About this task

You can configure these settings for the following calendar views:
  • A calendar day when calendar is in month or year view
  • The top 'full day' section of a calendar day when a calendar is in day or week view

Procedure

  1. In the navigation filter, enter sys_properties.list.
  2. Configure the glide.report.calendar.max_events_displayed_per_cell and glide.report.calendar.max_more_events_per_day properties.
    For more information, see Available system properties for information about these properties.
  3. Click Update.

Change the day that calendar weeks start on

By default, weeks for calendar reports start on Monday. You can add a system property to start weeks on Sunday instead. Weeks use ISO numbering regardless of what day they start on.

Before you begin

Role required: admin

The glide.ui.filter.first_day_of_week system property modifies the generated date/time value used in the query and sets the start day of the week in the rendered calender.

Procedure

  1. Add the glide.ui.filter.first_day_of_week system property.
    For more information, see Add a property
  2. Set one of the following integer values:
    OptionDescription
    Start weeks on Monday Set Value to 2
    Start weeks on Sunday Set Value to 1
  3. Click Submit.

Set calendar record limit

By default, calendar reports save up to 10,000 records. Change this limit by setting the glide.ui.max_calendar_records system property. If the number of records fetched exceeds this limit, you are prompted to filter the data and run the report again.

Before you begin

Role required: admin

Procedure

  1. Add the glide.ui.max_calendar_records system property.
    For more information, see Add a property
  2. Complete the form with the following values.
    OptionDescription
    Name glide.ui.max_calendar_records
    Description Enter a phrase that describes the function of the property, such as Maximum number of calendar records saved.
    Type Integer
    Value Enter the desired value for the number of records retained by the platform. The default value if this property is not configured is 10,000.
  3. Click Submit.