JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
My google spreadsheet has stoped downloading my product informatinAsked 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
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.
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
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.
"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
JotForm Support Manager
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.