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

    Google Spreadsheet integration is creating a new spreadsheet for every new submission

    Asked by bhanukaran on September 02, 2013 at 07:00 AM

    Hi team,

    I am using your google spread-sheet integration. I see everytime in creates a new sheet to the entry. Can we have all the entries to be generated in the 1 spreadsheet instead of multiple spreadsheets.

    Please do let us know as soon as possible.

    Thanks

    Bhanu

    thanks
  • Profile Image

    Answered by EliezerN on September 02, 2013 at 10:02 AM

    Thanks for contcting us.

    I have made some test with one of my form using the integration, however I wasn't able to reproduce the issue:

    As you can see I sent many submission and all of them are in the same spreadsheet and that the way it should work. Have you already tried to re-build the integration? If not, I would recommend you to do it. Also, we would appreciate if you share with us the link of the form you are having troubles with.

    Kindly try re-building the integration and if that doesn't work, let u sknow so that we can further assistance.

    Thanks.

  • Profile Image

    Answered by EliezerN on September 02, 2013 at 10:05 AM

    Additionaly you can test my form and see the result of the integration:

    My form URL: http://www.jotform.com/form/32438537756868

    My Spreadsheet URL: https://docs.google.com/spreadsheet/ccc?key=0AiqEPKFwsdaPdG5ldTNrUDItejc3MUwyR1NrYXA1aGc&usp=sharing

    It's a pleasure to assist you.

    Thanks

  • Profile Image

    Answered by bhanukaran on September 02, 2013 at 12:15 PM

    Hi Team,

    Thanks for the response. But i have figured out what the problem was. Actually by default the spreadsheet is set to only 20 rows. The moment it exceeds 20 entries it creates a new spreadsheet.

    I have increase the number of rows to 5000 and all the entries are coming in the same spread-sheet.

    Thanks Again

    Bhanu

  • Profile Image
    JotForm Support

    Answered by KadeJM on September 02, 2013 at 01:45 PM

    Hi Bhanu, Thank You for bringing this to our attention. I've investigated this problem further and realized that it seems to be working as it should during my tests where it went past 10 Rows. Every entry after the limit on the Spreadsheet that was received when submitted was creating a new row as it should so my suggestion would be to connect them and not to change the row amount by leaving it as-is so that it works to build a list of your submissions one by one as they are recieved. I think that there is a chance that when you made this change it probably is the reason why this might've become a problem with the integration thus forcing you to expand the rows several more times just to allow more entries to show up on your spreadsheet.

    You can see what I mean with this Simple Test Form below. Note that the Associated Spreadsheet doesn't show any further entries but when you use the test form it will display them as they are recieved. I did not add more rows.

    http://form.jotform.co/form/32445056117853

    Spreadsheet:

    https://docs.google.com/spreadsheet/ccc?key=0AoQfICZ3OH3ldGx0MWRMcm44LUFhdlhuMDU5VTdEclE&usp=sharing

     

  • Profile Image

    Answered by bhanukaran on September 02, 2013 at 03:05 PM

    Oh. Perfect if that was logic on which it was suppose to function ;) Meanwhile, i will continue using the form without adding too many rows now.

    But, initially, it did not work the way it should have. Ideally, whenever i use to add a new entry it used to add a new spreadsheet with the old entries + the new entry :) surprisingly.

    I will check that again and let you know.

    Thanks

    Bhanu