Columns
Number
Use a Number column for quantities, money, percentages, durations, and star ratings. Choose a format, decimal places, and allowed range.
Deze pagina is nog niet vertaald. Je leest het origineel.
A Number column stores a number. Its format decides how the number is shown and edited, so the same column type covers plain quantities, money, percentages, durations, and star ratings.
When to use it#
Use Number for anything you count, measure, or add up: Quantity, Unit Price, Hours Worked, Discount, or Customer Rating.
Pick a different type when the number comes from somewhere else:
- Calculated from other columns on the same record, such as quantity times price: use a Formula.
- A sum, count, or average of linked records, such as an order total: use a Rollup.
- Written when a record is saved, based on a wider calculation: use a computation rule.
- A code that only looks like a number, such as a postcode or phone number: use Text or Phone.
Number Format#
| Format | Shows the number as |
|---|---|
| Default | A plain number. |
| Decimal | A number with decimal places. |
| Currency | An amount of money in the currency you choose. |
| Percentage | A percentage. Values are stored from 0 to 100 and shown with a % sign. |
| Duration | A length of time, in the unit and style you choose. |
| Rating (stars) | A row of stars. |
| Scientific | Scientific notation, for very large or very small values. |
Settings#
Which settings appear depends on the format.
| Setting | Appears for | What it does |
|---|---|---|
| Decimal Places | Default, Decimal, Currency, Percentage, Scientific | How many digits to show after the decimal point, from 0 to 10. |
| Currency | Currency | The currency the amounts are in, such as EUR, USD, or GBP. |
| Unit | Duration | The unit people type and the value is stored in: Seconds, Minutes, Hours, or Days. |
| Display format | Duration | How the duration is shown: Human-readable (1h 30m), Clock (HH:MM:SS), or Decimal (1.5 h). |
| Maximum stars | Rating (stars) | The size of the rating scale, from 1 to 10. The default is 5. |
| Minimum Value and Maximum Value | All formats except Rating | The lowest and highest value people can enter. |
Tips#
- Put the unit in the column name or the format, such as "Amount" with the Currency format in EUR, or "Time Spent" with the Duration format in hours.
- One Number column has one currency. If each record can be in a different currency, add a Single Select that uses the Currency codes (ISO 4217) standard list next to a Number column for the amount.
- Decide on decimal places early when you work with money or measurements, so totals and reports line up.
- A Number column can be converted to Text. See Change a column's type.
Discussies over deze pagina
Loop je vast of mis je iets? Vraag het de community.