My integrated sheet is broken after editing some content

Hi,

I checked your forms and I found that your synchronization broken. I fixed it now and add your missing submissions for both form to your spreadsheet. But please note that if you edit anything on the spreadsheet, your integration will broke again. You should not edit your spreadsheet.

If you need further assistance, please let us know.

actually i need to mark some name that already used as our employee, so.. will it make it broken??

Yes, as what my colleague has mentioned, any edits on your form could break your integration. I would suggest instead to create another spreadsheet, then from there, use IMPORTRANGE excel function to import the values from your integrated spreadsheet into your second spreadsheet. Then do all the edits on your second sheet.

can i use the same worksheet? or i need to make a new document? 

If you remove the integration and integrate back-again a newly integrated spreadsheet will be generated. Then, you can use the import range feature to pull the data from the old spreadsheet into a new one, in that way the integration will remain intact, and you can customize the new one.

Guide-to-integrate-form-with-Google-Spreadsheet:

https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

Let us know if you need more clarifications. We will be happy to assist.

Thank you.

so the import range doesnt affect the new spreadsheet? 

oh yeah i forgot to ask, what if i change the sheet name, will it make my worksheet disintegrated too? tks much

Any change in your Spreadsheet be it related to renaming it, changes in the header column, changes in the rows will cause the integration to break.

Import Range is just a function which helps you in importing data from one sheet to other.

something happen again to my sheet. my last edited sheet was gone.. can you help? I'm not edit anything since you fix it

Any change in the form or the sheet will lead to breaking the integration.

Could you please share the form URL and the link of your spreadsheet with view access so that we can test or manually push the data.

If possible please re-integrate the sheet and try once.

Thanks.

 https://www.jotform.com/build/62970111506449/settings

https://docs.google.com/spreadsheets/d/1mpGM3JMbzy3nUDhOxlEMgOpwweFueiYjzU0Wa-EbOFk/edit#gid=0

On checking the Google sheet link, I found that I am not able to access it. Please give me edit access so that I can try to manually push the data to your sheet.