Number (Integer) Fields

Learn about Integer Number fields in Noloco tables

Integer fields are optimized for holding whole numbers. They are essential when you need to count items or denote a rank, storing values like 5. These fields use numeric inputs and allow for customization by setting minimum and maximum value limits, providing control over the range of acceptable inputs.

Technical Limits: Integer fields are limited by JavaScript's maximum safe integer value of 9,007,199,254,740,991 (approximately 9 quadrillion). Values larger than this limit may not be handled correctly and could cause validation errors.

Integer Number Field Formats

  • Default By default, the integer number field shows a formatted number such as 1,234,000

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

  • Rating Display the number as a star rating. You can configure how many stars should be displayed (the max value)

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

  • Slider Displays the number as a slider when used as an input, and a visually similar progress bar otherwise. Configure the min, max, and step value of the slider.

Integer 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

  • Suffix Configure a suffix to your numbers, such as 12,000 Books

Use Cases

Integer fields are perfect for:

  • Counting items (inventory, users, etc.)

  • Rankings and scores

  • Quantities and amounts

  • Ratings and reviews

  • IDs and reference numbers (using unformatted display)

  • Progress tracking (using slider format)

Best Practices

  • Use Currency format for monetary values without decimals

  • Use Rating format for user feedback and scoring systems

  • Use Slider format for values within a specific range

  • Set appropriate min/max limits to prevent invalid data entry

  • Use prefixes and suffixes to provide context (e.g., "USD" prefix, "items" suffix)

Last updated

Was this helpful?