- 09 Oct 2024
- 2 Minutos para leer
- Impresión
- OscuroLigero
- PDF
Counting records in Airtable linked record fields
- Actualizado en 09 Oct 2024
- 2 Minutos para leer
- Impresión
- OscuroLigero
- PDF
All plan types | |
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading |
This article covers how to count records in linked record fields to streamline your team's and organization's work.
Using the count field in Airtable
Using the count field
NOTE
To count the number of linked records in a field, you can create another field using the "Count" field type. This will automatically provide the number of records that have been linked to a particular record in a designated field. For a basic overview of the count field type, see "Guide to Formula, Lookup, Count, and Rollup Fields."
Let's suppose that you have a table of team members, and a table of tasks that need to be completed. Using a linked record field, we can link employees to the tasks to which they've been assigned.
Once you've done this, you'd like to be able to see, at a glance, the number of tasks each employee has been assigned. To do this, create a new field with the count field type (you can title this new field "Tasks Assigned"). You will then be prompted to select name of the field on this table that holds the linked records you would like to count. In this case, the title of that field is "Tasks."
The new count type field you've created will automatically count the number of linked records in the designated field. If you add or remove linked records from the designated field, the count field will automatically update to reflect the new number of records.
Counting with rollup fields and formulas in Airtable
Counting with rollup fields and formulas
For an alternate method of counting linked records, add a rollup field and use the following formula in the rollup settings: COUNTALL(values)
This will count the linked records and allow you to build in other formula functions within the rollup field.
FAQs
Is there an Airtable formula to total the number of selected options in multiple select fields?
Airtable doesn't offer a formula to count the number of selected options. However, suppose you convert the multiple select field into a linked record field (via the "Create new table" option). In that case, you can then use a count field to return the number of selected linked records.
count field
You can also use the below formula workaround, but keep in mind that none of the multiple select field options can have embedded commas:
IF({YOUR MULTIPLE-SELECT FIELD NAME},LEN({YOUR MULTIPLE-SELECT FIELD NAME})-LEN(SUBSTITUTE({YOUR MULTIPLE-SELECT FIELD NAME},",",""))+1)
How many records are in my base?
To find the number of records in a base:
Open your Airtable account overview.
Select the workspace — hosting the base you're interested in — from the "Workspace settings" menu.
Scroll to the “Usage” section at the bottom of the page.
The “Usage” section details usage for automations, credits, records, and attachments for workspaces and bases.