How can we make changes to the entries on google sheets without breaking the integration?

  • Profile Image
    abolter
    Asked on November 21, 2017 at 10:40 AM

    How can we make changes to the entries on google sheets without breaking the integration of the sheet?


  • Profile Image
    BJoanna
    Answered on November 21, 2017 at 12:32 PM

    Editing of the spreadsheet that is integrated with the form will usually break the integration and we do not recommend it. 

    I would suggest you to create another sheet and import the data to a new sheet form the sheet that is integrated with your form. This can be achieved with the import range function - http://www.makeuseof.com/tag/how-to-import-data-from-other-google-spreadsheets/ 

    You can then edit your second spreadsheet without breaking the integration.