The User-Defined Column Details page allows you to create up to 20 report columns based on fields in your event.
Each custom column can be one of two types.
The first non-blank value from up to three different columns, with a default text label, is one type.
A combination of multiple columns is the other type.
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 control to delete it.
The custom columns added here are available on the Columns page to add to the report.
Columns
User-Defined Column
Column Name is the name of the column as it should appear in all report screens.
Maximum length is 25 characters.
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.
This process saves you 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 (3 drop-down lists, plus a free-text field) is an option.
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'.
Example:
An example value is State/Province.
An example value is Province/District.
An example value is City.
An example value is [blank].
Combine two or more columns is used to combine two or more Certain columns into a single report column.
For example, list registrant's full name in a single column.
First, select Prefix in the drop-down list and click Append.
Next, select First Name and Append.
Then, select Last Name and Append.
Finally, select 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.
Once the user-defined column is created it can be added to the report in the Reports > Columns page.
User-Defined Column (definition details)
Column Name is the name of the column as it should appear in all report screens.
Maximum length is 25 characters.
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 (saving you 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 (3 drop-down lists, plus a free-text field) is an option.
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 such as '[blank]' or 'missing'.
Example: An example value is State/Province.
Example: An example value is Province/District.
Example: An example value is City.
Example: An example value is [blank].
Combine two or more columns is used to combine two or more Certain columns into a single report column.
For example, list registrant's full name in a single column.
First, select Prefix in the drop-down list and click Append.
Next, select First Name and Append.
Then, select Last Name and Append.
Finally, select 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.
Once the user-defined column is created it can be added to the report in the Reports > Columns page.