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

  • ptn0301
    Asked on May 1, 2014 at 4: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

    Jotform Thread 370384 Screenshot
  • jonathan
    Replied on May 1, 2014 at 5: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!