Count Values on Different Rows

[Luca_Civa]

Hi, I’m fighting to find a solution to my problem, I’ve a table with a list of Volunteers (called “DATABASE”) and a “SERVICES” table where I put unique services and sign every Volunteer who partecipate to Service. Now I want to create another table that can automatically make a report of presences over a year, so I want to count how many time a Volunteer make a Service, in this simply case it would print:
123ABC - 1
456DEF - 2
789GHI - 2

Here an example:

How can I do it? I hope I was clear. Thanks!

[Kamille_Parks]

You could add a Count field to your your Database table

[Luca_Civa]

Sorry, but I don’t understand, I want to count everytime a Volunteer frome the tab Database compare in the tab Service and set up a sort of attandance tracker

[Kamille_Parks · Accepted solution]

Unless I’m misunderstanding you, this would be done using a Count field inside your Database “tab”.

Airtable Support

Count field overview

A count field lets you count the number of linked records in a record link column. To configure a count column, you simply choose the column with the linked records that you want to count.   FAQs ...

If you want the Count field to only count linked records from your Services table where the {Data} field is “this year” then you could add a condition to the field’s settings:

Airtable Support

Conditional counts, lookups, and rollups

Lookup, rollup, and count fields in a table use linked record fields to pull in values from one table to another. By default, these fields will pull in all the linked records from the other table, ...

[Luca_Civa]

Oh yeah! Now I’ve understood, sorry for repeating the answer and thanks for your time. It’s my firts steps on AirTable and databases in general. Thank you again!

[ScottWorld]

@Luca_Civa If this is your first time with Airtable and databases in general, you might enjoy my free Airtable training course:

LinkedIn

Learning Airtable Online Class | LinkedIn Learning, formerly Lynda.com

Learn the basics of Airtable, a spreadsheet-database platform, including how to create tables, use different types of fields, leverage views, work with records, link tables, and more.