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: spreadsheet is no longer being updated with new submissions

    Asked by elgabriello on February 28, 2017 at 02:18 PM

    Hi,

    On this form https://eu.jotform.com//?formID=70295146078965 and others sometimes, it happens that we need to re create the google sheet integration because sometimes, there is no additional line created after a submission. It happened like 4 times in 1 week! Even if all the subscriptions are registered, this is highly problematic as it is time consuming to repair and create a new integration.

    Could you please help us on this?

    Thanks,

    Alexis Cohen

  • Profile Image
    JotForm Support

    Answered by BJoanna on February 28, 2017 at 04:04 PM

    I have tested Google Spreadsheet integration on one of my forms and it is working properly. All submissions are sent to my spreadsheet. 

    I have manually pushed data to your spreadsheet. Can you please check if all submissions are now shown inside of your Spreadsheet. Also please test your form to see in new submissions are sent to your spreadsheet. 

    If you still have issues, then please re-integrate your form with Google Spreadsheet. Remove current integration and integrate you form again.

    How to Integrate Form with Google Spreadsheet

    If integration stops working again after you reintegrate your form with Google Spreadsheet, please let us know. 

  • Profile Image

    Answered by elgabriello on March 01, 2017 at 09:52 AM

    Thanks.

    It works now.

    But we already tried this past week to re integrate our form but it is very painful as we need to change all the importrange in our other files inked to the spreadsheet integration.

     

    What can we do to avoid this problem? This is very common as other teams at Uber (EATS) told me.

     

    Best,

     

    Alexis Cohen

  • Profile Image
    JotForm Support

    Answered by BJoanna on March 01, 2017 at 11:42 AM

    I am glad to hear that integration is working now. 

    Unfortunately I do not know why your integration stopped working. Editing of spreadsheet may some times break the integration. For example editing, adding or deleting columns inside of spreadsheet. I would suggest you not to edit your spreadsheet.

    Let us know if you need further assistance.  

  • Profile Image

    Answered by elgabriello on March 06, 2017 at 08:49 AM

    Hi,

    This is not a proper answer. I do not edit my spreadsheet. The integration just breaks and does not load subscriptions anymore.

    It happened again. Could you please call me or definitely solve this critical issue? May be important cause it is time consuming.

    Thanks,

    Alexis Cohen

  • Profile Image
    JotForm Support

    Answered by Welvin on March 06, 2017 at 11:16 AM

    I'm sorry, but we do not offer a phone support. For urgent matters, this support forum is the best place to reach us.

    As for the problem, I'm forwarding this thread to our developers so they can check the integration for you. We will let you know if we find something and for additional advice.

    For the meantime, please share with us the spreadsheet file so I can include that one on the report. We need it so our developers can check. You can share it with read-only permission. 

  • Profile Image

    Answered by Kadofoto on March 06, 2017 at 11:50 AM

    Hello,

    Sounds like same problem here.

    No new submissions are sent to Google spreadsheet.

    Since 2014-07-14 6:52:56 all data is gone, exept for the date/time.

    I edited another form, nut not the one with the problem.

    Thanks,

    Patrick

  • Profile Image
    JotForm Support

    Answered by BJoanna on March 06, 2017 at 12:57 PM

    @Kadofoto

    I have moved your question to separate thread and we will provide you an answer there shortly. 

    https://www.jotform.com/answers/1082876 

  • Profile Image
    JotForm Developer

    Answered by Denis on March 07, 2017 at 06:48 AM

    Hello,

    Sorry for the trouble caused to you. Problem should be fixed now. Please test it and let us know if issue still persists. If you need any further assistance please feel free to contact us again.

    Regards.