- dorsetholidayletsAsked on April 05, 2015 at 07:22 AM
I am using Google Spreadsheet integration with our form which works very well most of the time, but twice it has lost two new columns that I have added. I can recover using the history but would prefer not to lose them.
Can you explain why.
- JotForm SupportWelvinAnswered on April 05, 2015 at 10:39 AM
We have allowed it before, but we really don't recommend it. I think our developers have added that function in the integration so to make sure that the sheet won't be modified and will stay intact based on the fields from your form.
What you can do now and the only thing I could suggest is to use Import Range function in Google Spreadsheet: https://support.google.com/docs/answer/3093340?hl=en. So, add a new sheet and process the data there from the form submissions.
Let us know if you need further assistance.