When creating new custom fields in the Force24 platform, you'll be asked to select a data type. This ensures the platform stores and processes your data correctly, based on the kind of information you're 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.
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 don't 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 won't 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.
If you're unsure which data type to choose, feel free to reach out via the live chat in the bottom right corner of your Force24 platform - we're happy to help.