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 spreadsheet has stoped downloading my product informatin

    Asked by akt1 on January 24, 2016 at 10:08 PM

    My integrated google spreadsheet has stopped downloading my product information even though it appears in a table report everything else updates

    product downloading table table report integrated
  • Profile Image
    JotForm Support

    Answered by Charlie on January 25, 2016 at 08:17 AM

    Apologies for the inconvenience. May I know if you have made changes on the spreadsheet like changing the column names? That will probably make the integration stop updating the spreadsheet.

    To resolve it, you can easily remove the integration and re-integrate it again.

    Re-integrating will automatically load all existing submissions of your form on the new spreadsheet. Let us know if that helps.

  • Profile Image

    Answered by akt1 on January 25, 2016 at 11:52 AM

    No I have not changed anything, can I integrate into the same sheet I use Pivot Reports using that data

    I did notice after one submission Google had created a new sheet and I had to restore an older version to restore my reports 

  • Profile Image
    JotForm Support

    Answered by Charlie on January 25, 2016 at 01:01 PM

    Apologies for the inconvenience. I am not sure what are the exact factors or causes for the integration to break. Our developers mentioned that when you edit the columns the submission data specific to it will stop, there are also times as to where the integration breaks when refresh token is refused by Google.

    So far the only way to fix the integration is to re-integrate it. I would strongly suggest that you have a master spreadsheet to where you can just use a formula to reference the values from the integrated spreadsheet. You can use "IMPORTDATA" to reference values from a spreadsheet. Here's an article that might help: https://support.google.com/docs/answer/3093335?hl=en. That allows you to make any changes on the master spreadsheet, like adding reports, charts, and the likes without doing anything on the integrated spreadsheet. 

    I can also forward this problem to our developers, but could you please provide us additional information that might help them investigate further? Example is the Google Spreadsheet link, it would be best to share us the public link. Don't worry, the thread is private and we do not share private information to anyone. The data is yours only. 

  • Profile Image

    Answered by akt1 on January 25, 2016 at 03:41 PM

     "So far the only way to fix the integration is to re-integrate it. I would strongly suggest that you have a master spreadsheet to where you can just use a formula to reference the values from the integrated spreadsheet"

    I have came to the same conclusion, the Google "IMPORTRANGE" feature looked the perfect solution to link 2 google spreadsheets but i was unable to get it to work until I tried this fix in the last message

     

    please make this public

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on January 25, 2016 at 09:34 PM

    Thank you very much for sharing such workaround with us, we have made this forum post public so others can read the thread and find out the solution.