Google Sheets Integration: Responses are loaded in the Title/Header of Spreadsheet

  • Climate_Ventures
    Perguntado em 21 de setembro de 2023 às 10:09

    Olá,


    Várias respostas do formulário "Pré-cadastro na Plataforma Onda Verde" estão sendo carregadas na linha de título dos campos. Com isso, muitas respostas não computadas e a planilha fica completamente bagunçada.


    Poderiam verificar, por favor?

    Segue imagem, com a primeira linha, destinada a título dos campos, destacada com o erro descrito:


    Google Sheets Integration: Responses are loaded in the Title/Header of Spreadsheet Image 1 Screenshot 20

  • Leonidas Jotform Support
    Respondido em 21 de setembro de 2023 às 13:33

    Hello Climate_Ventures,

    Thanks for reaching out to Jotform Support. Unfortunately, our Portuguese 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 Portuguese, 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 cloned and tested your form to see if I could replicate the issue, however, the form is working as it should. The responses are not loaded on the Header of the spreadsheet. Take a look at the screencast below:

    Google Sheets Integration: Responses are loaded in the Title/Header of Spreadsheet Image 1 Screenshot 30

    Can you please remove the current Google Sheets integration and add it back? Here's how:

    Google Sheets Integration: Responses are loaded in the Title/Header of Spreadsheet Image 2 Screenshot 41

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

  • Climate_Ventures
    Respondido em 22 de setembro de 2023 às 11:00

    thank you for the reply. However, this behaviour does not happen everytime, its quite random. It happened with around 10 submissions, I dont know what triggers it. I've redone the integration and I'll let you know if it happens again.