Cloning a Form Should Not Brake the Google Spreadsheet Ingteration of the Original Form

  • karen@couragerenewal.org
    Asked on May 19, 2014 at 2:15 PM

    Encountered some of the problems that were mentioned a year ago on this post: http://www.jotform.com/answers/252891-PROBLEMS-with-Google-Spreadsheet-integration-Not-updating-data

    I integrated the Google spreadsheet for my form at http://www.jotformpro.com/karen@couragerenewal.org/plc. It worked seamlessly for the first two weeks, but this weekend it stopped working. We've had 5 more entries in the past 3 days and none of them have appeared on the Google sheet.

    Normally the sync between submissions and sheet is rapid, so I know it's not lag. I suspect that what happened is related to CLONING FORMS. Friday evening I cloned the form to modify into a different survey. I noticed that when you clone a sheet it also clones the integrations--so I strongly suspect that Google spreadsheets got confused trying to sync data of two forms into one sheet, and so it quit syncing for both.

    Have you looked into this possibility?

     

  • Carina
    Replied on May 19, 2014 at 3:18 PM

    It's true, cloning a form inside your account also clones the integration and it creates troubles with the original integration that stops updating properly. But by removing and adding a new integration the problem is solved.
    In order to update the Spreadsheet with the missing submissions you can download your submissions in excel format:

    Cloning a Form Should Not Brake the Google Spreadsheet Ingteration of the Original Form Image 1 Screenshot 30

    Then going into your Google Spreadsheet and import the data:

    Cloning a Form Should Not Brake the Google Spreadsheet Ingteration of the Original Form Image 2 Screenshot 41

    I can forward this to our developers so they can analyse better this situation and decide whether to change this cloning property.

    They will notify you via this thread once they have an update on this.

    Please get back to us if further support is needed.

    Thank you

  • alp_deniz
    Replied on May 31, 2014 at 11:08 AM

    We have disabled integrating Google Drive and Spreadsheets while cloning a form. Could you please let me know if you still experience any issues?

    Kind regards