Problème Soumission dans google sheet

  • CEBAG2
    Demandé le 27 octobre 2023 à 08:37

    Bonjour,

    J'ai récemment rencontré un problème lors de l'intégration de mes soumissions dans google sheet.


    Lors ce que j'ai une soumission cette dernière s'intègre automatiquement à la place des questions sur la ligne A1 au lieu de A2 puis A3 etc..

    Voir screenshot.


    Pouvez-vous m'aider ? Cela le fait uniquement dans trois formulaires sur 5.


    Problème Soumission dans google sheet Image 1 Screenshot 40

    Problème Soumission dans google sheet Image 2 Screenshot 51


    Problème Soumission dans google sheet Image 3 Screenshot 62

  • Vincenzo Jotform Support
    Répondu le 30 octobre 2023 à 04:09

    Hi contact_contact263,

    Thanks for reaching out to Jotform Support. Unfortunately, our French Support agents are busy helping other Jotform users at the moment. I'll try to assist you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd prefer to receive support in French, 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. Have you recently updated the form or made changes directly to the integrated Spreadsheet? Please note that if you make changes on the form or on the spreadsheet directly, the integration can break. Also, I cloned your form and tested it to see if I could replicate the issue, but everything was working properly. Check out the screencast below to see my results:

    Problème Soumission dans google sheet Image 1 Screenshot 40

    Please try to remove your current Google Spreadsheet Integration and reintegrate again. Let me show you how:

    1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
    2. In the left column, click on the Integrations tab and select Google Sheets.
    3. Next, click Remove Integration, and then on the confirmation window click on Yes, Remove. Problème Soumission dans google sheet Image 2 Screenshot 51
    4. Integrate Google Sheet again.
    5. You can also choose the same Spreadsheet by selecting the Use an existing Spreadsheet option.
    6. Also, make sure to check the option Send existing submissions to the sheet.Problème Soumission dans google sheet Image 3 Screenshot 62
    7. Finally, click on Save at the bottom.

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