Google spreadsheet can be edited while it's being populated?

  • Profile Image
    emilevdende
    Asked on May 06, 2014 at 03:39 PM

    Hi!

     

    All my Jotform's submissions get pushed into a Google spreadsheet file. This file is published on the web somewhere but I need to make additions to the sheet. I want to manually enrich the records with extra information in NEW columns. So no original Jotform submitted information will be edited, just new columns added.

    Does anyone know if this can be done safely? Or does/can this break something?

     

    Thanks in advance!!

    Emile

  • Profile Image
    jonathan
    Answered on May 06, 2014 at 04:56 PM

    Hi Emile,

    We recommend that to do this safely, do it on a copy of the sheet.

    You can use the google spreadsheet application Import Range function to do this.

    The spreadsheet generated by the form integration is always re-created from a template every time you redo the integration. What does this mean is, your added NEW column will be erased by the integration every time you do it.

    Using a copy of the sheet instead will prevent data loss even when the source spreadsheet is refreshed or cleared.

    Hope this help. Please inform us if you need  more assistance.

    Thanks!

  • Profile Image
    emilevdende
    Answered on May 06, 2014 at 05:18 PM

    Thanks a lot for your support and suggestion, I will try that!

     

    Cheers,

    Emile