Number

For instructions on how to access field types or how to add one, see Field Types.

Capabilities

• Store integer or decimal numeric values
• Use the value in Formula fields for calculations
• Filter and sort records by numeric value
• Reference the field in automations as a condition or output value
• Display quantities, counts, scores, ratings, and other numeric data

How to add a Number field

1. Open your table and click + to add a new field.
2. Select Number from the field type list.
3. Enter a name for the field.
4. Optionally mark the field as Required.
5. Click Create.

Use Cases and Examples

• In an "Inventory" table, a Number field can store the quantity of each product in stock.
• In a "Campaigns" table, it can track how many leads a campaign generated.
• In a "Projects" table, it can hold the number of active users or team members assigned.
• In a "Support" table, it can store the number of tickets opened or resolved per client.

Keep in Mind

• The Number field does not format values as currency or percentage — for those use cases, use the Currency or Percentage field types instead.
• Leaving the field empty is not the same as entering zero — empty values are treated as null in formulas and filters.

FAQ

1 — What is the difference between Number, Currency, and Percentage?

All three store numeric data, but they differ in formatting. Number stores a plain numeric value. Currency formats the value with a currency symbol. Percentage adds a "%" sign after the number. Use the field that matches how the value should be displayed.

2 — Can I use a Number field in a formula or automation?

Yes. Number field values can be used in Formula fields for arithmetic operations, and referenced in automations as conditions (e.g., "when quantity is less than 5") or as values to set in actions.