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

    Not all form submissions going to the integrated Google Spreadsheet

    Asked by ShavitzHVAC on January 11, 2017 at 08:22 AM

    We're doing a pilot using Jot Forms as a workflow form with multiple users.  One user creates and starts the form and then we've integrated the form with Google Sheets so that we can send that link to multiple users so they could input the information for their required position.  We started the trial yesterday and noticed that not all of the forms are being exported to Google Sheets so I have 2 questions.  1) Why aren't all the forms being transferred to Sheets?  2) Is there any other easier way to send the link of a partially completed form to others so they can input information and re-submit? 

     

    Thanks, 

  • Profile Image
    JotForm Support

    Answered by Boris on January 11, 2017 at 10:46 AM

    When a form is integrated with a Google Spreadsheet, it will forward all its submissions to that sheet. Sending of data will be triggered upon each form submission in JotForm, including any submission edits.

    Are you saying your other users are making edits by modifying the spreadsheet itself?

    Based on your description, it sounds that after you've made some edits on the sheet, submissions stopped being forwarded. Please keep in mind that such edits inside the sheet may break the integration between the form and the sheet.

    Integration depends on the spreadsheet remaining as unmodified as possible, or otherwise the integration is not able to pass new rows of data, or new data to existing rows.

    If you depend on your users to update their submissions to complete all the data, you may want to utilize our Edit Submission links, as described in the following guide:

    https://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date

    Similarly, if you want your users to update data inside the integrated Google Spreadsheet, please ask them to do so by clicking on the Edit Submission link inside the integrated spreadsheet:

    Please let us know if you need any further clarifications or assistance.