Is there a way to have multiple answers to a question end up in separate field of excel report?

  • dennisjstone
    Asked on June 8, 2020 at 3:49 AM

    is there a way to have multiple answers to a question end up in separate cells in an excel report? e.g. which of the following are you interested in? a person choses three out of 5. could each one of these be in a separate cell for sorting purposes?

  • Ashwin JotForm Support
    Replied on June 8, 2020 at 7:21 AM

    Please note that answers of each question will be displayed in separate column of google spreadsheet or excel export. 

    There are two options available to achieve your requirement:

    #1. Add paragraph field to add question label. You can then add separate multiple choice question (without question label) for each option. Please check the screenshot below:

    1591614727selectAns Screenshot 10

    We can inject the custom CSS code to remove the blank space around the options and display them one below the other. 

    #2. You can add one multiple choice question and list all your options. You can then add separate hidden short text entry field for each option. When user select any option, you can populate it in the corresponding hidden short text entry field by taking advantage of condition feature. Please check the screenshot below:

    1591615158selectAns2 Screenshot 21

    Please take a look at the following demo form I created for you for both the options: https://form.jotform.com/201592207436048 

    Feel free to clone this form for a closer look. The following guide should help you in form cloning: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.

    Do get back to us if you have any questions.