What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Speadsheet ErrorsAsked by stevenyilin on August 27, 2013 at 07:40 AM
this is my old spreadsheet:
note - its first top row is not moving.
this is my new spreadsheet:
i watched in disbelief when i received an enquiry over my homepage and the top column headings were written over by the incoming data (column colored in green).
this has happened with previous intergrations... but this time i saw happen LIVE.
so i have no doubt that there are bugs which jotform needs to work on in regards to google spreadsheet.
also - why is my top row not static anymore like in the old intergrations? the screenshot shows the old one, where you can scroll up and down and row 1 with the variable names are always visible.
i ve shared both old and new version with email@example.com so you can have a look inside.
That was before but due to some issues we encountered with Google we have to adjust something from our end in order to deal with the Google API.
You can actually freeze first row in your spreadsheet after the integration. It's pretty easy, here's how:
Regarding on the updates, new submissions sets in under the last existing submission. This is how it works even before. The updates is almost instant as usual. If you find any problems or if I've missed something on your question, let us know here.
thanks for tip of freezing rows... works fine now.
but the incoming new data is still writing over the headings... usually if you change die variable names in the spreadsheet's 1st row, the form stops working.
what can i do about this?
see my new spreadsheet:
a good way to avoid editing of the submission direct at the original sheet, you can add a new sheet to the submission spreadsheet, then by using Spreadsheet formulas you can fetch the original data from "sheet1" to "sheet2". You can use your own header variables names and leave untouched the original sheet where the submissions are populated.
Please check this exampel I made for you:
Also check this images:
Hope it helps
please let us know if you need further assistance