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. Here are a couple of commonly used format patterns to get you started:

Unit
Pattern
Result Examples

Calendar year

y

44, 1, 1900, 2017

yy

44, 01, 00, 17

yyyy

0044, 0001, 1900, 2017

Month

M

1, 2, ..., 12

MM

01, 02, ..., 12

MMM

Jan, Feb, ..., Dec

MMMM

January, February, ..., December

Day of month

d

1, 2, ..., 31

do

1st, 2nd, ..., 31st

dd

01, 02, ..., 31

AM, PM

a..aa

AM, PM

aaa

am, pm

Hour [1-12]

h

1, 2, ..., 11, 12

hh

01, 02, ..., 11, 12

Hour [0-23]

H

0, 1, 2, ..., 23

HH

00, 01, 02, ..., 23

Minute

m

0, 1, ..., 59

mm

00, 01, ..., 59

Format patterns are case-sensitive.

For example, M stands for month, while m stands for minute. Always double-check the case when creating custom formats to ensure accuracy.

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