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

    I am using the Google Spreadsheet integration - if I add my own columns or sheets will jotform delete my added data?

    Asked by udotorgDiaz on February 03, 2015 at 06:10 PM

    So, I used jotform Google Spreadsheet integration and connected to a sheet in my Google account. I tested the form and entered test data. I saw the data show up on the sheet. Very cool. Then I just wanted to add my own extra columns to the spreadsheet that I did not want on the form. It seemed as though it left it alone, but when I came back later, my extra columns were gone while the jotform field generated columns were still there.

    Can you confirm what jotform does - I mean if it will delete my custom data I put in the sheet, then I won't bother entering it. I don't know if it is something I did or something jotform did, but maybe you know the answer.


  • Profile Image
    JotForm Support

    Answered by Kiran on February 03, 2015 at 07:45 PM

    Making any changes to Google spreadsheet and its headers will break the integration. This may result in loss of existing data in the spreadsheet and any new submissions cannot be updated into the  spreadsheet. You may need to remove the existing integration and re-integrate again in order to get it work again. We suggest not to make any changes to integrated spreadsheet especially with the column names. However, you may use Import Range function of Google Docs that imports the data of the integrated sheet to a separate spreadsheet for making any changes.

    Hope this information helps!