What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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.
Is there any way to create a sum (total) on a report?Asked by webmaster.ncpack825 on April 26, 2015 at 01:27 PM
Is there any way to create a sum (total) on a report? I use JotForm for event registration, and Number Attending is one of my fields, which I'd like to show the running total in an embedded report on my website. I've looked at all your Report templates, but can't seem to find one with a total calculation option. I've linked a report to a Google spreadsheet that allows me to calculate the total, but I'd rather have it in the JotForm report itself as not everyone has access to the spreadsheet.
Unfortunately, that is not possible.
You could accomplish this with the API by getting all submissions of your form and sum up the values entered in the "Number of Attendees" field to show the results in a web page. But, this would require some knowledge of web programming.
If you have further questions, please let us know.