Submitted Form not received and Google Sheet Integration not updated.

  • Anilyn Ani
    Asked on February 3, 2021 at 9:08 PM

    Good Day,

    I want to raise the ff concerns:

    1. we did not received the submitted data from our forms despite the fact that the thank you message was already shown.
    2. Google sheet is not updated, some of the submitted data where not in the integrated google sheet form, I always have to re-integrate the google sheet for it to become updated.

    hoping for you response as soon as possible. Thank you.

  • Vanessa_T
    Replied on February 4, 2021 at 12:40 AM

    Kindly share with us the URL of the form that you are having this issue with.

    Where-to-Find-My-Form-URL

    Also, please note that we highly discourage modifying the integrated Google Sheets as it may break the integration.

  • Anilyn Ani
    Replied on February 4, 2021 at 12:48 AM

    Here's one of the forms link: https://form.jotform.com/ACABAReForms/second-approval

    We also encounter the same problem from our other forms.

    Regarding the google sheet integration, we did not modify the integrated Google Sheet file but still some of the data were lost. I just want to ask what's the best thing to do to solve this problem.

    Thank you.

  • Vanessa_T
    Replied on February 4, 2021 at 2:03 AM

    I checked the form and can see that the first 2 fields are read-only, as such, I am uncertain how are your users submitting this form.

    1612422211 601b9c436cd61 02990 Screenshot 10

    Would you mind sharing the complete workflow of your form?

    Meanwhile, I checked the form's Google Sheet integration and it looks like you have not re-integrated it as it is still using the old Google Sheet integration.

    Kindly remove the Google Sheet integration and re-integrate.

    https://www.jotform.com/help/790-how-to-integrate-jotform-with-google-sheets

  • Anilyn Ani
    Replied on February 4, 2021 at 2:34 AM

    It is read-only because it is connected from other form, the data of that two fields are from the other form.

    Our other forms were using the latest Google Sheet Integration. Why does it is still not always updated, some of the records submitted where missing and have to re-integrate again for it to be updated.

    Hoping for your assistance to solve the problem.

  • Vanessa_T
    Replied on February 4, 2021 at 3:45 AM

    Kindly share the URL of the initial form, and may we send test submissions in it as well so we may try to replicate the issue.

    As for your Google Sheet concern, I have moved it to a separate ticket and will be answering you in the link below shortly:

    https://www.jotform.com/answers/2873379