[Google Spreadsheet] Some entries are not being delivered

  • aquasports
    Asked on November 24, 2014 at 3:50 PM

    Something is wrong with integration with google sheets, a lot of the info does not come over

  • Mike_T Jotform Support
    Replied on November 24, 2014 at 4:55 PM

    Thank you for contacting us.

    Please provide us with some more information on this issue. We will need the form ID/name to be able to clone it and do our tests. Also, are you having issue with the form fields which are missing on the spreadsheet (empty cells) or the form submissions (missing rows)?

  • aquasports
    Replied on November 24, 2014 at 7:11 PM
    This is the form:
    http://mauikiteboardinglessons.com/home/student-instructor-compatability/
    If I go to jotform and look at my submissions all the info is there, but if
    I go to google spreadsheet alot of info is missing , usually it's: start
    date , last day on maui, days devoted to kiteboarding, questions 4,5,6 and
    sometimes others
    Aloha,
    Karen and the Aqua Sports Maui Team
    808 242 8015
    Aqua Sports Maui Kiteboarding Lessons
    Aqua Sports Maui on Facebook

    Aqua Sports Maui Blog
    Maui Wind and Wave Forecast
    Northshore Kite and Sail Repair
    Windsurfing School of Maui
    ...
  • jonathan
    Replied on November 24, 2014 at 8:02 PM

    Hi,

    I cloned your jotform http://www.jotformpro.com/form/43245200178952 to test for issue in my Google spreadsheet integration.

    But so far I could not replicate the issue.

    This is my test jotform http://www.jotformpro.com/form/43277426406961

    You can test submit it and then check the shared google spreadsheet here 

    Check if your test submission is in the google spreadsheet.

     

    I also suggest you try first redoing the re-integration of your form to google spreadsheet.
    That is, remove the integration and integrate again. After doing this process, test and check if it resolves the issue.

    Please inform us if issue persist.

    Thanks.

     

     

     

     

  • aquasports
    Replied on November 25, 2014 at 1:51 PM
    Here is what jotform looks like, notice, first date last date how many days
    now see google: see all missing fields?


    Aloha,
    Karen and the Aqua Sports Maui Team
    808 242 8015
    Aqua Sports Maui Kiteboarding Lessons
    Aqua Sports Maui on Facebook

    Aqua Sports Maui Blog
    Maui Wind and Wave Forecast
    Northshore Kite and Sail Repair
    Windsurfing School of Maui
    ...
  • Mike_T Jotform Support
    Replied on November 25, 2014 at 3:27 PM

    The dates are filled on Jonathan's test spreadsheet.

    [Google Spreadsheet] Some entries are not being delivered Image 1 Screenshot 30

    If you would like to share some images, you can insert them into your answer.

    [Google Spreadsheet] Some entries are not being delivered Image 2 Screenshot 41

    We would like to recommend you to re-do the Google Spreadsheets integration. It might resolve the issue. Note, that your fresh Google Spreadsheet will receive the previous form entries automatically.

  • aquasports
    Replied on November 25, 2014 at 7:51 PM
    I already redid it twice
    Aloha,
    Karen and the Aqua Sports Maui Team
    808 242 8015
    Aqua Sports Maui Kiteboarding Lessons
    Aqua Sports Maui on Facebook

    Aqua Sports Maui Blog
    Maui Wind and Wave Forecast
    Northshore Kite and Sail Repair
    Windsurfing School of Maui
    ...
  • jonathan
    Replied on November 25, 2014 at 8:30 PM

    Hi,

    Can you please test submit my test form http://www.jotformpro.com/form/43277426406961

    Once again I did another test submission, and I did not encounter any issue.

    If you checked the my Google Spreadsheet the last test submission is again delivered to the sheet.

    [Google Spreadsheet] Some entries are not being delivered Image 1 Screenshot 20

     

    We cannot see the uploaded screenshot if you have already uploaded when you said you already did twice.

    Follow this guide on how to include screenshot in your message.

    It will also help if you can share the Google spreadsheet URL of your integrated form so that we can also test.

    Please continue updating us if issue still remains.

    Thanks.