Numeric fields

Overview

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

Types of Numeric Fields

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 ($).

Configuring Numeric Fields

1. Drag-n-drop a numeric field type, for example, Currency to the editor area.
2. The Adding 'currency' dialog will be displayed as shown below. In the Label Name text box, specify the Label Name that should appear for this Field in the form. In the Currency Type list box, select the required currency.
3. Click on Options to configure the currency field type. Refer the topic Field Configurations to learn more about each configuration.
   
4. Click Done to add the currency field type with the specified configurations.
5. To edit the field configurations or to delete the field or to add field action scripts, move mouse over the field and click on the Edit this field option.
6. When you Access the application, the currency field named "Rate" will be displayed as shown in the form below. The currency type will also be displayed near the field..