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

ScenarioGood for
Amounts and costsContract amounts, product prices, budgets, costs
Quantities and inventoryStock counts, order quantities, work hours, counts
Ratios and progressAchievement rate, conversion rate, completion rate
Scores and metricsScores, weights, health scores, risk scores

​
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

FormatGood forExample
NumberCounts, quantities, scores100, 2.5
CurrencyAmounts, costs, budgets$100.00
PercentageRatios, progress, conversion rates50%
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.
Display modeGood forDescription
DefaultSingle-value and multi-value numbersShows the number directly
BarSingle-value and multi-value numbersUses bar length to show value size
RingSingle-value numbersUses a ring progress display to show proportion
LineMulti-value numbersUses a line to show changes across values
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