- akt1Asked 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
- CharlieAnswered 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.
- akt1Answered 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
- CharlieAnswered 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.
- akt1Answered 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
- JotForm Support ManagerJeanetteAnswered 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.