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.


  • Profile Image

    How can I create a submission answer report that will separate the questions asked in the appointment slots widget on a form?

    Asked by michellebarncord on March 30, 2016 at 12:51 PM

    Hello!

    I use the appointment slot widget as a volunteer sign up form.  I need to separate the questions on the submissions report.  Right now the report shows all of the questions asked or filled out from the widget in a single column.  Is there a way to separate them so I can easily view who has signed up for each position?  The next problem would then be if someone signed up for multiple positions.  Ideally it would be great to have the name of the person signed up under each question.  example:

     

    check-in             bookstore         dinner set-up           

    Mary                  Dave                Mary

    Lisa                   Tom                 Jenny

                                                   Sherri

                                                    Dan

     

    Anyway to work this?  Thanks for your time and help!

     

    Michelle

    Page URL:
    https://form.jotform.com/60697661528164

    create appointment appointment slots slots
  • Profile Image
    JotForm Support

    Answered by BJoanna on March 30, 2016 at 02:58 PM

    You can create excel report of your submission. Then your data for each submission will be shown in columns. 

    I have cloned your form and made few test submissions. Then I have created Excel report. My Excel report looks like this.

    Inside of this guide you can find how to export form data to Excel:

    http://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel 

    Hope this will help. Let us know if you need further assistance. 

  • Profile Image

    Answered by michellebarncord on March 30, 2016 at 03:56 PM

    Thanks for the answer, but its not really what I'm looking for.  In the excel export each submission is its own row.  If there is more than one check or answer in the same submission it is showing up in the same column "please click here to sign up for available volunteer positions".

    I would like to break apart each of the questions into its own column as each question like first name, last name, email and phone number is its own column.  So I can see who signed up for each question.

  • Profile Image
    JotForm Support

    Answered by Kiran on March 30, 2016 at 06:36 PM

    Unfortunately, we do not have built-in feature to achieve this. However, you may export the submissions data to Excel and have the data separated to columns. Since the data of Appointment Slots widget is having one entry per line i.e., separated by Enter Key, we can use this as a delimiter to separate the data to columns. Please see the screencast below:

    Please check the following guide that might help you in separating the data to columns.

    http://datapigtechnologies.com/blog/index.php/split-data-into-several-columns-based-on-carriage-returns/

    Hope this information helps! If you need any further assistance, please let us know. We will be happy to help.