When I update the form fields in my form, how do I update Google Sheets?

  • SaveTheChildrenIT
    Domanda del 29 settembre 2023 alle ore 04:45

    Salve,

    ho necessità di collegare un modulo jotform a google sheets e sto facendo delle prove.

    Ho riscontrato un possibile problema:

    • se modifico il modulo jotform cambiando il testo di una delle domande sul google sheets collegato non si modifica ma rimane sempre il testo inserito inizialmente. Come posso risolvere?

    Si tratta di un problema perchè avrò probabilmente bisogno, nel tempo, di modificare alcuni dettagli del jotform e vorrei che il google sheets collegato sia sempre aggiornato con le modifiche effettuate.

    Grazie del supporto che riuscirete a darmi

  • Mary Eden Jotform Support
    Risposta del 29 settembre 2023 alle ore 08:06

    Hi SaveTheChildrenIT,

    Thanks for reaching out to Jotform Support. Unfortunately, our Italian 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 Italian, 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. Please note that changing the label of your form fields will not automatically change the columns in your Google Sheets until you have reintegrated your Google Sheets into your form. Basically, if you want to update the title of each column, you must first remove the current integration and then reconnect the existing Google Sheets.  Let me show you:

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

    When I update the form fields in my form, how do I update Google Sheets? Image 1 Screenshot 40

    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.

    When I update the form fields in my form, how do I update Google Sheets? Image 2 Screenshot 51

    • Select an option, whether you want to Create a New Spreadsheet, or connect your existing spreadsheet.
    • Choose your form fields.
    • Click on Save, and that's it, you're done.

    When I update the form fields in my form, how do I update Google Sheets? Image 3 Screenshot 62

    We also have a guide about How to Integrate Forms With Google Sheets that you can check out.

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