Set decimal points for form fields

Applicable to the following numeric fields: Percent , decimal , and currency .

1. Open the form builder.
   
2. Select the required field. Navigate to the  Field Properties -> Validation  section, displayed on the right.
3. Enter a value within the  Max Digits  value in the input box next to  Decimal Points .
   

   

If you set  Decimal Points  with a value equal to or greater than  Max Digits , Zoho Creator will display the following prompt:

In the event that you set the  Decimal Points  property with a value that is less than the number of digits (after the decimal point) present in existing records, Zoho Creator:

• Rounds off the decimal values (stored in that field) of existing records to the newly set  Decimal Points  value, and displays these adjusted values when a user accesses the corresponding report
• Rounds off the decimal values (stored in that field) to the newly set  Decimal Points  value, and displays this adjusted value in that field's input area when a user accesses a record to update it
• Applies the new  Decimal Points  value to validate records added after this change
  

Related Topics:

1. Understand fields
   

2. Understand decimal points for form fields