Google Spreadsheet: spreadsheet is no longer being updated with new submissions

  • Profile Image
    elgabriello
    Asked 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
    BJoanna
    Answered 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
    elgabriello
    Answered 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
    BJoanna
    Answered 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
    elgabriello
    Answered 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
    Welvin
    Answered 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
    Kadofoto
    Answered 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
    BJoanna
    Answered 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
    Denis
    Answered 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.