Numeric-Type

Release date 2019-09-30

Overview

Displays a text field that accepts only numeric values and stores the entered value. Using this Data type it is possible to perform mathematical operations such as automatically calculating the sum of multiple other Numeric-type Data Items.

Configs: Common

mode_edit_outline Item Name
mode_edit_outline Field Name *
Data Type
mode_edit_outline Description
- Correct Errors and Format
mode_edit_outline Note
arrow_drop_down Columns
- 1
- 2
- 4

Configs: Numeric-Type

check_box Required
arrow_drop_down Number Format
- 1234567.89
- 1,234,567.89
- 1234567,89
- 1.234.567,89
mode_edit_outline Initial Value
- Manually input string
- arrow_drop_down Insert expression…
  - Case ID
  - App ID
mode_edit_outline Number of decimal places
mode_edit_outline Prefix
mode_edit_outline Suffix
mode_edit_outline Minimum Value
mode_edit_outline Maximum Value
mode_edit_outline Expression (for inputting a formula)

Capture

Settings Screen

Input Screen

Notes

To input/edit Data Items, the editing authority in the task must be set to “Editable”
A value that can be entered is between -1 trillion and +1 trillion with up to 10 decimal places
The format of the decimal point and delimiters can be selected from four international standards
- If you enter delimiters other than those specified at Number format in the Data Item or non-numeric characters, it will result in an error
Decimal places can be limited by specifying the desired number
Suffixes and prefixes can include alphanumeric and symbol strings to qualify the value, e.g. currency (Up to 20 characters)
Mathematical operations can be performed using the Expression field to input a formula
- E.g. #q_numeric + 1, #q_unitPrice * #q_quantity, (#q_orderTable1.summary[‘subtotal’] – #q_discount) * (1 + #q_taxRate)
- Digits beyond the position specified by “Number of decimal places” are truncated. By adding “0.5” within the calculation formula, you can achieve rounding to the specified decimal place.
Numeric-type data referenced in a formula must have been set to display
- non-input will be handled as “0”
- If the referenced Numeric-type data is set to “No display”, the input screen and the processing result may be different
Initial value and Expression cannot be configured simultaneously
Input in the [Description] field is in Markdown format. For details on how to write it, refer to “Data Item Description”