Google Spreadsheet Integration - Submission does not appear in the spreadsheet

  • Profile Image
    anthonyaramdass
    Asked on August 01, 2013 at 12:38 PM

    The Google Spreadsheet integration is not syncing automatically. It will sync once but it won't synchronize when new submissions are received.

  • Profile Image
    sidharth_kch
    Answered on August 01, 2013 at 02:10 PM

    @anthonyaramdass

    My apologies for the inconvenience this has caused.

    I cloned your form and did few test submissions. I was able to reproduce this issue. I am creating a ticket and forwarding this issue to our development team. We will update you via this thread.

    Would using the HTML listing report be an alternative? This report updates automatically with every submission.  It can be embedded on a page or a form.

    Here is a guide to help you with that meanwhile the integration issue is resolved.

    http://www.jotform.com/help/209-Create-an-HTML-Table-Listing-Report

     

    Thanks, 

    Sidharth

  • Profile Image
    anthonyaramdass
    Answered on August 01, 2013 at 02:52 PM

    Thank you for replying. Would I be able to sync this to a google spreadsheet by any chance?

  • Profile Image
    sidharth_kch
    Answered on August 01, 2013 at 03:21 PM

    @anthonyaramdass

    Yes absolutely. This issue is already forwarded to our development team. Please stand by for updates from them. 

    Thanks.

  • Profile Image
    aytekin
    Answered on August 02, 2013 at 11:25 AM

    Do you still have this problem? It might be a temporary problem on our server or google's end. 

  • Profile Image
    anthonyaramdass
    Answered on August 02, 2013 at 06:23 PM

    I created the HTML Table but how can I see the submissions as a google doc using the embed code or weblink?

  • Profile Image
    Alhambra
    Answered on August 03, 2013 at 02:37 AM

    [correction to my previous comments] it still looks like a problem, but not really.  I waited well in excess of 10-15+ mintues and no updates, but now I see the spreadsheet is updating.  And now it updates instantly.

    I love what you guys are doing with the GDocs Spreadsheet integration.

    Also, it would be great to hear what functionality we should expect out of this otherwise amazing feature - is there any more documentation? 

    For example, I found that as long as we do not change the label in the header row, I could add/move columns and it would update:  As long as the header row had the original name.

    Thanks for a great product!

     

    -J

    Jason Escamilla

    Alhambra Capital Advisors

     

    P.S. Thanks, Sidharth, for the HTML listing heads up!  I did not notice that feature until I was debugging my spreadsheet integration and came across this thread.

  • Profile Image
    Welvin
    Answered on August 03, 2013 at 07:19 AM

    Hi Jason,

    Are you "anthonyaramdass"? Is that a separate account? I hope that it will continue to work without any problem. If the issue occurs again, please be sure to let us know by creating a separate thread.

    We only have one guide for the Google Spreadsheet Integration. We don't have further articles that would itemize each options for the integration. You can always come back to us for your questions. We're here 24/7.

    Also, you can search our Forum. One of your question may have been answered by the team.

     

    Thanks

  • Profile Image
    anthonyaramdass
    Answered on August 03, 2013 at 10:23 AM

    No, that is not me. That's someone else's account. 

  • Profile Image
    anthonyaramdass
    Answered on August 03, 2013 at 11:25 AM

    Ok, I see that the google spreadsheet works. It just takes a bit of time to refresh. My question is, if I format the header and freeze that row, would it affect the integration?

  • Profile Image
    jefreylandicho
    Answered on August 03, 2013 at 12:17 PM

    Modifying the Google spreedsheet could make the integration not to work so I would not recommend changing anything in your Google Spreedsheet.

  • Profile Image
    CoachMyRodeo
    Answered on August 04, 2013 at 10:48 PM
  • Profile Image
    Alhambra
    Answered on August 04, 2013 at 11:57 PM

    Anthony, 

    I recommend checking out my response above and some testing on your own before giving up entirely on  the formatting changes/column re-arranging.  I've had success in my testing.   Just don't insert a row at top; don't change the text in the first row of the linked column.

    -J