- cfnavyleagueAsked on February 20, 2015 at 11:42 AM
I have noticed a number of submissions are missing from my integrated Google Spreadsheet. I have just tested two submissions and they both failed.
Form ID 43564362097965
- cfnavyleagueAnswered on February 20, 2015 at 12:52 PM
I ended up deleting the integration and creating a new one - which went to a new sheet. I rebuilt all of my reporting and was good to go.
I suppose this occurred because I used a "Filter View" on the Submissions sheet, and this disrupted the integration for some reason. I am now using an "=IMPORTRANGE" function on a separate sheet to get a sortable view, and I've hidden the Submission sheet to make sure this doesn't occur again.
- JotForm SupportKiranAnswered on February 20, 2015 at 02:49 PM
Yes. You are right. Making any changes to submissions sheet would break the integration. It is always suggested to use a separate sheet and copy the data from submissions sheet for making any modifications or run any reports as you just did.
We appreciate your efforts in resolving the issue and glad to see that you have found the solution. Please do not hesitate to get back to us if you need any further assistance. We will be happy to help.