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 can be edited while it's being populated?

    Asked by emilevdende 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

    Submissions JotForm thanks all
  • Profile Image
    JotForm Support

    Answered by jonathan 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

    Answered by emilevdende on May 06, 2014 at 05:18 PM

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

     

    Cheers,

    Emile