- Description
- Character field formatting
- Numeric fields formatting (Integer and Decimals)
- Option explanation
- Currencies
- Setting up Default Values
- Date and datetime formatting
- Setting up Default Values
- Further information
Description
There are several ways to ensure the right formatting of a field. The format options of the following types of a field are available:
- Character field formatting
- Numeric fields formatting
- Date and datetime formatting
Character field formatting
You can use regular expressions definitions to specify the format of a character field. The definition is added in the extendedFormat attribute in the designer.
We support the following masks:
Mask | Sample (extendedFormat) | Description |
Static Mask | (9999) 999-9999 | E.g. for telephone number formatting “(0049) 123-1234” |
Dynamic Mask | aa-9{1,4} | the 9 digit can occur 1 to 4 times |
Regular Expressions | regex:[a-zA-Z]{2,} | Matches two or more letters (both uppercase and lowercase) |
- 9 → numbers
- a → letters
- * → alphanumeric characters
Numeric fields formatting (Integer and Decimals)
A custom format can be specified by setting the extendedFormat attribute in the corresponding field. If the attribute is set, it will overwrite the default values (or parts of it). This attribute has up to 6 options pipe-separated and the following structure: ”format|groupSeparator|decimalSeparator|maxLength|minValue|maxValue”
Option explanation
No. | option | value | description | Sample Values |
1 | format | [+]0,000[.00][characters] | The format must always use as separators the ‘,’ for groups and the ‘.’ for decimals. The format specifies the number of digits in a group and the number of digits for the decimal part.
Starting with optional + means that only positive values are allowed.
You can add optional chars, e.g. “0,000.00 %” or “0,000 Hours”
Keep in mind, that integer doesn’t have decimal places but you have to specify this separator at the moment. | i) 0,000.00 groups of 3 digits and 2 decimals (1,234,567.89)
ii) 0,00.000 groups of 2 digits and 3 decimals (1,23,45,67.891)
iii) 0,000 groups of 3 digits without any decimals (1,234,67)
iv) +000 no grouping no decimals (1234567), only positive values
v) 0,000.00 % groups of 3 digits and 2 decimals with percentage sign (23,56 %) |
2 | group separator | any character | Define the separator between one and the other group | E.g. , . - etc. |
3 | decimal separator | , . | Define the separator for the decimal places | , . |
4 | max Length | numeric value | Define the max length of a numeric value, the maximum amount of digits a user can put in the field | 5: max 5 digits (12345) |
5 | min Value | numeric value | Defines the minimum value | ≥ 25 |
6 | max Value | numeric value | Defines the maximum value | ≤ 80059 |
extendedFormat = 0,000|-|,|9|10|875000009
extendedFormat = {"format":"","groupSep":"","decSep":"","maxLength":"","minVal":"","maxVal":""}Currencies
The default currency symbol is the one specified in the PASOE configuration file in the following field: app.sessionData.mainCurrencySymbol
If the isCurrency attribute is set for a field in Form/column in Grid, then the field will be displayed with the default format and the mainCurrencySymbol will be added in the field.
If both the extendedFormat and isCurrency are specified for a field, then only the extendedFormat will be used. In order to add a currency for this field, the user must set it in the extendedFormat (e.g. $0,000.00).
Setting up Default Values
The default format for numeric fields in Form/columns in Grid is the one specified in the PASOE configuration file:
globalNumericFormat = 0,000.00
globalNumericGroupSep = ‘.’
globalNumericDecSep = ‘,’The data type of the field (attribute data-type) can be either Integer or Decimal.
- If it’s integer, the default format will be the one specified in ‘globalNumericFormat’, without the decimal part.
- For integer fields, the user will not be allowed to set decimal values.
Date and datetime formatting
The DATA-TYPE attribute specifies if the field is ‘date’ or ‘datetime’. The accepted values are date for date and datetime-tz for datetime.
A custom format can be specified by setting the extendedFormat attribute in the corresponding field. If the attribute is set, it will overwrite the default values (the ones specified in the PASOE configuration file).
Variable | description |
%d | day as a number with leading zero, 01..31 |
%m | month as a number with leading zero, 01..12 |
%Y | year as a number, 4 digits |
%H | hours 24-format with leading zero, 01..24 |
%i | minutes with leading zero, 01..59 |
Sample: extendedFormat = %d.%m.%Y %H:%i —> 23.08.2023 19:07
Setting up Default Values
The default format for numeric fields in Form/columns in Grid is the one specified in the PASOE configuration file:
globalDateFormat - %d.%m.%Y
globalDateTimeFormat - %d.%m.%Y %H:%iFor displaying dates, there are datefields in Form/Grid which have an attached Datetimepicker to them on the left side.
Further information
UiInteractionService: Anonymizing form and grid fields via BlurringBack to 
Documentation
Back to Home Page