How can I tally the selections made by users in my form and display them into separate columns in Excel?

  • cf013
    Asked on November 1, 2018 at 3:59 PM
    Now I am working on a multiple choice selection where each choice number value needs to go in a different column.

    1541099964multiple choice Screenshot 10

    No Children Attending = 0

    Tea Sprouts Preschool = 1   

    Frontier Elementary = 2       and so on....


    so it ends up like this:

  • Support_Management Jotform Support
    Replied on November 1, 2018 at 4:21 PM

    I'm assuming you're exporting your submission data to Excel. Sadly, what you're describing is not doable. Each field you add to your form are treated as a single column in your submissions page. This in turn will also cause all exports, reports and integrations (e.g. with Google Sheets) treat that field as a single column too.

    I'm not sure what kind of results you want but maybe the JotPoll App is something that you can explore. This gives you a visual presentation of your data, which should work well with survey forms that use SINGLE CHOICE (radio button) fields.

  • cf013
    Replied on November 1, 2018 at 4:43 PM
    Thank you.
    Thank you,
    Chris Friedrich
    Note: This e-mail and any attachments may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of this e-mail and any attachments is strictly prohibited. If you have received this e-mail in error, please notify us immediately by returning it to the sender and deleting it from your computer system. Thank you for your cooperation.
    ...
  • cf013
    Replied on November 1, 2018 at 4:43 PM
    Thanks!!!! That works!!!!
    Thank you,
    Chris Friedrich
    Note: This e-mail and any attachments may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of this e-mail and any attachments is strictly prohibited. If you have received this e-mail in error, please notify us immediately by returning it to the sender and deleting it from your computer system. Thank you for your cooperation.
    ...