Formatting Fields

Formatting options available to a field depend on the type of data within them. Currently, formatting is available for the following data types:

  • Number

  • Time & date

These options are available in formula fields that return supported data types too!

Number

For Number fields, the following formatting options are available:

  • 0.X: Displays the original number without formatting.

  • 0.00: Formats the number to two decimal places.

  • 0.000: Formats the number to three decimal places.

  • SCI: Displays the number in scientific notation.

  • SCI3: Scientific notation with the coefficient rounded to three significant figures.

  • Rounded: Rounds the number to the nearest integer

Date / Time & date fields

Fields can be configured to customize both the format and the timezone. The same configuration can also be applied to formula fields that return a Datetime value.

Adjusting format

Users can customize Date/Time & date formats using our presets or by creating custom formats. We support date-fns and Unicode Technical Standard #35 standards.

Adjusting timezone

Time & Date fields are displayed in the user's local timezone by default. To ensure all users see the same timezone, disable "Use user's local timezone" and select from the dropdown list. Use the search function to quickly find your timezone. The actual timestamp remains consistent and is adjusted according to the selected timezone settings.

The chosen timezone will be flagged on the date picker when filling in fields to avoid any confusion.

Last updated