auto-refresh of google spreadsheet integration

  • Profile Image
    Naatak
    Asked on May 06, 2013 at 10:10 AM

    I would request is auto-refresh of google spreadsheet integration.

     

    Currently, new entries can come into the sheet and so can edited entries. But if I do anything else with that sheet (like add/modify certain columns), the integration is broken.

    Currently, I remove that integration and add a new one on a weekly basis. As you can imagine the pain in this approach, I request a auto-refresh capability of the jotform-to-google-spreadsheet that recreates the sheet from scratch either on demand or periodically (for me once per day would suffice).

     

    - Siva

  • Profile Image
    Welvin
    Answered on May 06, 2013 at 12:10 PM

    Hi Siva,

    Good day! Let me explain that;

    1. The Google Spreadsheet Columns or Headers should match the Form Field labels. If you will modify these, you may broke the integration. This is how Google Spreadsheet works for us.

    2. If you update any submission, it will create another row in the Google Spreadsheet result.

    You may just try this workaround to avoid re-integrating the form to Google Spreadsheet and broke the integration if you will modify the headers;

    1. Create another Spreadsheet

    2. Copy and Paste the entries from the form Google Spreadsheet result to this newly created Spreadsheet

    3. Do the changes on the newly created spreadsheet.

     

    Thanks