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.

Numbers are displayed based on your browser settings

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)