Number

This field allows only numbers to be entered.
This field differs from the "Text" field in the following areas:

  • Values can be displayed with a thousands separator.
  • Acceptable entry range can be specified.
  • Data can be filtered and sorted with the filter feature using such conditions as "value greater than the specified" and "value less than the specified".
  • Not subjected to a full-text search.

Field Settings

  • Field Name
    Specifies the header for the entry item.
  • Hide field name
    Hides the field name in the records screen.
  • Field Code
    Used for the automatic calculation feature.
    If the field code is not specified, the system automatically sets the field code.
    Automatic Calculation
  • Use thousands separators
    Display entered numbers with a thousands separator.
  • 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.
  • Limits of Value
    Specifies the integer value of the minimum value, maximum value, or both.
  • Default Value
    Sets the default value.
  • 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. The value of the record will remain unchanged.
    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.