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 integration does not work for new entries

    Asked by frodeo 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

    Page URL:
    http://www.jotform.com//?formID=33276365149864

    does not work Submissions JotForm problem www
  • Profile Image
    JotForm Support

    Answered by Mike_T 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
    JotForm Support

    Answered by alp_deniz 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