Issue with the Google Spreadsheet integration

  • ODTUVT
    21 Şubat 2024 14:19 tarihinde soruldu

    Merhabalar, 

    Generation Data Days isimli formumuza 101 yanıt gelmiş olarak görünüyor Jotform sisteminde. Ancak Google E-tablolar entegrasyonundaki tabloya göre 99 yanıt var şeklinde gözüküyor. Bunun sebebi ne olabilir? Yine aynı formdan toplanan yanıtlardaki bir kişinin dosyası Google Drive entegrasyonunda görünüyor ancak o kişinin yanıtı entegrasyondaki tabloda gözükmüyor.

  • Rhina Jotform Support
    21 Şubat 2024 16:31 tarihinde yanıtlandı

    Hi ODTUVT,

    Thanks for reaching out to Jotform Support. Unfortunately, our Turkish Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Turkish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. Are you referring to this form? I checked the Google Integration and the submission reflected on the Google Spreadsheet. If you're referring to a different form, can we ask for the link to the form so we can check? I cleared the form cache to refresh the forms. If the issue still persists, please try removing and reintegrating the Google Spreadsheet integration. Let me show you how:

    1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.
    2. In the Settings menu, click on the Integrations option on the left side of the screen.
    3. Select the Google Sheets integration.
    4. Then, click on Remove Integration and then Yes, Remove!

    1648534382 6242a36eb58bf screencast 2022 Screenshot 10

    • Now, let's connect the Google Sheets Integration again:
    • In Form Builder, circle back to Settings at the top of the page.
    • In the Settings menu, click on the Integrations option and Google Sheets integration again.
    • Now, select and connect your Google account.

    1648109353 623c27296967e screencast 2022 Screenshot 21

    • Select an option.
    • Choose your form fields.
    • Click on Save, and that's it, you're done.

    1648109623 623c28372f503 screencast 2022 Screenshot 32

    We also have a guide about Google Sheets integration that you can check out.

    Give it a try and let us know how it goes.

  • ODTUVT
    26 Şubat 2024 08:30 tarihinde yanıtlandı

    Hello again,

    https://form.jotform.com/240052981183959 this is the link of the form which is mentioned on the question.

  • Vincenzo Jotform Support
    26 Şubat 2024 10:50 tarihinde yanıtlandı

    Hi ODTUVT,

    Thanks for getting back to us and for the additional information. I’m sorry that you’re having trouble with your Google Sheet integration on your form with ID 240052981183959. Please note that I was able to manually push 2 missing submissions on your Google Sheet integration. Can you check your Google Sheet and see if the submission is now visible? Can you test your form again and see if it works? If the issue persists, please let us know and we will further investigate.

    Also, note that if you edit your Spreadsheet after integrating Google Sheet with your form, this action can cause an integration failure. So, consider removing the Google Sheet integration on your form and then add it again. Doing that is easy, let me show you how:

    1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.
    2. Click on the Integrations tab on the left side of the screen.
    3. Select the Google Sheets Integration.
    4. Then, click on Remove Integration button and on the Yes, Remove button. Issue with the Google Spreadsheet integration Image 1 Screenshot 20
    5. Finally, reintegrate your form with Google sheet again, and make sure to tick the Send existing submissions to the sheet option; this way, you will be able to send the existing submissions.Google Sheet integration: There is a missing submission Image 3 Screenshot 62 Screenshot 31

    Give it a try and reach out again if you have any other questions.