- 20 Sep 2023
- 2 Minutes to read
- Print
- DarkLight
Number-based fields in Airtable
- Updated on 20 Sep 2023
- 2 Minutes to read
- Print
- DarkLight
In Airtable, fields allow you to organize all the details for any record in your base, so they can easily be sorted, managed, and analyzed. In this article, learn specifically about Airtable's number-based fields and how to use then.
Introduction
Plan availability | All plan types |
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading | |
Airtable terminology | Field type - A field type specifies the kind or format of data stored in a given field — for example, long text, date, multiple select, or attachment. |
Autonumber fields
Autonumber fields automatically generate unique and incremented numbers for each record. Autonumbers can be helpful when you need a unique identifier for each record or when using a formula in the primary field.
- Visit your Airtable homepage.
- Create or open your preferred base.
- Add or edit a field.
- Search for and select Autonumber, then click Create field.

Currency fields
A currency field is a specific type of number field that formats the number as a currency amount. You can specify a currency symbol (the default symbol is $), the number of significant digits, and whether or not to allow negative currency amounts.
- Visit your Airtable homepage.
- Create or open your preferred base.
- Add or edit a field.
- Search for and select Currency, then create Create field.
- You can optionally update the default settings by clicking Formatting.
- Lastly, you can set a default field value for every new record created within the table by clicking Default and entering your preferred number.
Percent fields
The percentage field type hosts numerical values formatted as percentages. The values in a percent field are shown as fractions of 100 with the percent symbol. For example, .75 in a percent field is represented as 75%.
- Visit your Airtable homepage.
- Create or open your preferred base.
- Add or edit a field.
- Search for and select Percent, then click Create field.

Number fields
The number field type is a field type designed to hold numbers. The number field type is a general-purpose field type for most numerical values, like the number of chairs of a particular type your furniture business has in stock, or the distance from one city to another
- Visit your Airtable homepage.
- Create or open your preferred base.
- Add or edit a field.
- Search for and select Number, then click Create field.
- You can optionally update the default settings by clicking Formatting.

Rating fields
The rating field allows you to rate your records for the purposes of ranking or quality assessment.
- Visit your Airtable homepage.
- Create or open your preferred base.
- Add or edit a field.
- Search for and select Rating, then click Create field.
