Column Data Types

When setting up a custom column it is important to specify a data type.  This defines the kind of information stored in the column. For example, a line of text or currency are data types.  This will help clarify your results and confirm that your import data is compatible when importing clips from a third-party monitoring service.

Column Type Type Example Description
String abc... Allows users to enter any combination of letters, numbers, or symbols.
Number Whole 123 Allows users to enter any number. This is treated as a real number and any leading zeros are removed.
Decimal 25.52 Allows users to enter any decimal number. This is treated as a real number, .00 is added to whole numbers and any leading zeros are removed.
Currency $123.61 Allows users to enter a currency amount. The system automatically formats the field as a currency amount. This can be useful if you export data to a spreadsheet application.
Boolean True/False Allows users to check a box, indicating a true or false attribute. When using a checkbox field for a report or list view filter, use “True” for checked values and “False” for unchecked values. The Clip Import Wizard uses “1” or "True" for checked values and “0” or "False" for unchecked values.
Date Time mm/dd/yyyy Allows users to enter a date or pick a date from a popup calendar. In reports, you can limit the data by specific dates using any custom date field.