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: Sheet not updating

    Asked by MarketingGlobal on June 06, 2017 at 05:06 AM

    We just discovered the problem that there's no conexion existent between the excel generated in Jotform.

    We've been making trials, filling the form and that info does not appear on the excel in the moment.

    But neither the next day.

    Is weird, because it normally works, So I don't know what is the problem with that Form.

     

    Only If I remove the excel and generate another new, it works, but is momentary because if someone new is registered, it does not appear.

     

    Please could you help me?

    Page URL:
    https://cabify.com/republica-dominicana/recomienda

  • Profile Image
    JotForm Support

    Answered by Charlie on June 06, 2017 at 06:51 AM

    Hi,

    I presume when you say "Excel Sheets" you are actually referring to the Google Spreadsheet Integration? I went ahead and pushed the missing submissions, could you please check again?

    May we know if you are making changes on the spreadsheet? Like changing the sheet name, title, adding columns, changing column names, adding new rows, etc...? Please note that if you make extensive changes on the spreadsheet, it may cause the integration to break, which stops the spreadsheet to update. 

    Could you please try the following.

    1. First, remove the integration.

     

    2. Let the form builder save the changes.

    3. Open the Integrations page again and connect Google Spreadsheet. This will create a new spreadsheet.

    4. Existing submissions in your form will automatically be inserted in the spreadsheet.

    5. Test your form by filling it out and hitting the submit button. See if the submission will go through the spreadsheet.

     

    If it still fails, please send us the spreadsheet link wherein we can access it. Here's a guide link on how you can share a Google file to us: https://support.google.com/drive/answer/2494822?co=GENIE.Platform%3DDesktop&hl=en

    We'll wait for your response.