Google Spreadsheet App Not Working.

An end-user completed one of our forms this morning.  The Google Spreadsheet app has been attached to this form so that submissions are automatically submitted to a Google spreadsheet that is shared with the people in our organisation who need to see the data.  The submission that was made this morning has NOT shown up in the Google spreadsheet; please can you investigate why this is the case, and advise how the issue can be resolved?

Thank you.

This is not the first time that this has happened with Google Spreadsheet integration, and last time it happened I followed the procedure that you have suggested.  However, the drawback to this is that any changes made in the Google Spreadsheet, e.g. addition of another column for comments, etc, were deleted when the Jotform was re-synchronised with the spreadsheet when the integration was re-added.

Is there any way to force Jotform to send the missing data without having to remove the spreadsheet integration and then re-add it?

The additional columns to which I referred were indeed hidden columns on the form.

I followed your advice and removed then re-added the Google spreadsheet integration.  As I feared, and indeed pointed out, we have lost the data that was in the columns represented by the hidden fields.  We will now have to spend time recreating the lost information.  What do you feel your liability is for this?

This is not the first time that we have had issues with the Google spreadsheet integration not working, so what assurances can you give me that we can indeed rely on this feature?

Hi,

I am sorry to hear that you have lost your data, but as mentioned by my colleague, it would create empty columns for you.

Now what I would suggest is to add the data to jotform, through edit option is submissions panel (or over the link in email) instead of directly in the spreadsheet. This way if you recreate the data, all of your data would be available afterwards as well.

Now to not send emails during this time, I would condition emails to send the email autoresponder and notifier only if these extra fields are all empty.

Hope that helps.

Also, based on your response, I have concluded that you were able to recreate the integration and I presume that it is now working properly for you?

Best Regards,
Ben