Numeric column parameters

Use this parameter to define how numeric columns defined as Single Line Text Box should handle specific values entered.

JSON Identifier: MFS@NumericProperties

Numeric property format

Description

Possible values

AllowZero

AllowZero is used to allow or disallow zero quantity in numeric type single line text box.

Default value is false.

  • True | False or
  • true | false or
  • TRUE | FALSE

AllowNegative

AllowNegative is used to allow or disallow negative value in numeric type single line text box.

Default value is false.

  • True | False or
  • true | false or
  • TRUE | FALSE

MaxWholeNum

MaxWholeNum is used to restrict the total number of characters for a whole number in the single line text box. Possible value is a number.

If MaxWholeNum value exceeds the field length, the field length is used.

MaxDec MaxDec is used to restrict the total number of characters for a decimal number in the single line text box. Possible value is a number.

For fields with a number of decimal places from M3, the M3 number of decimal places is used as the maximum number of decimal.

This example allows zero value and negative value with maximum whole number is 8, and a maximum decimal place of 2:

MFS@NumericProperties={"AllowZero":"true","AllowNegative":"true","MaxWholeNum":"8","MaxDec":"2"}