JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Calculate totals after submissionAsked by jcrowe on August 10, 2016 at 10:23 AM
I have a form that I'm that record amount of money raised and location it was raised in. This form will be used across our company. We would like to easily be able to calculate the total amount of money raised at each location. I know we can do this in Excel, but I was really hoping Jotforms had something pre-built to do this.
In researching, I came across this forum post...
Is this still accurate?
If not, how do l calculate the totals, from all reports?
If so, is there any talk of amping up the visual reports so they could calculate these totals?
Unfortunately, it is not possible to total all total values in your submission using the form builder or the current features that we have. But, there are a number of ways on how you can manage the data.
Aside from the reports that you may already know that is mentioned in this guide: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm. We have other app integrations that may help you further. One of the famous app integration that we have is the Google Spreadsheet integration, that allows you to have a real-time list of your submissions in a spreadsheet, from there you can easily refer to the columns or cell, apply a formula or filter to sort the sum of each submissions' total value per location.
You can also check the other app integrations that we have related to this data management/analytics: https://apps.jotform.com/category/analytics_and_reporting
If you are familiar with programming and developing via API, then you can also use JotForm's API to simply fetch information from your submissions and create your own data analytics page. You can check our API documentation here: http://api.jotform.com/
I hope that helps.