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

    Encountered issue with Google Spreadsheet last September 30, 2015

    Asked by aandrola on October 01, 2015 at 09:58 AM

    We realized by accident that there was a problem with the google spreadsheet integration on 9/30. Are you aware of this? Do we need to check all forms to make sure that the integrations are working correctly? 

     

    Please advise. 

    Thank you.

     

    Angela Androla

    Page URL:
    http://form.jotformpro.com/form/51616432403951

    integrations google spreadsheet
  • Profile Image
    JotForm Support

    Answered by Mike_G on October 01, 2015 at 11:17 AM

    I would like to apologize for the inconvenience. There are no reported issues about Google Spreadsheet until now. Can you help us by giving us more details of the issue you're having, please? And how are you being affected by it? With that information, we will be able to determine quickly what went wrong during that time. I would recommend you check other forms so you can also confirm if the issue affected all your forms or just one form in particular and let us know. We will wait for your response. I will also check this on my end and if I found any, I will let you know via this thread. Thank you. 

  • Profile Image

    Answered by aandrola on October 01, 2015 at 12:47 PM
    New response received
    I went through my integrated jotforms and found 3 more forms where the
    integration stopped. The last entries that came over were 7/23, then 8/11
    and 8/28. This is disheartening because we are using Jotform because of
    the integration with Google. If this is not reliable, it puts us into a bad
    spot, especially because I am advertising the tool to sister institutions.
    Is there a trigger that causes the integration to stop? Such as, updating
    the form? Reviewing the form? Outside interference?
    Also, the date format of the integration changes at intervals which throws
    off the sort in subsequent google docs.
    Here are the forms that were affected:
    http://www.jotform.us/form/50551525680150, entries stopped after 8/28
    http://www.jotform.us/form/50695211548154, entries stopped after 8/11
    http://www.jotform.us/form/50695211548154, entries stopped after 7/23
    Any help in avoiding these breakdowns would be much appreciated.
    Angela
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on October 01, 2015 at 02:58 PM

    Apologies for the inconvenience, Angela.

    May I know if you are directly editing or updating the integrated Google spreadsheet? adding new rows or columns? We do not advise changing or editing the contents of the spreadsheet, especially the headers or columns as this might break the integration.

    If you have missing submission in the spreadsheet but are visible in the JotForm account, you can try removing the integration and re-integrating the Google spreadsheet again, it will automatically load all the existing submission of the forms in the spreadsheet.

    There is also a new option in the integration that allows you to set a format for the locale which might be dependent on the date format in your spreadsheet.

    Please do note that the submission date and format of it will be dependent on your JotForm account settings timezone.

     

    I hope that information above helps. Please do make some test submissions to see if the integration is working in your end. 

    We'll wait for your response.

  • Profile Image

    Answered by aandrola on October 01, 2015 at 05:47 PM
    New response received
    Thank you Charlie. Please see comments below:
    Angela
    ...
  • Profile Image
    JotForm Support

    Answered by Chriistian on October 02, 2015 at 12:02 AM

    Hi Angela,

     

    Unfortunately, we can't see the comments. Is it an attached photo? Can you re-attach or re-send it so we can see?

     

    We will wait for your response.

    Regards.

     

     

  • Profile Image

    Answered by aandrola on October 02, 2015 at 09:47 AM
    New response received
    Here you go. See attached. My comments are in blue.
    Angela
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on October 02, 2015 at 10:56 AM

    Hi,

    I presume you are replying to this directly directly to your email client? Unfortunately, attached images won't go through. To reply and attach an image, you need to follow the steps below:

    1. First, view this thread directly using its link, please visit this: http://www.jotform.com/answers/674452. Make sure that you are logged in to your JotForm account

    2. Attach an image using the image icon in the text editor

     

    We'll wait for your response.