Number

Article Number:040534

Screenshot: A "Number" field 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).
Using Thousands Separators

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

"Number" Field Settings

Screenshot: "Number" field settings

  • Name
    • Specify the label for the field.
  • Hide field name
    • Hide the field name on the "New Record," "Edit Record," "Record Details," and record printing screens.
  • Use thousands separators
    • Select this option to display entered numbers with thousands separators.
      Commas used as thousands separators (,) are only for display purpose and are not character strings in the field.
  • Required field
    • Select this option to require entry of data into the field.
  • Prohibit duplicate values
    • Prohibits users from entering duplicate values in multiple records in the app.
  • Limits of Value
    • Specify integers for the minimum and/or maximum values.
  • Default Value
    • Set the default value for the field.
  • Number of Decimal Places to Display
    • Specifying a number here fixes 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
    • You can specify 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 app form but also on the "View" screen and the History tab.
  • Field Code
    • A string used for specifying this field in formulas or APIs.