I made the Google spreadsheet integration and everything went fine even

jaegi
Asked on June 27, 2013 at 04:40 AM

I made the Google spreadsheet integration and everything went fine even after modifying the table (I put some colour in the columns and made some others invisible, but didn't add or clear something or changed the order). Yesterday I recognised that new entries were not pushed anymore to the spreadsheet (what after the formatting worked fine that day). So I tried to cut and reeintegrate the sheet. This was a mistake, because the reintegration opened a new sheet, so I lost all the formattings. Today I see, that the entries of yesterdays test after all found their way to the formatted table over night. So the integration was not broken, it just took a break. My question now: ist it possible to reestablish the connection between the form and the existing formatted table, which is already embeded in other site? And do you think that my (just cosmetic) customizing caused the break?

This is a re-post of a comment on How to Integrate Forms with Google Sheets
sidharth_kch
Answered on June 27, 2013 at 07:14 AM

@jaegi

Please let us know the form id with which you are having this issue. Also it would be great if you could give us the access to your updated google spreadsheet. This will help us investigate your issue.

Thanks,

Sidharth
jaegi
Answered on June 27, 2013 at 08:20 AM

Hi Sidharth

Thanks for your support.

ID: 238127838033821278

formatted spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0ApVLtS42KqefdFdCWTRCQzd2bThxRWVaT2NpZG9tVHc&usp=sharing

New spreadsheet (actualy connected): https://docs.google.com/spreadsheet/ccc?key=0ApVLtS42KqefdHlxNGdZYlFncnFia2hKMzR5Z19zNGc&usp=sharing

The table in action: http://pinguinkampf.weebly.com/resultate.html
HandCTV
Answered on October 31, 2014 at 05:15 PM

Hi,

I have a similar issue. Our jot forms work great. The information is collected in a google spreadsheet, that works great too. But to keep track of progress of dealing with feedback to customers filling in the forms, we changed colours on the spreadsheet rows or changed font formatting on spreadsheet rows. We did not add columns or rows or change column or row orders in the spreadsheet.

What happens in my case is that with new form submissions, the colours disappear and the font formatting in the spreadsheet is re-set.

Derek
Kiran

Jotform Support

Answered on October 31, 2014 at 06:29 PM

@Derek,

Your issue will be addressed on a separate thread.

http://www.jotform.com/answers/452563

Thank you.