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

    Small edit on form has removed all data from integrated google spreadsheet?

    Asked by ptn0301 on May 01, 2014 at 04:39 AM

    HI

     

    As titie the data/column fom a spreadsheet has been removed. Was this due to a small edit in the form? Or something else.

     

    New submissions are placed on the next row down in google docs however we had an additonal column that was used for entering comments.

    We share the submissions via google docs but the extra column data has now vanished??

     

    Thanks

    Page URL:
    http://www.skyemotion.net/apply-now-14-c.asp

    Screenshot
    integrated all Submissions next Comments thanks
  • Profile Image
    JotForm Support

    Answered by jonathan on May 01, 2014 at 05:26 AM

    Hi,

    To clarify, editing the form like deleting field or renaming a field name, will have drastic effect on the integrated Google spreadsheet.

    You will need to re-integrate the form again to Google spreadsheet so that the spreadsheet can be refreshed with the current state of the form.

    In your case, if my understanding is correct, you meant that you have added a comment column in the Google spreadsheet -- where did you placed the comment column?

    Usually it is applicable to do it after the right most column/field to preserve the current index number assignment generated when the form was integrated to the spreadsheet.

    When the form is integrated to spreadsheet, it will totally removed the spreadsheet also and will construct a new spreadsheet from scratch -- this can be the reason also for the custom column you added to vanish on the spreadsheet.

    To prevent loss data in the spreadsheet, when doing such changes, make sure to backup/copy your integrated spreadsheet.

    Hope this answers your inquiry. Inform us if you need more assistance.

    Thanks!