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 to make changes to the way information aggregates in the spreadsheet

    Asked by Rodneyna on November 03, 2015 at 04:38 PM

    I am gathering information for labels for artwork, this means repetition of the same fields on different pages. I would like each page break to submit on it's one line in the spreadsheet so that all the titles, media, price... stack up below each other rather than one long spreadsheet with 20 labels worth of duplicate information.

     

    information Make in make changes
  • Profile Image
    JotForm Support

    Answered by Chriistian on November 03, 2015 at 09:52 PM

    Hi,

     

    Are you referring to the Google Spreadsheet integration? Unfortunately, this is currently not possible. New rows in the spreadsheet means new submissions of the of the form. As a workaround, you can try the following steps:

    1. Remove other labels in your form, just retain one Label fields.

    2. Set Thank You custom URL to the form itself with prepopulated value for the First Name field.

    Example:

    http://www.jotform.us/form/53015841040139?fullName[first]={fullName:first}&fullName[last]={fullName:last}

     

    That way, new row will be created to your integrated Google Spreadsheet.

     

    You can check this form that I have created - http://form.jotformpro.com/form/53068651503958. You can clone the form to have a closer look on the setup.

     

    Do let us know if you need further assistance.
    Regards.