Submitted Form not received and Google Sheet Integration not updated.

  • Profile Image
    Anilyn Ani 
    Asked on February 03, 2021 at 09: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.

  • Profile Image
    Vanessa_T
    Answered on February 04, 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.

  • Profile Image
    Anilyn Ani 
    Answered on February 04, 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.

  • Profile Image
    Vanessa_T
    Answered on February 04, 2021 at 02: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.jpg

    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

  • Profile Image
    Anilyn Ani 
    Answered on February 04, 2021 at 02: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.

  • Profile Image
    Vanessa_T
    Answered on February 04, 2021 at 03: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