Can I get a running total from my forms?

Hi.

My client (a New Zealand not-for-profit) receives regular reports through an online form (not jotform) from a group of mentors who spend personal time each month doing activities with needy kids.

The form collects information after each activity, including the number of hours with the child.

Could a jotform be set up so that at the end of the year each mentor's total mentoring hours could be added up / shown automatically?

Thanks

Len McGrane

Unfortunately, it is not possible to automatically perform a calculation inside of the reports. The calculations can be performed only inside of a form.

How to Perform Form Calculation Using a Widget

However, you can filter your submissions for a specific mentor in the specified time frame, download submissions to an Excel file and perform a calculation there. 

How to Search a Submission from the Submissions Page

How to Download Form Submissions as Excel/CSV/PDF

I would suggest you to create a Free account and test our forms. You can use this link to sign up  - https://www.jotform.com/signup/ 

The following guides can help you to create a form:

User Guide

How to Create Your First Web Form

We also offer a 50% discount for non-profits. You can apply for a non-profit discount here - https://www.jotform.com/nonprofit/pricing/ 

Thank you very much. Very helpful.
Len
...