Often it is useful to define numeric fields in the database for information such as pricing or measurement. A numeric field holds only numbers. Zoho Creator does not allow any other characters to be input in a numeric field. The message "Enter a valid number for <field name>" will be displayed if a user submits the form with a non-numeric value in a Numeric field type. The max number of digits that can be entered into a numeric field is 10.
To enter values like telephone numbers, ID, zip code etc., it is always better to use a text field instead of a numeric field, as these may sometimes start with a zero. In case of numeric fields, Zoho Creator automatically removes the preceding zero.
A Form that displays the Numeric Field Types supported in Zoho Creator
Number:The Number field type holds plain numbers without any decimals, percentage or currency signs.
Decimal: The Decimal field type holds numbers with or without decimal places.
Percent: The percent field type holds numbers as a percentage, with or without decimal places.
Currency: The currency field type holds numbers in the specified currency format, with or without decimal places. The default currency symbol is the dollar sign ($).