Field data types
When creating custom fields, you can choose from a wide range of data types to define what kind of information each field will contain. The following table describes the available data types in ChartHop.
Data type | Description |
Short text | Stores short strings, such as a person’s preferred name. See String. |
Long text | Stores longer strings, such as a paragraph of text in a form response. See String. |
Integer number | Stores whole numbers. See Number. |
Decimal number | Stores both decimals and whole numbers. See Number. |
Percentage | Stores percent values. See Percent. |
Yes/No | Stores true/false values. See Boolean. |
Date | Stores dates. See Date. |
Money | Stores currency values, such as 10 USD. See Money. |
Person | Stores individual people. See Person. |
Persons | Stores multiple people, such as a group of peer reviewers on a form. See PersonList. |
File | Stores uploaded files, such as an offer letter. See File. |
Single select | Records a single response from a list of options. See Enum. |
Multiple select | Records multiple responses from a list of options. See Enum. Note that each item in the list should be separated with a semi-colon when importing. |
Numeric scale | Records a single response from a list of numbered options. See Enum. |
Smart calculation | Calculates a numeric value using Carrot Query Language (CQL). See Working with smart fields. |
Smart bucket | Records a single response from a list of options. Each option contains a smart calculation. See Working with smart fields. |
The data type you select determines what kind of value a field can store. For example, a number field can only store a value like 56. If you expect to receive responses containing either a string value (fifty-six) or a number value (56), use the string data type to capture them, since numbers will automatically be converted to strings (for example, 56 to "56"). If you need to store the responses as numbers for reporting purposes, you can create a second custom field that converts the value to a number. Learn more.
