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

    Google Spreadsheet Integration issue

    Asked by opxladmin on June 17, 2015 at 02:58 AM
    Second, 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?
  • Profile Image
    JotForm Support

    Answered by Welvin 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.