Dec 18, 2018 11:42 AM
Hello! I am super new to understanding Airtable & I am having trouble finding how it can work for a nonprofit. I am attempting to create a volunteer time tracker. Our current system is through volunteers submitting a google form that then goes into a google sheet that will tabulate up all of the total time volunteered (from the start & end time of their shift). There are then columns in this sheet that find the total hours volunteered in total in the office.
I want to do something like this with Airtable. I have made a sheet that asks for all of the correct information. However, I am having a hard time figuring out how to 1. tabulate the hours/minutes of each person (like by the name entry), 2. the total hours/minutes entered in all & 3. by volunteer type (this is also field/question on the airtable form I made).
Please let me know how I could implement this kind of format on Airtable. Thanks in advance!
Dec 18, 2018 12:20 PM
You need two tables in one base: Table 1: Volunteers and Table 2: Time Log. Set your tables up something like the following:
[Time Log] Table:
DATETIME_DIFF({End Time},{Start Time},"minutes")
. If you want this in decimal hours add / 60
to the end of that formulaMake a form view for the [Time Log] table with all those fields included except for {Duration}, which is automatically calculated by formula and thus doesn’t need user input
[Volunteers] Table:
SUM(values)
aggregation. This field will show you the total number hours that particular volunteer has ever logged.Then you can group records in the [Volunteers] table to view the total sum of hours volunteered for each volunteer, and by volunteer type using the summary bar.
Dec 18, 2018 12:22 PM
for clarification, if the volunteer type is not a trait of the individual (i.e. regular volunteer, seasonal volunteer) and instead changes per event (i.e. church event, school event, work event), you will need the {Type} field in the [Time Log] table.