Number
The Number field is a numerical field that stores integer values. Use it for data such as age, salary, price or quantity.
Create a Number field
- Click the
+icon next to the last field in your table. - Enter a name for the field.
- Select Number from the list of field types.
- Select a Thousands and decimal separators style for the display. Refer to Separator styles below.
- (Optional) To shorten long values in the cell, select a Large number abbreviation option. Refer to Large number abbreviation below.
- (Optional) Set a default value for the field.
- (Optional) Add a description.
- Click Save Field. NocoDB adds the field to your table.
Refer to the general guidelines on creating a field.
Separator styles
Use the Thousands and decimal separators dropdown to set how the cell groups the digits of integer values. Select one of these styles:
| Option | Example (1,000,000) |
|---|---|
| Locale | Uses the browser/system locale of the viewer (for example, 1,000,000 in en-US, 1.000.000 in de-DE) |
| None and period | 1000000 |
| Comma and period | 1,000,000 |
| Period and comma | 1.000.000 |
| Space and period | 1 000 000 |
When you enter or paste values, you can include thousand separator characters (commas, periods, spaces or non-breaking spaces). NocoDB removes them before it saves the value.
Large number abbreviation
Use the Large number abbreviation dropdown to show long values in a short form, such as 1.2M instead of 1234567. The default is None. With None, values stay full length.
| Option | 950 | 1234567 | 3400000000 |
|---|---|---|---|
| None | 950 | 1234567 | 3400000000 |
| Auto | 950 | 1.2M | 3.4B |
| Thousand | 1K | 1234.6K | 3400000K |
| Million | 0M | 1.2M | 3400M |
| Billion | 0B | 0B | 3.4B |
| Trillion | 0T | 0T | 0T |
Auto selects the unit from the size of the value: K for thousands, M for millions, B for billions and T for trillions. Values below one thousand are not abbreviated. But, like shortened values, they drop trailing zeros. The other options always use the unit that you select. Thus a value much smaller than that unit rounds down to 0.
NocoDB rounds shortened values to one decimal place. Shortened values still follow the separator style of the field. For example, with the Period and comma style, 1234.6K shows as 1.234,6K.
A field that shows shortened values also accepts them when you paste. If you paste 1.2M into a cell, NocoDB stores 1200000. You cannot type a suffix into a cell. If you do, the cell goes back to its stored value.
Cell display
The Number field shows as a numeric cell in the table. The cell is right-aligned to make it easy to read. Values show with the configured separator style.
Good to know
- Supported range (JavaScript): -9,007,199,254,740,991 to 9,007,199,254,740,991
Last updated on