Count field overview

Creating count fields in Airtable

NOTE

Your base's table must have a linked record field before creating a count field.

To create a count field:

1. Open your Airtable home screen.

2. Open the base and table where you want to add a count field.

3. Click the + button next to the field furthest to the right in your view.

   1. Alternatively, you can click the dropdown next to the name of an existing field and insert the next field by clicking ← Insert left or → Insert right.

4. Search for “Count” or scroll down to the Count option and click it.

5. Name the new field.

6. Click Choose a field in this table, then select your preferred linked record field.

7. Click Create field.

No available sources error in count fields

During the setup process, you may see “No available sources to count. Add a count source, then try to configure your count again.” This means that the table you are working in does not contain any linked record fields currently. You’ll need to exit the count field configuration process and add a linked record field first.

Note

If you are looking to count data held in other field types, then you will likely need to create a custom formula field. Customers using Airtable AI can try asking Omni to help you build a formula field to perform the calculation you are wanting.

FAQs