Number

Article Number:040534

By placing a Number field, you can create a field for numerical values.
You cannot enter any value other than numerical values in this type of fields.
You can also enter numbers in other types of fields (e.g., Text field). However, values entered in other types of fields are treated as character strings whereas values entered in Number fields are treated as numerical values. When values are treated as character strings, you cannot perform four arithmetic operations on the values or filter the data on the "View" screen using conditions such as "more than the specified value" or "less than the specified value."
If you want to perform four arithmetic operations or filer data on the "View" screen, use the Number field.

In the Number field, you can display comma-separated values or use a unit of measure (e.g., the "$" symbol).

Usage Examples

If you want users to enter a quantity or an amount, use the Number field.

  • Register "Unit Price" or "Number of Users" in a lead management app or a quote app
  • Perform calculation on the entered values using the filter feature and analyze the total or average value
  • Create a graph using the values entered

Example of lead management app

Setting Options for the "Number" Field

Number field

  • Name
    • Specify the label for the field.
  • Hide field name
    • Hide the field name on the screens to add, edit, enter details of, and print a record.
  • Use thousands separators
    • Displays entered numbers with thousands separators.
      The thousands separators do not appear when entering records. Commas used as thousands separators (,) are only for display purpose and are not character strings in the field.
  • Required field
    • Mandates users to enter a value in the field.
  • Prohibit duplicate values
    • Prohibits users from entering the same value for multiple records in the app.
  • Limits of Value
    • Specifies integers for the minimum and/or maximum values.
  • Default Value
    • Specifies the default value for the field.
  • Number of Decimal Places to Display
    • Specifies the number of digits after the decimal point.
      The decimal part that exceeds the specified number of digits is truncated.
      Since the value itself in the record is not changed, the actual numerical value is used for calculation when the Number field is specified in a formula.
      Example: when "2" is specified as the number of decimal places
      Actual value Displayed value
      1 1.00
      1.007 1.00
  • Unit of measure
    • Specifies a unit symbol to be prefixed or suffixed to the field (e.g., "$" or "yard").
      The specified unit symbol is displayed not only on the form but also on the "View" screen and History.
  • Field Code
    • A string used for specifying this field in a formula or an API.