Creating checklists that are easy for data analysis

  • leeanndumas
    Asked on April 20, 2016 at 9:13 AM

    We have several forms that the client selects from a list up to 13 choices. Since this is a government agency, the choices are not simple one word answers, but long compound sentences. 

    I have been writing the choices as each sentence as the "question" and the user checks yes or true. (See picture below) I had discovered that if I didn't do it this way, the whole sentence text was reported back in the spreadsheet cell. That makes for an overload of information on the spreadsheet and rather difficult to write formulas for analyzing the responses. 

     

    Is there a better way of doing this? I noticed on the properties that I could spread the responses over several columns. Could I do these questions as one checklist and spread the responses over columns. Is there anyway to have the data reported in the spreadsheet as TRUE, FALSE for check marks rather than the complete sentence?

     

     

    Jotform Thread 822728 Screenshot
  • Charlie
    Replied on April 20, 2016 at 10:47 AM

    Yes, the options in the check box are the ones being added in the cells of a spreadsheet. I believe you are already on the right path. Recreate each option as a question and ask users if they are "True" or "False". This gives you more flexibility on analyzing inputs on a spreadsheet if you're using formulas.

    However, you could try using the "Matrix" field, you can add the options in one matrix field then when you download it as an excel file, you can see that each option is separated on each column and cell. 

    Creating checklists that are easy for data analysis Image 1 Screenshot 20

     

    If you have a Google account, you can also integrate your form to Google Spreadsheet. Here's a guide about it: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet. That will automatically load all your submissions in the online spreadsheet and give you real-time results.

    I hope that helps.