Encountered issue with Google Spreadsheet last September 30, 2015

We realized by accident that there was a problem with the google spreadsheet integration on 9/30. Are you aware of this? Do we need to check all forms to make sure that the integrations are working correctly? 

 

Please advise. 

Thank you.

 

Angela Androla

I would like to apologize for the inconvenience. There are no reported issues about Google Spreadsheet until now. Can you help us by giving us more details of the issue you're having, please? And how are you being affected by it? With that information, we will be able to determine quickly what went wrong during that time. I would recommend you check other forms so you can also confirm if the issue affected all your forms or just one form in particular and let us know. We will wait for your response. I will also check this on my end and if I found any, I will let you know via this thread. Thank you. 

New response received
I went through my integrated jotforms and found 3 more forms where the
integration stopped. The last entries that came over were 7/23, then 8/11
and 8/28. This is disheartening because we are using Jotform because of
the integration with Google. If this is not reliable, it puts us into a bad
spot, especially because I am advertising the tool to sister institutions.
Is there a trigger that causes the integration to stop? Such as, updating
the form? Reviewing the form? Outside interference?
Also, the date format of the integration changes at intervals which throws
off the sort in subsequent google docs.
Here are the forms that were affected:
http://www.jotform.us/form/50551525680150, entries stopped after 8/28
http://www.jotform.us/form/50695211548154, entries stopped after 8/11
http://www.jotform.us/form/50695211548154, entries stopped after 7/23
Any help in avoiding these breakdowns would be much appreciated.
Angela
...

Apologies for the inconvenience, Angela.

May I know if you are directly editing or updating the integrated Google spreadsheet? adding new rows or columns? We do not advise changing or editing the contents of the spreadsheet, especially the headers or columns as this might break the integration.

If you have missing submission in the spreadsheet but are visible in the JotForm account, you can try removing the integration and re-integrating the Google spreadsheet again, it will automatically load all the existing submission of the forms in the spreadsheet.

There is also a new option in the integration that allows you to set a format for the locale which might be dependent on the date format in your spreadsheet.

Please do note that the submission date and format of it will be dependent on your JotForm account settings timezone.

 

I hope that information above helps. Please do make some test submissions to see if the integration is working in your end. 

We'll wait for your response.

New response received
Thank you Charlie. Please see comments below:
Angela
...

Hi Angela,

 

Unfortunately, we can't see the comments. Is it an attached photo? Can you re-attach or re-send it so we can see?

 

We will wait for your response.

Regards.

 

 

New response received
Here you go. See attached. My comments are in blue.
Angela
...

Hi,

I presume you are replying to this directly directly to your email client? Unfortunately, attached images won't go through. To reply and attach an image, you need to follow the steps below:

1. First, view this thread directly using its link, please visit this: http://www.jotform.com/answers/674452. Make sure that you are logged in to your JotForm account

2. Attach an image using the image icon in the text editor

 

We'll wait for your response.