The google integrations are not working consistently since your new format rolled out.

  • rkearton
    Asked on February 15, 2017 at 10:47 PM

    We use the option to download submissions to a spreadsheet in our google drive.  There are about 2 dozen spreadsheets for our organization and  I've had to un-integrate then re-integreat a number of them. 

    Also, I had to reconfigure the fields in some of the Thanks and Email responses. 

    About 2 weeks ago I sent a note about this through the feedback bubble that shows up at the bottom of the page when I'm editing the form but have not gotten a reply. 

    Is there a way to stabilize things so I don't have to keep updating the integrations?

  • Nik_C
    Replied on February 16, 2017 at 4:15 AM

    We had certain issues yesterday that was fixed by our developers already, there was certain delay in submissions going to Spreadsheet. Problems like this usually happen when there are changes in how integration is working with Google. 

    If the issue persists please try to re-integrate your Spreadsheet.

    I tested the integration now, to double check, and it is working fine.

    Please check on your side and let us know how it works for you.

    Also, I couldn't find any recent thread from you regarding this problem, so it might happen that it is not posted.

    Thank you!

  • rkearton
    Replied on February 19, 2017 at 10:33 AM

    Thanks Nik.  

    My issue has been ongoing and sporadic.  

    We have 24 spreadsheets that all do the same thing--we use one for each of our teachers.  Some of them have continued to work properly and others have not.  I don't see a pattern.  

    I can reintegrate them but then we lose edits we have made on the data and I'd rather not if there's a way around it.   

    I guess that's what I have to do, but I don't trust that reintegrating once will ensure that i don't have to go back later and do it again.

    BTW: If you haven't found anything from me it indicates that your "feedback" box is not working correctly because I have sent a few different messages there. It's the box that pops up at the lower right when I'm editing the form. 

    Thanks,

    Robin

  • David JotForm Support Manager
    Replied on February 19, 2017 at 12:43 PM

    Are those edits you are mentioning done on the integrated Google Spreadsheet? Please note that any edit done on the Spreadsheet could cause the integration to break. 

    On regards of the feedback box, those messages are sent directly to our back-end team. Let us know if you need more help.

  • rkearton
    Replied on February 19, 2017 at 1:53 PM

    Hmm..we haven't altered any of the fields, but we have added rows to separate data, and we have colored some of the rows, and we have frozen header rows.  

    Do you think that could be making the problem?

  • Nik_C
    Replied on February 19, 2017 at 2:05 PM

    A coloring of the table or adding new columns shouldn't affect the integration as per what I tested.

    Now, freezing the header rows, I'm not sure about that, you made them read-only right?

     

  • rkearton
    Replied on February 19, 2017 at 11:46 PM
    Yes, they are read only, except that our bookkeeper can add rows. But she does not edit the content except to add a row
    Robin Kearton
    Director, Community Center for the Arts (C4A)
    www.c-4a.org
    rkearton@c-4a.org
    217.384.5150
    ...
  • Ashwin JotForm Support
    Replied on February 20, 2017 at 3:06 AM

    Hello Robin,

    I did test this issue in one of my own form and I am unable to replicate the issue you are having. I added one row in integrated google spreadsheet and I also freeze the first row but all new submissions was sent to google spreadsheet successfully. 

    I would suggest you to speak to your bookkeeper and ask if he is editing the header column which will cause the integration to break. I would also suggest you to please re-integrate your form with google spreadsheet and see if that solves your problem.

    Thank you!