Google Spreadsheet reset to its default format, losing my custom functions and columns

  • Profile Image
    ccpolicetest
    Asked 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?

  • Profile Image
    Welvin
    Answered 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