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

    My Google Sheet integration is not updating

    Asked by CEOGlobal on April 16, 2016 at 08:31 PM

    I cannot see a reason why my Google Sheet integration is NOT updating the sheet when new registrations come in.  I hope you can advise me about this.  Thank you.

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

    google spreadsheet import range spreadsheet reintegrate
  • Profile Image
    JotForm Support

    Answered by EltonCris on April 17, 2016 at 04:09 AM

    Google Integration seems working just fine when I tried it on my form just now. Would you please try to re-integrate your form to Google Spreadsheet? See if that makes a difference.

    Let us know if the problem persists so we can further investigate this. Thank you!

  • Profile Image

    Answered by CEOGlobal on April 17, 2016 at 05:12 PM

    If I do the 're-integration' you mentioned what happens to my existing spreadsheet?  I would rather not lose the calculations I have made in the spreadsheet.

    The current google spreadsheet definitely is not accepting new data.

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by EltonCris on April 17, 2016 at 06:11 PM

    Unfortunately, recreating the integration would create a new spreadsheet file. There's no way to retain the old spreadsheet file. However, you can use Google's Import Range function so you can transfer spreadsheet data from one spreadsheet to another.

    You can find more information here. https://support.google.com/docs/answer/3093340?hl=en&rd=1

    By the way, since you mentioned that you have calculations in your current spreadsheet file, this leads me to think that you made changes on the integrated spreadsheet file? Take note that making any changes on the integrated spreadsheet file will most likely break the integration. This is also one of the reasons why spreadsheets stop syncing the new submissions.

  • Profile Image

    Answered by CEOGlobal on April 17, 2016 at 06:46 PM

    well, this is bad.  Apparently the integration writes a totally new copy of the worksheet.  The calculations I did on a second tab did not break the integration.  However, after adding test data the worksheet now has no second tab, on which I had made my calculations.

    Is my conclusion correct?  is there any way to avoid this?  I will look at the range import link you sent me, but if the integration overwrites the entire sheet there will be no place from which to actually import and ranges?

    Just hoping a solution.  Thanks.

  • Profile Image
    JotForm Support

    Answered by BDAVID on April 17, 2016 at 07:25 PM

    Basically, by reintegrate with Google Spreadsheet, a new spreadsheet is generated. If you need to apply calculation, don't do it in the integrated spreadsheet.

    Simply automatically pull data from the integrated spreadsheet to a new spreadsheet by using IMPORTRANGE, and then apply calculation and customize the new one as you want to.