Field data types

Field data types control how Better Reports stores, filters, and displays a field’s values. Each field displays an icon next to its name that shows its data type.

Number

Use number fields for numeric values. When you choose a number field, you also select a numeric type to control how the value is interpreted and displayed.

Number type fields can have additional formatting applied using a display option when you need more control over how values are displayed.

Icon: 123, %, or $ depending on the numeric type

Numeric types

  • Number: Displays the value as a plain number. Use this when you don’t want a predefined display format, such as currency or percentage. For more control over how values are displayed, use a custom format display option.
  • Currency: Displays the value as a currency. It uses the primary table’s currency unless you apply a currency display option.
  • Percentage: Displays the value as a percentage.
  • Unit: Displays the value with a unit of measure. You also choose a unit display option.
  • Identifier: Displays the value as an ID or reference number.

Text

Use text fields to for words or free‑form strings, such as names or descriptions. When you choose a text field, you can select a text content type to control how the value is displayed in reports.

Icon: abc

Text content types

  • Auto-detect: The default selection when you create a text field. Dynamically chooses a text type based on each value. Auto-detect never displays an image; use Image URL or the Image data type instead.
  • Plain Text: Displays the value in its raw form.
  • URL: Displays links as hyperlinks that open in a new tab.
  • Image URL: Displays the image at that address, up to 200 × 200 pixels.
  • HTML: Displays the value as formatted HTML.
  • JSON: Displays the value as formatted JSON in a code block.
  • Code: Displays the value in a code block.

Yes/No (Boolean)

Use yes/no fields for a true or false value.

Icon: Check box

Date

Use date fields for a calendar date without a time.

Icon: Calendar

Date & time

Use date & time fields for both a date and a time value.

Icon: Calendar

Image

Use image fields for images.

Icon: Picture

Binary

Use binary fields for raw binary data, such as encoded files or system-generated values.

Icon: 1010

Dynamic fields

Dynamic fields aren’t a data type, but they have their own icon. Built-in dynamic fields ask you to make a selection, such as a tag or metafield, before the field is added, and are marked with a star icon instead of a data type icon. Custom dynamic fields (parameterised fields) show the icon for their output data type. See Understand dynamic fields.

Icon: Star

Need more support?

If you get stuck or have additional questions, you can contact our team directly through the Help widget in the bottom-right corner — we typically respond within one business day.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.