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.

  • Verified Nov 17, 2026
  • Classic builder

On this page
  1. Which type to use
  2. Add a number field
  3. Number
  4. Currency
  5. Rating
  6. Slider

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 #

TypeWhat it storesUse it for
NumberA number, with or without decimalsQuantities, scores, hours, measurements
CurrencyA number shown with a currency symbolPrices, costs, totals
RatingA number shown as a row of icons, such as starsReviews, priorities, satisfaction scores
SliderA number picked by dragging a slider between a minimum and a maximumProgress, 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), and calculated numbers such as Number Formula, Equation and Rollup are in the Equation group (see Equation fields).

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

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

Number #

SettingWhat it does
Decimal PlacesHow many digits are kept after the decimal point: None, 0 to 5, or 10. The default is None, which stores whole numbers.
Thousands DelimiterThe character that separates groups of thousands when a value is displayed: None (default), Comma, Period or Space.
Disable RoundingOff 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 UniqueWhen on, two records in the table cannot hold the same value.
Default Record ValueSaved 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 ValueThe value already filled in when a form with this field loads in the live app.

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.

SettingWhat it does
Currency TypeThe currency symbol. New fields start with US dollars. Pick another currency from the list, or choose Custom and type your own symbol.
FormatWhere the symbol goes: Prefix (before the amount, the default), Suffix (after it) or None (no symbol).
Decimal PlacesStarts at 2 for Currency fields.
The settings of a Currency field, with Currency Type, Format, Decimal Places and Thousands Delimiter

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.

SettingWhat it does
Number of StarHow many icons the scale has: 3, 4, 5 (default) or 10.
Enable ResetOn by default. Shows a control on forms that clears the rating.
Default IconA filled or outlined star, heart, thumbs-up or flag. Choose Custom to pick any icon in Custom Icon.
Default Icon ColorThe color of the selected icons. Black unless you pick another color.
Conditional Icon ColorClick 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.

SettingWhat it does
Minimum ValueThe number at the left end of the slider. New fields start at 0.
Maximum ValueThe number at the right end of the slider. New fields start at 100.
Default Form ValueWhere the slider sits when a form loads. Leave it empty to start with no value.

Was this page helpful?

Something wrong or missing on this page? Tell us.