The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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.