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 reset to its default format, losing my custom functions and columns

    Asked by ccpolicetest on June 25, 2015 at 10:48 AM

    I have Google Sheet integration enabled so that our form submissions are written to a Google Sheet (this is awesome, by the way!).  I was able to resize the column headers and even insert additional columns at the end of the spreadsheet to track when the applicant is scheduled for testing and when we mailed out their confirmation letter.

    This has been working great, until the submission written at 2015-06-24 07:53:26 was added.  When this submission was added, the column widths were reset and the two additional columns we had inserted at the end were also removed.

    Do you know why this is?  Will this happen again in the future?

    I'm thinking that I can just add a new sheet and reference the first sheet and add our data to that new sheet.  BUT - if another reset happens, will I lose my new sheet too?

    sheet Google Spreadsheet reset
  • Profile Image
    JotForm Support

    Answered by Welvin on June 25, 2015 at 12:05 PM

    Our apologies for the inconvenience caused.

     

    Do you know why this is?  Will this happen again in the future?

    -As far as I know, we have this as an update to our Google Spreadsheet integration a few months ago. 

    -But we basically do not recommend doing any modifications in the current spreadsheet of the form. Doing so might break the integration and there's no way you can connect back the spreadsheet to the form. A new sheet will be created when you re-integrate.

     

    I'm thinking that I can just add a new sheet and reference the first sheet and add our data to that new sheet.BUT - if another reset happens, will I lose my new sheet too?

    The referencing method and/or IMPORTRANGE function is the best option for processing the data from the integration spreadsheet. You have to create a new Google Sheets file instead of a new sheet in the current file. 

    I don't think you will lose the changes in the new sheet because the data is mainly added to the original sheet. 

     

    Please contact us again if we can help in any way.

    Thanks