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.
Google sheets integration not updatingAsked by SusanCantor on February 03, 2017 at 12:15 AM
Hi there, I am organizing a race and the racers sign up using a jotform. I integrated the form with google sheets and embedded the sheet into my website. At first it worked fine but now it's not working at all. I did modify the sheet by HIDING some of the columns, changing the format for the numbered entries (so they would be "xxx" instead of "$58", for instance) and by adjusting the column width.
At first the modifications didn't seem to ruin the integration (although whenever I EDITED an entry, the integration would fail). If I don't modify the format of my google sheet it really doesn't work well on the website. Please advise why the google sheet integration has been failing.
Appreciate a very speedy response! Thanks.
PS. I entered the last two racers by hand because Jotforms isn't updating. Not a good solution!
Please note that we do not advise users to modify the columns in the integrated google sheet because it could break the integration. If you want to modify the sheet by hiding some of the columns, I would suggest to use the ImportRange tool of Google Spreadsheet.
To make your google spreadsheet integration woks again, please try to re-integrate it on your form.
Hope this helps.