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.


  • Profile Image

    [Google Spreadsheet] Some entries are not being delivered

    Asked by aquasports on November 24, 2014 at 03:50 PM

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

    google spreadsheet
  • Profile Image
    JotForm Support

    Answered by Mike_T on November 24, 2014 at 04: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)?

  • Profile Image

    Answered by aquasports on November 24, 2014 at 07: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
    ...
  • Profile Image
    JotForm Support

    Answered by jonathan on November 24, 2014 at 08: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.

     

     

     

     

  • Profile Image

    Answered by aquasports on November 25, 2014 at 01: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
    ...
  • Profile Image
    JotForm Support

    Answered by Mike_T on November 25, 2014 at 03:27 PM

    The dates are filled on Jonathan's test spreadsheet.

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

    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.

  • Profile Image

    Answered by aquasports on November 25, 2014 at 07: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
    ...
  • Profile Image
    JotForm Support

    Answered by jonathan on November 25, 2014 at 08: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.

     

    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.