Contents x
    Number-based fields in Airtable
    • 30 Oct 2023
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Number-based fields in Airtable

    • Updated on 30 Oct 2023
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    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 availabilityAll 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. 

    NOTE 
    Autonumber fields are not designed to count the number of records in a table. When a record is deleted, the remaining records are not re-numbered—leaving gaps in the numbering. To re-number an autonumber field, either delete and re-create an autonumber field or convert it to a different field type and then revert it to an autonumber field.

    Check out our Airtable Community for more info and suggestions for conditional auto-numbering.
    Adding autonumber fields
    1. Visit your Airtable homepage. 
    2. Create or open your preferred base.
    3. Add or edit a field.
    4. 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.

    NOTE 
    Airtable doesn't support using multiple currencies within the same currency field.
    Adding curency fields
    1. Visit your Airtable homepage. 
    2. Create or open your preferred base.
    3. Add or edit a field.
    4. Search for and select Currency, then create Create field. 
      1. You can optionally update the default settings by clicking Formatting.
      2. 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%.  

    NOTE 
    For a more general-purpose numeric field type, try a number field to represent integers or decimals.

    Percent fields created before May 2019 were stored using a format are now converted to number fields. Read more about this change in the number legacy section of the Number field type article.

    Adding percent fields
    1. Visit your Airtable homepage. 
    2. Create or open your preferred base. 
    3. Add or edit a field.
    4. 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

    Adding number fields
    1. Visit your Airtable homepage. 
    2. Create or open your preferred base. 
    3. Add or edit a field. 
    4. Search for and select Number, then click Create field.
      1. 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. 

    NOTE 
    Users on Airtable Pro plans can update the style of the field's rating symbol from the default yellow star.
    Adding ratings fields
    1. Visit your Airtable homepage. 
    2. Create or open your preferred base. 
    3. Add or edit a field. 
    4. Search for and select Rating, then click Create field.
    NOTE 
    Hover your cursor over a record in a rating field to show the maximum number of symbols in gray. To give or change a rating, click the appropriate number of symbols.

    Formatting number-based fields

    To access formatting options in number-based fields:

    1. Click the ⌄ icon next to the name of the number-based field you want to format.
    2. Then, click Edit field.
    3. Next, click on the Formatting tab.
      1. From the formatting tab, you have a variety of options to choose from: Format, Presets, Decimal places, Thousands and decimal separators, the option to toggle whether to Show thousands separators, and Large number abbreviation.
    4. After configuring the format of the field, you'll see the option to "Preview" the output at the bottom of the field configuration window.
    Was this article helpful?
    What's Next