A User-Defined Column is a custom report column that you create for account reports.
You can create up to 20 user-defined columns per report.
Each user-defined column can be one of two types.
The first type pulls the first non-blank value from up to three different columns.
The first type uses a default text label when there is no value.
The second type is a combination of multiple columns.
Click Add New to create a new user-defined column.
Existing custom columns are listed in a table.
Click a custom column to edit it.
Click the delete control to remove a custom column.
The custom columns added here are available in Available Data Fields on the Columns page to add to the report.
Column Details
User-Defined Column
The User-Defined Column is the label for the custom column in report screens.
Column Name
Column Name is the name of the column as it should appear in all report screens.
Maximum length is 25 characters.
Column Definition
Column Definition is where you specify which Certain field(s) will make up the user-defined column.
A custom column can be defined as 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 using three drop-down lists plus a free-text field.
This option pulls 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 (for example, “[blank]” or “missing”).
Example
Example: State/Province
or: Province/District
or: City
or: [blank]
This example column would 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
Combine two or more columns – 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 step
Once the user-defined column is created it can be added to the report in the Reports > Columns page.