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
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:
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
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