Betty Blocks Documentation

Building your application

Models

Property format reference for numbers and dates

Specify the number format you need for representing your data. Date and time formats can also be adjusted for local requirements.

You can customize number and date formats to reflect local requirements. This can be to specify the default decimal separator in number formats such as prices or percentages or date formats based and region. For example, while many European countries commonly use day-month-year (d/m/y) with time-based on the 24-hour clock (11:52), the common standard in North America is month-day-year (m/d/y) with time-based on the 12-hour notation (11:52 am).

This article details the different formats available based on the property type selected for:

Dates
Numbers
Prices (based on number formats with specific formatting for detailed pricing)

Applying formats for numbers

When you create a new property, you are requested to specify the property Type (A). The default format (B) applied can be adjusted. In the example below, the property is given the name Month (C) and the format mmmm (D) is applied.

Press Save (E) to save the details provided.

When working with data in Pages, it’s important to understand how formatting applies differently for displaying and altering data:

Displaying data: Components like Text or Data table columns use the defined format in property details (e.g., Date, Time, Number) by default. Use the 'Format value options' feature to select the needed format to display a date, for example:

Altering data: Input components in Forms (e.g., Date picker, Decimal, etc.) bypass the format set in property details. Instead, they load the raw database value, apply their own format, and render it in the input field. Formats must be set directly on the input component.

Formatting available for dates

You can apply the formats as detailed in the following table for the property Types,

Date,
Date-Time
Time

The property is displayed as detailed below in the user interface for your application.

Format:

Displayed as:

Description:

YYYY

2021

Two-digit year

Four-digit year

MMM

MMMM

1-12

01-12

Jan-Dec

January - December

Month, beginning at 1

Month, 2-digits

Abbreviated month name

Full month name

1-31

01-31

Day of the month

Day of the month, 2-digits

ddd

dddd

0-6

Sun-Sa

Sun-Sat

Sunday-Saturday

Day of week, Sunday - 0

Min. name day of week

Short name day of week

Name day of week

0-23

00-23

Hour

Hour, 2-digits

1-12

01-12

12-hour clock

12-hour clock, 2-digits

0-59

00-59

Minute

Minute, 2 digits

0-59

00-59

Second

Second, 2 digits

SSS

000-999

Millisecond, 3 digits

+5:00

+500

Offset UTC, ±HH:mm

Offset UTC, ±HHmm

AM/PM in capitals

am/pm in lowercase

Input component formatting

Input components, such as the Time component or the Date time component, can only use the lowercase 'a' format for am/pm notation and will show in the capital.

The input functionality will ask for AM or PM, and according to your model notation be saved in your model in either capital or lowercase. It will also be displayed according to your model settings.

For more information on input component formatting, see this article (external link).

Relative Date

When using a static value for your date time component, you can also select a relative date, this will be saved in the format you have applied.

The presets resolving (e.g. Today or This month) in the filters is done at the DataAPI level, server side. The current behavior of this resolving process is that it will take the local server time. It does not adhere to the client timezone time from which the actual request is coming.

Formatting available for Numbers

You can apply the formats as detailed in the following table for the property Types,

Number
Number with decimal
Price

Specific formats can also be set for presenting distance and percentages or percentiles. The tables below show the number format required based on how you want information displayed on your user interface.

Input number specified:	Required to display as (see Note 1 below for postfix details):	Specify Format as: (see Note 1 below for postfix details):
1230974	1.2m	`0.0a`
1460	1 k	`0 a`
-104000	-104k	`0a`

Note 1:

a in the format is used to specify averages. Where the format involves an average, a is applied as follows:

Where a number is less than 1000, a postfix is not applied
if a number is between 1000 and 999999, the postfix k is applied
if a number is greater than 1000000, the postfix m is applied

Input number specified:

Required to display as (see Note 2 below for details of postfixes):

Specify Format as:

(see Note 2 below for details of postfixes):

1st

0o

100

100th

0o

Note 2:

When the format involves using o (ordinal), the postfix:

st, nd and rd is applied for 1, 2, 3
th is applied to other numbers.

Number formats

Input number specified:	Required to display as:	Specify format as:
10000	10.000,00	`[.]`
10000	10,000,00	`[,]`
10000	10000,00	`[]`
10000	10.000	`[.].`
10000	10,000	`[,].`
10000	10000	`[].`

Input number specified:	Required to display as:	Specify format as:
10	010.00	`000.00`
0.23	0.23000	`0.00000`
10000	10.000,00	`0.0,00`
-10000	-10,000.0	`0,0.0`
10000,23	10,000,2	`0,0`
10000,23	+10,000,2	`+0,0`
100,1234	00100	`00000`
1000,1234	001,000	`000000,0`
10000,1234	10000.123	`0.000`
10000,1234	10000.12340	`0[.]00000`

Format Price property

You can apply specific price formatting options when you select the Price as the Type when creating a new property.

You can scroll through the Type menu and select Price. The default format is applied (€0,00).

For example, if the number 10000 is entered in a field based on this property type, it is presented in the interface as €10,000.00.

Note: Any text that is placed between quotation marks (") is used as the currency symbol while any currency symbol supported by a keyboard glyph can be used without quotation marks.

Input number specified:	Required to display as:	Specify format as:
1000.234	€1,000.23	`€0,0.00`
1000,2	1.000,2 €	`0,0[.]00 €`
1001	€ 1.001,0	`€ 0,0[.]00`
-1000,234	€1000,0	`€0,0`
-1000,234	€ -1000.23	`€ 0.00`
1230974	€ 1.23 m	`€ 0.00 a`
123,23	MyCurrency 123.23	`"MyCurrency" 0.00`