# Number, Currency, Rating and Slider fields

> Store quantities, money, star ratings and slider values, and set decimal places, thousands separators, currency symbols, rating icons and slider ranges.

Source: https://tadabase.com/docs/data/number-fields  
Status: Verified Nov 17, 2026. Checked against the current product

Number fields hold values you count, compare or calculate with. The **Number** group of the field menu has four types: **Number**, **Currency**, **Rating** and **Slider**. This page covers when to use each one and every setting it has.

## Which type to use

| Type | What it stores | Use it for |
| --- | --- | --- |
| **Number** | A number, with or without decimals | Quantities, scores, hours, measurements |
| **Currency** | A number shown with a currency symbol | Prices, costs, totals |
| **Rating** | A number shown as a row of icons, such as stars | Reviews, priorities, satisfaction scores |
| **Slider** | A number picked by dragging a slider between a minimum and a maximum | Progress, percentages, quick scores |

Numbers that are worked out for you are in other places: every table already has a built-in record number (see [Auto Increment field](https://tadabase.com/docs/data/auto-increment)), and calculated numbers such as **Number Formula**, **Equation** and **Rollup** are in the **Equation** group (see [Equation fields](https://tadabase.com/docs/data/equation)).

## Add a number field

1. **Open the table** In the **Data Builder**, open the table and go to its **Fields** tab.
2. **Open the field menu** Click **Add New Field**. The **Add Field** window lists every field type by group.
3. **Pick the type** Under **Number**, click **Number**, **Currency**, **Rating** or **Slider**. The right side shows a short description and a preview of the field on a form.
4. **Configure it** Click **Add and Configure**, enter a **Name**, set the options described below, and click **Save**.

![The Add Field window in the Data Builder, with field types grouped by kind and a preview of the selected Currency field](https://tadabase.com/docs-shots/data-add-field-menu.webp)

Every field also has a **Description**. It is for your own notes and app users never see it.

## Number

| Setting | What it does |
| --- | --- |
| **Decimal Places** | How many digits are kept after the decimal point: **None**, 0 to 5, or 10. The default is **None**, which stores whole numbers. |
| **Thousands Delimiter** | The character that separates groups of thousands when a value is displayed: **None** (default), **Comma**, **Period** or **Space**. |
| **Disable Rounding** | Off by default, so values are rounded to the number of decimal places. Turn it on to keep the full value for storage and calculations; the display is then cut to **Decimal Places** instead of rounded. |
| **Must be Unique** | When on, two records in the table cannot hold the same value. |
| **Default Record Value** | Saved when a new record is created with this field left blank. Tick **Update existing blank values?** to also fill records that are blank today. |
| **Default Form Value** | The value already filled in when a form with this field loads in the live app. |

> **Decimals are rounded away by default:** With **Decimal Places** set to **None** or 0, a value typed as `2.5` is saved as a whole number. If you need decimals, set **Decimal Places** before people start entering data.

## Currency

A Currency field has the same **Decimal Places**, **Thousands Delimiter**, **Disable Rounding**, **Default Record Value** and **Default Form Value** settings as a Number field, plus two of its own. **Must be Unique** is not offered on Currency fields.

| Setting | What it does |
| --- | --- |
| **Currency Type** | The currency symbol. New fields start with US dollars. Pick another currency from the list, or choose **Custom** and type your own symbol. |
| **Format** | Where the symbol goes: **Prefix** (before the amount, the default), **Suffix** (after it) or **None** (no symbol). |
| **Decimal Places** | Starts at 2 for Currency fields. |

![The settings of a Currency field, with Currency Type, Format, Decimal Places and Thousands Delimiter](https://tadabase.com/docs-shots/data-currency-field-settings.webp)

## Rating

A Rating field lets people click icons to give a score, for example 4 out of 5 stars. The value is saved as a number.

| Setting | What it does |
| --- | --- |
| **Number of Star** | How many icons the scale has: 3, 4, 5 (default) or 10. |
| **Enable Reset** | On by default. Shows a control on forms that clears the rating. |
| **Default Icon** | A filled or outlined star, heart, thumbs-up or flag. Choose **Custom** to pick any icon in **Custom Icon**. |
| **Default Icon Color** | The color of the selected icons. Black unless you pick another color. |
| **Conditional Icon Color** | Click **Add New** to change the color and icon when the rating is **equal to**, **not equal to**, **higher than** or **lower than** a number. For example, show red icons when the rating is lower than 3. |

Rating fields have no default value settings.

## Slider

A Slider field shows a slider on forms. People drag it to pick a number between the two ends.

| Setting | What it does |
| --- | --- |
| **Minimum Value** | The number at the left end of the slider. New fields start at 0. |
| **Maximum Value** | The number at the right end of the slider. New fields start at 100. |
| **Default Form Value** | Where the slider sits when a form loads. Leave it empty to start with no value. |
