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.


  • Profile Image

    Exporting data from complex forms

    Asked 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

    Thanks

    Page URL:
    https://form.jotformeu.com/60803704067351

    Screenshot
  • Profile Image
    JotForm Support

    Answered by BJoanna on February 14, 2017 at 02:03 PM

    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.

    How to Export Form Data to Excel 

    If you want to perform calculation inside of your Excel this articles may help you:

    https://support.office.com/en-us/article/Use-Excel-as-your-calculator-a1abc057-ed11-443a-a635-68216555ad0a 

    https://support.office.com/en-us/article/Overview-of-formulas-in-Excel-ecfdc708-9162-49e8-b993-c311f47ca173 

    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:

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

    Hope this will help. Let us know if you need further assistance.