Number

Article Number:040534

Placing a Number field on your app form creates a field for entering number values. Non-number values cannot be entered.
You can also use Number fields to do things like display numbers separated by commas and add units of measure (e.g., the "$" symbol).

Screenshot: Example of a "Number" field

Values entered in Number fields are treated as number values. This means that Number fields can be used in the following cases.

  • When you want to add, subtract, multiply, or divide numbers entered in fields.
  • When you want to use the less than or equal to or greater than or equal to condition on the View screen's dialog for filtering records.

Field settings

Screenshot: The settings screen of a "Number" field

Name

Specify the field name. The field name is displayed as the label of the field in the app.

Hide field name

Selecting the Hide field name checkbox hides the field name on the following screens.

  • The New record screen
  • The Edit record screen
  • The Record details screen
  • The screen for printing a record
  • The Form settings screen

Use thousands separators

Selecting the Use thousands separators checkbox will make it so values in the field are separated by a comma every three digits.
The thousands separator is for display purposes only and is not part of the field's actual string value.

Required field

Selecting the Required field checkbox makes entering a field value mandatory.

Prohibit duplicate values

Selecting the Prohibit duplicate values checkbox prohibits the same value from being specified in multiple records.

Limits of value

Specify the minimum and/or maximum values that can be displayed in the field.
The set minimum and/or maximum value will be displayed under the field on the screens for adding and editing a record.
If a number that is not within the specified limits is entered in the field, an error will appear when the record is saved.

Default value

Set the default value for the field.

Number of decimal places to display

Specify a fixed number of digits to display after the decimal point.
If a value has more decimal places than the specified number, those decimal places will be truncated.

For example, if "2" is specified as the number of decimal places, numbers entered in the field will be displayed in the following way.

  • If "1" is entered in the field, it will be displayed as "1.00".
  • If "1.007" is entered in the field, it will be displayed as "1.00".

Unit of measure

Specify a unit to be displayed before or after the field (e.g., "$" or "yard").

Field code

The character string used for specifying the field in formulas or APIs.

Number format for input fields

The number format of input fields may differ depending on the user's display language or web browser language settings. For example, in Japanese, English, and Chinese, the thousands separators is displayed as a comma (,) and the decimal separator as a period (.).

When either of the following conditions is met, a period (.) is used as the thousands separator and a comma (,) as the decimal separator.

  • The Language in your account settings is Portuguese (Brasil).
  • The Language in your account settings is set to Use Web browser settings and the language of your web browser is set to either of the following:
    • Spanish
      Note, however, that Spanish (United States) and Spanish (Mexico) are excluded.
    • Portuguese (Brazil)

Usage examples

You can use Number fields when you want to create input fields for entering quantities, monetary amounts, or other numeric values.

For example, the Number field can be used in the following ways.

  • When you have an app for managing orders or cost estimates and need a field for entering unit prices or a number of users.
  • When you want to be able to perform calculations on the entered values using the filter feature and analyze the total or average of the values.
  • When you want to be able to create charts based on the entered values.

Screenshot: An example of "Number" fields being used to register a unit price and a number of users