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.