Count Values on Different Rows

Luca_Civa · ‎Mar 28, 2022

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 · ‎Mar 28, 2022

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

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:

See Solution in Thread

Kamille_Parks · ‎Mar 28, 2022

You could add a Count field to your your Database table

Luca_Civa · ‎Mar 28, 2022

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 · ‎Mar 28, 2022

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

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:

Luca_Civa · ‎Mar 28, 2022

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 · ‎Mar 28, 2022

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