Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 28, 2022 07:44 AM
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!
Solved! Go to Solution.
Mar 28, 2022 02:31 PM
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:
Mar 28, 2022 10:20 AM
You could add a Count field to your your Database table
Mar 28, 2022 02:04 PM
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
Mar 28, 2022 02:31 PM
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:
Mar 28, 2022 03:27 PM
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!
Mar 28, 2022 05:21 PM
@Luca_Civa If this is your first time with Airtable and databases in general, you might enjoy my free Airtable training course: