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.
Exporting data from complex formsAsked by nextstepdublin on February 14, 2017 at 11:54 AM
I use online several online forms to screen patients for trauma, dissociation and other mental health issues. I then print out the results from Jotform and manually enter the data into a scoring sheet. Many of the responses are then divided into various factors, added up and then averaged. A lot of room for error as well as time consuming.
I have attached an example of a scoring sheet.
Can you advise how I might make a spreadsheet template and then automatically export data from form so all calculations are done and I end up with total and averaged scores
It is not possible to create spreadsheet template inisde of JotForm, but you can download your submissions in Excel and then you can customize your Excel document.
If you want to perform calculation inside of your Excel this articles may help you:
We also have other type of reports: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm
Just to mention that you can also perform calculation inside of your form:
Hope this will help. Let us know if you need further assistance.