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

Updated 01 Jun 2023

Did this page help you?

Yes

Modify a custom field

Working with smart fields

Docs powered by archbee

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.