Contact Extension Field Data Type Definitions

When creating new custom fields in the Force24 platform, you will be asked to select a data type. This ensures the platform stores and processes your data correctly, based on the kind of information you are capturing.

Below is a breakdown of each available data type and how they can be used:

Integer

Stores whole numbers (non-decimal), such as a number of employees. You can query these using filters like greater than, less than, or between.

• Note: The maximum value supported is 2,147,483,647. If you need to store larger numbers, use a Text data type instead.
• Note: Can only store whole numbers—if you need decimals, use Float.

Float

Stores decimal numbers, such as monetary values (e.g. total spend). Supports filters such as greater than, less than, or between.

DateTime

Stores both a date and a time in the format dd/mm/yyyy hh:mm:ss. Ideal for capturing things like appointment bookings to trigger pre-arrival communications.

Date

Stores a date only in the format dd/mm/yyyy. Useful for things like renewal dates or anniversaries.

Time

Stores a time only in the format hh:mm:ss. Supports numerical queries such as equals, before, or after, using 24-hour format.

Boolean

Stores a simple true/false value. This can be queried using yes or no. Commonly used for things like opt-in status or internal flags.

Text

A flexible field that stores up to 4000 characters of free text. Use this when you do not need a specific format—for example, for storing notes or freeform responses.

Email address

Allows you to store an additional email address for a contact. This field is for reference only—it will not be used for sending communications. The main Email Address field is used for all outbound email activity.

Phone number

Stores an additional phone number. As with email address, this is a reference field only. SMS sends will always use the primary phone number field.