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 App Not Working.

    Asked by bhds on December 04, 2014 at 11:07 AM

    An end-user completed one of our forms this morning.  The Google Spreadsheet app has been attached to this form so that submissions are automatically submitted to a Google spreadsheet that is shared with the people in our organisation who need to see the data.  The submission that was made this morning has NOT shown up in the Google spreadsheet; please can you investigate why this is the case, and advise how the issue can be resolved?

    Thank you.

    Page URL:
    http://www.jotformpro.com/form/41893744516968

    app Submissions resolved attached
  • Profile Image

    Answered by Shadae on December 04, 2014 at 12:07 PM

    Hi bhds,

    I do apologize for the issue that you are experiencing with your Google Spreadsheet integration.

    The information should be updated once the form is submitted but there could also be a delay on the information being sent to the Google Spreadsheet.

    Please follow the steps below to resolve the issue:

    1. Remove your current Google Spreadsheet Integration

    2. Clear your Form Cache

    3. Create the Google Spreadsheet integration once again.

    I hope this helps, please inform us if you need further assistance.

  • Profile Image

    Answered by bhds on December 04, 2014 at 12:53 PM

    This is not the first time that this has happened with Google Spreadsheet integration, and last time it happened I followed the procedure that you have suggested.  However, the drawback to this is that any changes made in the Google Spreadsheet, e.g. addition of another column for comments, etc, were deleted when the Jotform was re-synchronised with the spreadsheet when the integration was re-added.

    Is there any way to force Jotform to send the missing data without having to remove the spreadsheet integration and then re-add it?

  • Profile Image

    Answered by Shadae on December 04, 2014 at 01:20 PM

    Hi bhds,

    Unfortunately, there is no way to force the information through, the integration will need to be recreated.

    The making of the extra columns on your Google Spreadsheet can actually be the cause of the break in the integration.

    There is a work around if you need to have additional columns on your spreadsheet. You can create a few fields, the same number as the number of extra columns that you need and set them to hidden. The integration will create the extra columns and since the new fields are hidden, they will also be empty every time, allowing you to add your own data.

    I hope this helps, please inform us if you need further assistance.

  • Profile Image

    Answered by bhds on December 05, 2014 at 11:50 AM

    The additional columns to which I referred were indeed hidden columns on the form.

    I followed your advice and removed then re-added the Google spreadsheet integration.  As I feared, and indeed pointed out, we have lost the data that was in the columns represented by the hidden fields.  We will now have to spend time recreating the lost information.  What do you feel your liability is for this?

    This is not the first time that we have had issues with the Google spreadsheet integration not working, so what assurances can you give me that we can indeed rely on this feature?

  • Profile Image

    Answered by Ben on December 05, 2014 at 01:50 PM

    Hi,

    I am sorry to hear that you have lost your data, but as mentioned by my colleague, it would create empty columns for you.

    Now what I would suggest is to add the data to jotform, through edit option is submissions panel (or over the link in email) instead of directly in the spreadsheet. This way if you recreate the data, all of your data would be available afterwards as well.

    Now to not send emails during this time, I would condition emails to send the email autoresponder and notifier only if these extra fields are all empty.

    Hope that helps.

    Also, based on your response, I have concluded that you were able to recreate the integration and I presume that it is now working properly for you?

    Best Regards,
    Ben