Google Spreadsheet integration does not work for new entries

  • Profile Image
    frodeo
    Asked on January 27, 2014 at 02:58 PM

    The integration with Google Spreadsheet seems rather shaky. When I tested it for http://www.jotform.com/submissions/33276365149864 it was OK, but the submisson from 2014-01-27 01:12:33 has not been sent to Google Spreadsheet. The Google Drive integration seems to work.

    1) Is there any way for me or you to make this more robust?

    2) Is there any way to resync Google Spreadsheet with the submissions? As far as I experience it works by removing the integration and then creating it again. Is that a possible solution? (but of course quite cumbersome)

    I have had the same problem with both of these forms:
    http://www.jotform.com//?formID=33276365149864
    http://www.jotform.com//?formID=33356949290363

    Regards
    Frod Oldervoll

  • Profile Image
    Mike_T
    Answered on January 27, 2014 at 03:41 PM

    Thank you for contacting us.

    1) Is there any way for me or you to make this more robust?

    It looks like that the Google Spreadsheet integration can not handle colon symbols ':' on the field labels:

    Please remove these symbols from your field labels, and then re-integrate your forms with the Google Spreadsheet service. It should fix the problem.

    I will also escalate a bug report ticket to our Development Team for consideration.

    2) Is there any way to resync Google Spreadsheet with the submissions?

    There is no way to resync the integration to some existing spreadsheet, but your fresh spreadsheet will automatically receive all the past data.

    If you need any further assistance, please let us know.

  • Profile Image
    alp_deniz
    Answered on February 14, 2014 at 06:08 PM

    This problem seems to be fixed. Are you still having the issue?

    Please accept my apologies for my late response.

    Kind regards