JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
How can I create sections or categories for my questions, to be read in the output?Asked by Rebloom on February 25, 2016 at 04:38 AM
I have several forms with a series of questions in different categories, 'Fire' , 'Water', 'Electrical' etc. and these are currently separated by text headings. The responses are integrated in to a spreadsheet and I then intend to do some manipulation with them. My issue is that I or someone in the office sometimes change the questions and I need to know which category the question comes under without having to manually do it in the spreadsheet. Is there a way to add a 'category' to each question in jotform so that that the responses are easier to manipulate? Thanks Jack
Do you mean to have the category name for each question to be displayed in the spreadsheet? I don't think it is possible since the columns of the spreadsheet will be having the field labels. In this case, you'll need to have the category name to be set in the field label in order to identify the column name from which category.
Generally, if you can use Matrix field the submissions results on an excel sheet would be displaying the field name as the category name. But I see there are some additional fields on your form with conditions that might go complicated with your requirement. You may give a try using matrix field to see how it works.
Please get back to us if you need any further assistance. We will be happy to help.