Number fields
Number fields store values you count, measure, price, or score. All five sort numerically, filter
with = ≠ > ≥ < ≤, and can feed Formula and
Rollup calculations.
Number
Whole numbers (integers).
- Stores: an integer.
- Use for: counts, quantities, sort order, IDs that are numeric.
Decimal number
Numbers with decimal places.
- Stores: a decimal value.
- Use for: weights, rates, measurements — anything fractional.
- Number vs. Decimal number: use Number when the value is always whole; Decimal number when fractions matter.
Money
An amount together with a currency.
- Stores: amount + currency (the currency is set on the field).
- Behaves: formatted automatically with the currency symbol. Changing the field's currency does not re-convert existing amounts — it only changes how they're displayed.
- Use for: prices, budgets, totals.
Percentages
A percentage value, shown with a %.
- Stores: a number displayed as a percentage.
- Option — clamp to 0–100: when enabled, values outside 0–100 are rejected (ideal for progress or completion); leave it off for values that can exceed 100 (e.g. growth).
- Use for: discounts, VAT, completion, margins.
Rating
A score on a star scale.
- Stores: a rating value.
- Behaves: shown as stars; click to set.
- Use for: lead scoring, product or supplier ratings, quick prioritization.
