Updating google sheets

  • Profile Image
    lsbush
    Asked on March 19, 2020 at 09:22 AM

    Good morning,

    I created a form, synched it w/ Sheets & Drive, and now have made updates to the form. The Google Sheet associated with the Form hasn't updated. How can I resolve this?

    Thanks,

    Laura

  • Profile Image
    Carlos_C
    Answered on March 19, 2020 at 09:53 AM

    Hello,

    Thank you for contacting us, please note that if you change the form (add/remove/change a question) or the spreadsheet directly, the integration can break.

     

    Below you will find a few steps to resolve this process:


    1. Please go to your Google Sheet and update the Recalculation time, click on File > Spreesheet Settings > Calculation and change the Recalculation to On Change and Every Minute.



    2. Remove the integration and add it again. A new spreadsheet will be created and all the submissions will be synced.

    Guide: How-to-Integrate-Forms-with-Google-Sheets.


    Please check and if you notice that the submissions are missing or the new submissions are not syncing, unfortunately, you will have to reintegrate the form to Google Spreadsheets.


    Let us know if you need further assistance.