Supported field data types

Supported field data types

Custom fields can be created based on one of the following data types.

The Availability column indicates whether the custom field’s data type is available for person records, organization records, or both.

Data type

Availability

Description

Text

Both

Any combination of letters and numbers, up to 500 characters in length, regardless of the language used.

Long text

Both

text field type whose length is 500 characters or more, irrespective of the language used.

Email

Both

A valid email address, consisting of the format: local-part@domain.address

Number

Both

A whole (integer) number.

Decimal number

Both

A decimal (floating point) number.

Currency

Both

decimal number displayed as currency.

The currency symbol used to represent this field’s values in person and organization record data is based on the Default currency settings (accessible through the General settings page).

Date

Both

A specific day, month and year.

Time and date

Both

A specific time and date.

Boolean

Both

true (on) or false (off) value.

Phone number

Both

A local or international phone number.

Single select

Both

Single select field type

A single select field allows you to define a list of values from which a single item can be selected. When you choose this field type, the Values section appears in the Create field dialog, allowing you to specify each value.

  • Add values: Click Add value (or the + icon) to add a new value field.
  • Reorder values: Use the re-order icon to move any existing value to a new position in the list.
  • Delete values: Use the trash icon to delete a newly added value from the list.

Creating this type of custom field:

  • You can switch between making this custom field a multi-select or single-select field type. Any values you have already specified will remain and apply to whichever field type you choose.
  • Ensure each value is spelled correctly, as it is not possible to edit the text of any value once the custom field has been created.

Multi select

Both

Multi select field type

A multi select field allows you to define a list of values from which multiple items can be selected. When you choose this field type, the Values section appears in the Create field dialog, allowing you to specify each value.

  • Add values: Click Add value (or the + icon) to add a new value field.
  • Reorder values: Use the re-order icon to move any existing value to a new position in the list.
  • Delete values: Use the trash icon to delete a newly added value from the list.

Creating this type of custom field:

  • You can switch between making this custom field a multi select or single select field type. Any values you have already specified will remain and apply to whichever field type you choose.
  • Ensure each value is spelled correctly, as it is not possible to edit the text of any value once the custom field has been created.

Autocomplete

Both

A single value created or selected from existing values.

Link

Both

The URL of a webpage or file.

Aggregate

Person

Aggregate field type

An aggregate field displays a total derived from a specified activity. When selecting this field type, the following fields appear, requiring you to choose a value for each:

  • Activity: Select the type of activity for which the number of occurrences will be aggregated.
  • Aggregate by: Choose the type of aggregate calculation to apply. The available options depend on the activity type chosen above.
  • Aggregate time period: Specify the period of time (from the current time) over which the number of activity occurrences will be aggregated.

Object

Both

JSON object containing custom data.