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.
Creating checklists that are easy for data analysisAsked by leeanndumas on April 20, 2016 at 09: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?
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.
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.