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

    Spread2Jot app: Form is created with multiple submissions although the form was never used - CASE CLOSED

    Asked by AA_C on May 18, 2016 at 12:52 PM

    When checking into this app fine out why it creates blank submissions. I had 31 and never used it.

  • Profile Image
    JotForm Support

    Answered by Boris on May 18, 2016 at 01:04 PM

    The creation of 31 submission within the imported form happened because the spreadsheet that was imported had data filled up to its row 32 (row 1 contained the headings, so row 2 was the first submission, and row 32 was the 31st submission):

    If you want to import a form without any submissions, please make sure that the spreadsheet you are importing contains nothing on any other row, except for the headings in the very first row of the spreadsheet.

    For example, when importing a sheet that has two rows, the first one will be considered a heading (for creation of fields), and the second row will be imported as 1 submission:

    And upon importing it to your forms, the app will clearly state how many submissions it imported from the sheet:

    If you need further assistance, please let us know. Thank you.

  • Profile Image

    Answered by AA_C on May 18, 2016 at 05:47 PM

    Thank you for the good explanation, I will try it out and see how it works that way.

    Regards,

    Robert

  • Profile Image

    Answered by AA_C on May 18, 2016 at 06:00 PM

    Here is a form created with Excel very similar to the one you looked at. So it appears that only one line forms can work not these.

     

    Regards,

    Robert

  • Profile Image

    Answered by AA_C on May 18, 2016 at 07:13 PM

    One other thing of note, the "Data" you saw was not actually data but field descriptors. All the information is actually one "form" with no data.

    Robert

  • Profile Image
    JotForm Support

    Answered by Chriistian on May 18, 2016 at 10:40 PM

    You are correct that one line forms can work for the spread2jot app. Seeing your image, I can see that the app may encounter issues when reading the rest of the data of your file since some rows also have multiple rows within them. This could cause the form to experience blank submissions or have 31 submissions that are never used as you have encountered. For the app to work properly, the headings that will count as the fields will need to be in a single row, since any row after that will be treated as submissions.

    Please let us know if you need further assistance.

  • Profile Image

    Answered by AA_C on May 19, 2016 at 08:51 PM

    Thank you,

    Robert