Number

You can place a Number field to allow entering a numerical value.
You cannot enter any value other than numerical values.
You can enter numerical values in other fields (for example, in a Text field) as well. Note that, values entered in Number fields are treated as numerical values, but values entered in other types of fields are treated as strings. In that case, you cannot perform four arithmetic operations, or filter data in the record view using conditions such as "more than the specified value" or "less than the specified value".
If you want to perform four arithmetic operation or to filer data in the record view, you need to use the Number field.

In the Number field, you can display comma-separated value, or use unit of measure (for example, ¥ mark).

Usage Examples

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

  • Register a "unit price" or "number of users" in a project management app or a quote app
  • Perform calculation using the filter feature based on the values entered, and analyze the total value or the average value
  • Create a graph based on the values entered
Project management app example

Setting Options for Number Fields

Number field
  • Field Name
    • Specifies the header for the entry item.
  • Hide field name
    • Hides the field names on the screens to add, edit, enter details of, and print records.
  • Use thousands separators
    • Display entered numbers with a thousands separator.
      Thousands separators are not displayed when entering records. Commas are used only for display purpose, and are not used as characters in fields.
  • Required field
    • Sets a field where a value is required to be entered.
  • Prohibit duplicate values
    • Prevents users from entering a duplicate value between multiple records in the app.
  • Limits of Value
    • Specifies the integer value of the minimum value, maximum value, or both.
  • Default Value
    • Set a value that will appear in the entry field by default.
  • Number of Decimal Places
    • Sets a specified number of digits after the decimal point to be displayed.
      The decimal part that exceeds the specified number of digits will be rounded down.
      Since the record value itself is not changed, actual numeric value is used for calculation if the Number field is specified in the formula.
      Example of when "2" is set for the number of digits to be displayed
      Actual value Displayed Value
      1 1.00
      1.007 1.00
  • Currency
    • Specifies a unit symbol to be prefixed or suffixed to the field, such as "¥" or "meter".
      Unit symbols are displayed on the form, and also on the "Record List" screen and in the history.
  • Field Code
    • The text string to specify this field (in a formula or an API).