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. |