Overview
The User-Defined Column Details page for a report allows up to 20 report columns to be created based on fields in your events. Each 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 is a combination of multiple columns. You can click Add New to create a new user-defined column. The existing custom columns are listed in a table. Click a column to edit it. Click the delete option to remove it. The custom columns added here are available on the Columns page to add to the report.
Types of User-Defined Columns
The first non-blank value from up to three columns
A user-defined column can return the first non-blank value from up to three fields in a specific order. If no value exists for the record in the selected fields, you can enter a label in the free-text field to display in the report (for example, "[blank]" or "missing").
Example values
- State/Province
- Province/District
- City
- [blank]
This example column would return:
- State/Province for records that have a value for State/Province.
- Province/District for records that do not have State/Province.
- City for records that have neither State/Province nor Province/District.
- The text "[blank]" for records that do not have values for State/Province, Province/District, or City.
Combine two or more columns
Use this option to combine two or more Certain columns into a single report column. For example, list a registrant's full name in a single column. You could do this by first selecting Prefix in the drop-down list and clicking Append, then First Name and Append, and again for Last Name, and then for Suffix. The field below the Append section will show: "<{Prefix}><{First Name}><{Last Name}><{Suffix}>". You can add spaces between fields for proper formatting.
Column Definition and Display Options
Column Name
Column Name is the name of the column as it should appear in all report screens. The maximum length is 25 characters.
Column Definition
Column Definition is where you specify 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. A custom column is defined as either a database field or free-text, or multiple columns combined into a single column.
Display the first non-blank from
Display the first non-blank value from up to three fields (three drop-down lists, plus a free-text field). If no value exists for the record in the selected fields, 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".
Example
Example columns can return:
- 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
- The text "[blank]" for records that do not have values for State/Province, Province/District, or City
Combine two or more columns (continued)
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 do this by first selecting Prefix in the drop-down list and clicking Append, then First Name and Append, and again for Last Name, and then for Suffix. The field below the Append section will show: "<{Prefix}><{First Name}><{Last Name}><{Suffix}>". You can add spaces between fields for proper formatting.
Note
A user-defined column must have at least one column selected or at least one character entered in the free-text form field.
Final steps
Once the user-defined column is created it can be added to the report in the Reports > Columns section.
Additional
Was this article helpful? 0 out of 0 found this helpful
Have more questions? Submit a request
[MARKDOWN]