User-Defined Column Details (Event Reports)

Overview

On the User-Defined Column Details page for a report, you can create up to 20 report columns based on fields in your event.
Each user-defined column can be one of two types.
The first type uses the first non-blank value from up to three different columns, with a default text label.
The second type constructs a column by combining multiple columns.
Click Add New to create a new user-defined column.
The existing custom columns are listed in a table.
Click a column to edit the column.
Click the delete icon to delete the column.
The custom columns added here are available on the Columns page to add to the report.

The first non-blank value is taken from up to three different columns, plus a free-text field for a label.
This option is used when the custom column pulls from one or more Certain fields.
For each record in the report, the custom column must return the first non-blank value in the specified order.
If no value exists for the record in the field specified, a label can be entered in the free-text field to display in the report (instead of an empty cell), such as “[blank]” or “missing.”

State/Province for records that have a value for that field
Province/District for records that do not have a State/Province
City for records that have neither State/Province nor Province/District
[blank] for records that do not have values for State/Province, Province/District, or City

Use this option to combine two or more Certain columns into a single report column.
For example: list registrant's full name in a single column.
You could first select Prefix in the drop-down list and click Append, then First Name and Append, and again for Last Name, and then for Suffix.
The field below the Append section shows: "<{Prefix}><{First Name}><{Last Name}><{Suffix}>".
You can add spaces between fields for proper formatting.

A user-defined column must have at least one column selected or at least one character entered in the free-text form field.
Once the user-defined column is created it can be added to the report in the Reports > Columns page.

Column Name – The name of the column as it should appear in all report screens. Maximum length = 25 characters.

Column Definition – This section specifies which Certain field(s) will make up a user-defined column, or create a column that consolidates several columns into a single column in your report output (saving the steps of merging cells in a separate application).
Here you can select from the same fields as those that appear on the Groups page for the report.
A custom column is defined as a database field or free-text, or multiple columns combined into a single column.

Display the first non-blank from three drop-down lists, plus a free-text field.
Select this option if the custom column is pulling from one or more Certain fields, and must return the first non-blank value for each record in this order.
If no value exists for the record in the field specified you can enter a label in the free-text field to display in the report (instead of an empty cell) such as “[blank]” or “missing”.

State/Province for records that have a value for that field
Province/District for records that do not have a State/Province
City for records that have neither State/Province nor Province/District
[blank] for records that do not have values for State/Province, Province/District, or City

Combine two or more Certain columns into a single report column.
For example: list registrant's full name in a single column.
This can be done by selecting Prefix, then Append, then First Name, then Append, then Last Name, and finally Suffix.
The field below the Append section shows: "<{Prefix}><{First Name}><{Last Name}><{Suffix}>". You can add spaces between fields for proper formatting.

A user-defined column must have at least one column selected or at least one character entered in the free-text form field.
Once the user-defined column is created it can be added to the report in the Reports > Columns page.