Google Spreadsheet Integration - Not transferring all submissions

What is JotForm?

JotForm is a freeonline form builder which helps you create online forms without writing a single line of code.

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.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

fwh

Asked on July 08, 2014 at 12:26 AM

I've had this problem come up maybe 4 or 5 times in over half a year or so of use and around 100 total submissions. It may be two different problems, or perhaps they're just related.

In a couple of cases, Jotform records a blank response for a field. Other fields of the same type are recorded fine. (it's a blank response in jotform's inbox)

In the most recent case, this time Jotform (inbox) recorded all the data, but the google spreadsheet showed blank responses. I also had a hidden field which recorded properly in the google spreadsheet.

Here's how it played out:

Response 1: All fields recorded in Jotform + Google spreadsheet

Response 2-5: First 3 fields are all blank in spreadsheet. hidden field recorded in spreadsheet. all fields recorded in jotform.

I did clone your form and integrated it with my google spreadsheet. I am able to replicate the issue you are having.

The first time we integrate your form with google spreadsheet and then send a test submission, the data does not gets saved in the spreadsheet. When we go back and remove the "&" symbol you have in your field and then send a test submission, the data gets saved to the spreadsheet. It also saves the previous submissions as well. Once the data starts getting saved in the google spreadsheet and then we change the question label again add "&", it continues to save the submission data.

I am reporting this to our back end team. We will get back to you as soon as we have any update from our back end team.

Thank you!

alp_deniz

Answered on July 16, 2014 at 05:06 AM

Hello,

We have fixed the issue related to ampersand character in google spreadsheets headers. Could you please confirm that it is completely fixed?