Skip to main content
A Number field stores values that can be calculated, such as prices, inventory, quantities, scores, and ratios. It supports number, currency, and percentage formats, and can show values as bars, rings, or lines.

​
Use Cases

​
Create and Configure

1

Choose the field type

Click the + on the right side of the table header, then choose Number from the field type list.
2

Name the field

Enter a field name, such as “Product Price”, “Inventory”, or “Achievement Rate”.
3

Choose the number format

Choose Number, Currency, or Percentage based on the data.
4

Set precision and default value

Set decimal places, and add a default value for new records if needed.

​
Number Formats

Precision controls how many decimal places are shown. After precision is set, Teable rounds displayed values to that precision.

​
Display Settings

Number fields can show values visually in addition to plain text. For Bar and Ring display, you can set a target value, color, and whether to show the number. The target value is the value that fills the visual display. For example, if the full score is 100, set the target value to 100.

​
Common Uses

  • Contract amounts: Create a “Contract Amount” field, choose Currency, select $, and set precision to 2 decimal places.
  • Sales achievement rate: Create an “Achievement Rate” field, choose Percentage, set display mode to Bar, and set the target value to 1.
  • Inventory management: Create an “Inventory” field, choose Number, then use it for sorting, filtering, and summaries.

​
Notes

  • Number fields only accept integers and decimals, such as 12 and 3.14.
  • Percentages are stored as decimals. Entering 100% stores 1; entering 50% stores 0.5.
  • If Formula, Rollup, or Lookup results are numeric, they can use Number field formatting and display modes.
Last modified on May 26, 2026