- opxladminAsked on June 17, 2015 at 02:58 AMSecond, we understand that there is an know issue with integration with Google Spreadsheet and this connectivity breaks now and then. Our problem is that if we re-integrate, we create a new spreadsheet and this breaks any 3rd-party connectivity to the spreadsheet we have as well as any charts and graphs and formulas we created analyzing the data. Could you please comment on this issue and is there any way to overwrite the original spreadsheet without deleting any of the formulas and charts and additional worksheets we have developed in the workbook?
- JotForm SupportWelvinAnswered on June 17, 2015 at 04:16 AM
Yes, we have some issues with the integration before, but our developers are doing their best and working hard to have a stable integration. So far, we don't have any reports with Google Spreadsheet integration since the last update. However, if you are not sure then the best option would be to use IMPORTRANGE function. This way, you will just get the spreadsheet ID and change it in the script.
Also, we do not recommend doing any modifications in the integration sheet, especially the first row which is the field labels. If you want to add a chart, do it in the new spreadsheet and again, use import range to connect the data from the form.
Please contact us again if we can help in any way.