Number (Decimal) Fields

Learn about Decimal Number fields in Noloco tables

Decimal Number fields are for storing numbers with decimal points, and they are particularly useful when precision is essential, like when storing a rating value of 5.5.

Technical Limits: Like integer fields, decimal fields are also limited by JavaScript's maximum safe integer value of 9,007,199,254,740,991. This applies to the whole number portion of decimal values.

Decimal Number Field Formats

• Default By default, the decimal number field shows a formatted number such as 1,234,000.00

• Currency Display the number as a currency, and choose the specific currency symbol. For example: £1,234,000.00

• Percentage Display the number as a percentage, values such as 0.2 will be displayed as 20%

• Unformatted This displays the number without formatting, such as 1234000.00. This is useful for numbers that aren't really numbers, like Postcodes, or Object IDs

Decimal Field Options

• Allow negative numbers Depending on the format chosen above, you can optionally enable or disable the use of negative numbers in the field, which will be enforced in all forms

• Prefix Configure a prefix for your numbers, such as USD 123,000.00

• Suffix Configure a suffix to your numbers, such as 12,000.00 Units

• Precision Configure how many decimal places your decimal field should show, from 1 to 8

Use Cases

Decimal fields are ideal for:

• Precise monetary calculations

• Scientific measurements

• Percentages and ratios

• Ratings with decimal precision

• Weight, height, and other measurements

• Price calculations requiring exact amounts

Best Practices

• Set appropriate precision levels (number of decimal places) based on your use case

• Use Currency format for all monetary values

• Use Percentage format when storing rates, completion percentages, or ratios

• Consider using prefixes/suffixes to provide units of measurement

• Be mindful of precision requirements - more decimal places aren't always better for user experience