- andyoharaAsked on April 16, 2015 at 04:57 AM
I've just started using a Google Spreadsheet to view submissions so that I can share data with colleagues on a live-basis easier. It has worked well for a few days but I've noticed that a couple of submissions made in the last 30 hours haven't made it through to the spreadsheet, despite previously these coming through within seconds of the submissions being made.
The form in question is http://www.jotformeu.com/form/50684865684370 and the submissions in question that haven't come through are the ones from Hannah Kitching on 15th April at 3.43pm, and Elliot McDermott on 14th April at 6.12pm.
In addition, there is one from Saleena Bibi on 14th April at 4.56am which I have deleted from the main submissions list, and they have since submitted another. Both came through to the form, but the original one still appears on the submissions list on the Google Spreadsheet (I've coloured the whole line a very dark grey to make it stand out).
Can you offer suggestions why this has happened? I'd rather not delete the spreadsheet and start again as I've added a lot of formulas to this which I don't want to redo.
- KadeJMAnswered on April 16, 2015 at 11:21 AM
We do apologize about any inconveniences involving your google spreadsheet integration suddenly not working.
As far as I know there was an issue with it not too long ago between the spreadsheet and also drive but to my knowledge it was resolved and your occurrence of it is after the fact. There is the possibility that your spreadsheet may have recently gone out of sync.
I did just do a test with this just now from my end and as far as I can tell right now it is working normally so you could try a new submission on your end to see if it would work for you now.
Unfortunately though, in these particular cases we generally recommend removing the integration and reapplying it to rebuild it which will basically pull your jotform data and generate it within a brand new spreadsheet.
Even though it is an inconvenience currently there is no way around that since the previous one was having an issue and we don't currently have a way to reconnect back to it which I believe is because of the corruption that has happened with the previous spreadsheet.
What you could do though is copy and paste the previous data and formulas to move it to the new spreadsheet and that should work as long as you don't override the field headers to maintain it.
- andyoharaAnswered on April 20, 2015 at 06:52 AM
I'm feeling immensely frustrated at this moment in time! I just went to look on my old spreadsheet to start copying over the formulas and additional data I'd put in, and it has all disappeared...
The spreadsheet is now up to date in that the data is all pulling through correctly, but all the additional work I put in has gone. This was before I'd broken the integration!
- KadeJMAnswered on April 20, 2015 at 10:06 AM
Please accept our most sincerest apologies about the frustration this has caused you. I honestly wish we had an easier way to "reconnect" back to your existing spreadsheets to help resolve these sorts of issues, but to my knowledge that isn't possible for various reasons. If there was a way to do that then I believe our developers would have likely had an option for it already if there was one.
I checked this again on my end but I'm still not able to replicate an issue and the details are coming through but I'm unsure of the exact calculations you are using as those are probably just more specific to your own spreadsheet.
When you say it's missing not working anymore and has disappeared are you referring to your data and formulas now? Or? I'm currently under the impression this may have been lost when you attempted to copy it possibly.
- andyoharaAnswered on April 20, 2015 at 10:15 AM
I was referring to the formulas I had added onto the end of the spreadsheet, which were ways of calculating a number based on the values of which cells were filled from each form submission. I hadn't attempted to copy these over yet, as due to the previous 'Help' response saying I should copy and paste the data into an entirely new spreadsheet. I intended to do this before 'breaking' the integration and creating a new link to a Google spreadsheet. However, it seems this has automatically happened somehow!
- CarinaAnswered on April 20, 2015 at 11:48 AM
I'm very sorry for all this situation. Unfortunately there is no way of recovering these formulas. I would suggest to make a backup of the formulas for a future situation, but as for now I believe there is not much to be done.
I will still escalate to see if there is something our developers can do to recover it, but as mentioned before I believe there is not much to be done. We'll contact you via this thread if we have news on this situation.
Let us know if we can assist you further.
- alp_denizAnswered on April 21, 2015 at 09:04 AM
You can easily save your lost formulas by using Google Spreadsheets' revision history (File -> See revision history). Meanwhile, we are currently working on the problem and when it is completed it won't recreate the sheet all over again.
Apologies for the trouble.
- andyoharaAnswered on April 21, 2015 at 09:19 AM
Thank you both for your assistance.
- andyoharaAnswered on April 21, 2015 at 11:26 AM
It just wiped my formulas, AGAIN! The sheet recreated back to the basic default version.
Using the above suggestion, I have managed to bring it back to an older version of the sheet which still has the formulas on it. However, it is now not pulling through any new submission data. Is there any way to re-connect the spreadsheet to collect new submissions that isn't going to wipe everything again?
- alp_denizAnswered on April 21, 2015 at 11:33 AM
I just made a test submission and it seem to work now. If not, could you please point me the problem?
- andyoharaAnswered on April 21, 2015 at 11:39 AM
Thanks for the very quick response - that one has come through, but the one that came through in the meantime from one of the groups using the forms still hasn't come through. If I need to get them to send theirs through again then I will do though.
- alp_denizAnswered on April 21, 2015 at 12:16 PM
Unfortunately you have to insert it manually or re-send missing submissions if you'd like to keep existing formulas. Actually, I highly recommend keeping all other data in other sheets, so that it is possible to keep and re-insert your data/formula anytime required.
I will be around if you need assistance/feedback or request.
- Haider AbbasAnswered on October 09, 2015 at 03:40 PM