Create a Custom Function List/Report

The functions list is a list of your functions and associated information which can easily be filtered by various criteria to create quick reports. You are able to save these reports as custom views, which allow you to easily view or export this data with just a few clicks.

• You may create as many views as you wish.
• Views can be shared with other users on a role-by-role basis. If you are sharing views, we recommend locking them so they cannot be changed accidentally.

To create a custom function list, you will:

• Customize the filtering options to specify which functions display.
• Customize the column options to specify the column order and which columns display.
• Save the settings to a saved view.

You can then download the list/report.

Go to the Functions List

Click where_to_vote Events on the left and select the Functions tab.

Customize the Filtering Options

To customize the filtering options to specify which functions are listed:

1. Click the filter_list filter icon to open the edit filters slider.
2. On the edit filters slider, you can:
   1. Select a date range.
      • You may set a date range, select all days, or set a relative date range. Next 30 Days and Past 7 Days are preset relative date ranges, or you can set a custom relative date range.
        Multi-day functions will appear in the list if any day of the function falls within your selected date range.
        

      Set a Custom Relative Date Range

      1. Select Relative Dates in the Date Range dropdown.
      2. Enter the start parameters:
         1. Choose an option from the dropdown.
         2. Enter the number of days relative to the prompt.
         
      3. Enter the end parameters:
         1. Choose an option from the dropdown.
         2. Enter the number of days relative to the prompt.
         
      4. The preview dates under the start and end parameters will update, allowing you to confirm your choices.
   2. Select a staff member. Only functions for events where that user has an event or function staff assignment will be displayed. For more information about staff assignments, please see Staff Assignments for Events and Functions.
   3. Select the statuses of the functions you would like to show.
   4. Select the functions types of the functions you would like to show.
   5. Select business classifications to only show functions on events which have the selected business classifications.
   6. Select event types to only show functions on events of the selected type.
   7. Check Show Inactive to show functions on cancelled and lost events.
   8. Check Only Performance to only show functions that are performances.
   9. Check Show Event-Wide Functions if event-wide functions should be shown.
   10. Check Only No-Room Functions to only show functions that do not have rooms.
   11. Select the rooms you want to include.
3. Click Set to apply your filters.

Customize the Column Options

To specify which columns appear and the order they are in:

1. Click the view_column columns icon in the upper-right.
2. On the edit columns slider, you can:
   • Click and drag the dots on the left to move a column somewhere else in the list.
   • Click the visibility eye icon to show or hide a column.
3. Click Set to apply your column layout.
4. The column the list is sorted by will display the arrow_upward sort icon. You can click other headers to sort the list by that column's data. Clicking the header again will toggle between the list sorting in ascending or descending order.
5. You can drag the borders between the list headers to resize each column.
6. In the lower-right corner, click the current number of events shown per page to open a dropdown with more options for that setting.

Save the Settings to a Saved View

1. Click the + plus icon in the upper-left.
2. In the Create View slider, name your view. You have the option to:
   1. Create a private view, which only you can see. (If you have Edit Private Shared Views permission, this is the only type of view you can create.)
   2. Create a shared view. To share a view, uncheck Private and select the roles which should have access. Be sure to select your own role, or you won't be able to see the view! Please note: If you select All, a list of roles is not saved with the view. There are no restrictions, and all users will be able to see it regardless of their role.
      Each saved view is "owned" by its creator. If the owner's user account is deactivated, the saved view is no longer shown in the application and the ical feed is unpublished. This behavior is to ensure data security. To keep critical saved views, they must be copied to a new owner. See Copy a Saved View for instructions.
   3. Check Default view to make the shared view a default view for those roles.
   4. Lock the view. If you are sharing the view, we recommend locking it so others cannot change it accidentally.
3. When you are done setting up the view, click Save.
4. Your new view will now be the selected view. 
5. If you make any additional updates to your view, the Save and Clear icons will appear. Click the save save icon to save your changes or the clear clear icon to remove them. If the view is locked, click the settings gear icon to open the Settings slider and unlock it.

Download the List/Report

To download the view to Excel, click the cloud_download cloud icon in the upper-right corner.