Supported Field Types

Field Types Overview

ThingsHub provides a range of field types that allow you to store and manage various kinds of data.

Each field type comes with unique configuration options. Some field types support sorting and filtering based on the data type when used with Views.

This following table details each field type's configuration options, sorting, and filtering capabilities.

Supported Field Types

1. SingleLineText

• Type: SingleLineText

• Description: This field is used to store a single line of text, suitable for short descriptions, names, titles, or any data that doesn't require multiple lines.

• Configuration: No configuration is required.

• Filtering & Sorting:

  • Filtering: Supported

  • Sorting: Supported

2. Number

• Type: Number

• Description: This field type is designed to store integer values (whole numbers), making it ideal for quantities, counts, or other non-decimal data.

• Configuration: No configuration is required for this field.

• Filtering & Sorting:

  • Filtering: Supported

  • Sorting: Supported

3. Decimal

• Type: Decimal

• Description: Used for storing floating-point numbers with decimal places. This is useful for precise measurements, calculations, and any data requiring fractional values.

• Configuration:

  • Decimal Places/Precision: You can configure the precision of this field, by selecting how many decimal places the value should display. Options range from 1 to 8 decimal places.
    

    

  • The value is stored with the full precision entered, regardless of the display precision.

• Filtering & Sorting:

  • Filtering: Not supported

  • Sorting: Supported

4. Checkbox

• Type: Checkbox

• Description: This boolean field represents a true/false or checked/unchecked state. It is ideal for simple on/off, yes/no, or boolean flags.

• Configuration: No configuration is required.

• Filtering & Sorting:

  • Filtering: Supported

  • Sorting: Not supported

Field Types Coming Soon

Support will also be added for the following field types in the future:

5. Percentage

• Type: Percentage

• Description: Represents percentage values, typically used for statistics, performance metrics, or any data expressed as a percentage. The value can exceed 100% if needed (e.g., 150% or more).

• Configuration: No configuration is required.

• Filtering & Sorting:

  • Filtering: Not supported

  • Sorting: Not supported

6. DateTime

• Type: DateTime

• Description: This field is used for storing both the date and time, making it perfect for timestamps, deadlines, appointments, or any other time-sensitive data.

• Configuration:
  

  

  • Date Format: You can select from the dropdown of several supported date formats, including YYYY-MM-DD, DD-MM-YYYY, MM-DD-YYYY, etc.

  • Time Format: Time is stored in a 24-hour format. You can choose between HH:mm:ss, HH:mm, or HH:mm:ss.SSS, depending on the level of precision needed.

  • The 24-hour time format is used to represent the date time. This cannot currently be configured.

• Filtering & Sorting:

  • Filtering: Not supported

  • Sorting: Not Supported

7. SingleSelect

• Type: SingleSelect

• Description: This field allows the user to choose from a predefined list of options. It’s useful for scenarios where only one choice from multiple options is allowed, such as selecting a category, status, or any other predefined value.

• Configuration:

  

  • Options: A list of string values that represent the available choices for the user.

  • For example: If the field contains the options Red and Green, the field will only accept the values Red and Green. This field cannot be assigned any other values except Red and Green.

  • Changes in any option value in the field configuration will also update the value in the underlying data.

• Filtering & Sorting:

  • Filtering: Not supported

  • Sorting: Not supported