Google Sheet: Some fields are missing on Google Sheet

  • alangabbai
    Domanda del 12 novembre 2023 alle ore 18:09

    Buongiorno,

    ho integrato il mio modulo con Google Sheet.

    Funziona tutto alla perfezione tranne il valore del campo "CHECK-OUT: EXCLUSIVELY REQUESTED BEFORE 11 am" la cui colonna rimane vuota per ciascuna riga. Tutti gli altri campi funzionano correttamente nella trasmissione dei valori selezioni quindi non riesco a capire cosa accade.

    Allego di seguito il link. Si tratta del campo "CHECK-OUT: EXCLUSIVELY REQUESTED BEFORE 11 am" Anche se la voce viene selezionata dall'elenco poi non viene trasmesso il valore sul Google Sheet.

    Allego lo screenshot Google Sheet.

    Resto in attesa di gentile riscontro,

    Cordialmente

    Alan

    --------------

    Hi, 

    May I please ask you for a help on the issue here under ? 

    I integrated my Jotform with Google Sheet.

    Everything works perfectly except the value of a field "CHECK-OUT: EXCLUSIVELY REQUESTED BEFORE 11 am" whose column in GoogleSheet remains empty for each row. All the other fields work well in the transmission of the selected value and I can't figure out why the error above.

    Please find attached the link below. If the value of the field "CHECK-OUT: EXCLUSIVELY REQUESTED BEFORE 11 am" is selected from the list, the value is not transmitted to the Google Sheet.

    I also attached the Google Sheet screenshot.

    Awaiting for your kind reply,

    Thank you very much in advance 

    Alan




    Jotform Thread 9061633 Screenshot
  • Rhina Jotform Support
    Risposta del 12 novembre 2023 alle ore 20:35

    Hi Alan,

    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. I tested the form through a clone but could not replicate the issue.

    Google Sheet: Some fields are missing on Google Sheet Image 1 Screenshot 20Please note that making changes to the form or google spreadsheet may break the integration. In this case, please try removing the Google Sheet and reintegrating. 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 31

    Now, let's connect the Google Sheets Integration again:

    1. In Form Builder, circle back to Settings at the top of the page.
    2. In the Settings menu, click on the Integrations option and Google Sheets integration again.
    3. Now, select and connect your Google account.

    1648109353 623c27296967e screencast 2022 Screenshot 42

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

    1648109623 623c28372f503 screencast 2022 Screenshot 53

    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. 

  • alangabbai
    Risposta del 13 novembre 2023 alle ore 10:20

    Hi Rhina,

    I have received your message for which I thank you very much. I usually write in English because I generally know it is faster to receive assistance. I can write in English. I followed your information and solve the issue super fast.

    I'll be very carful making changes to google spreadsheet, I understood what can happened.

    Thank you very much again for your very professional assistance

    Alan