Falha na integração com o Planilhas Google

Olá boa tarde,

Sou o Igor Analista de TI da Bonsucesso Textil e estou com um problema de sincronização de um jotform para uma planilha do google.

BS FO QUA 056 - NOTIFICAÇÃO DE DESVIO DE PARAMETRO rev01

Esse é o Jotform que vem apresentando problemas

já foram feitos:

Mas na nossa planilha do Google destino parou nessa numeração:

Preciso de um auxilio para incluir esses formulários nessa planilha, conseguem me ajudar com esse problema ?

E-mail: igor.sarvasi@bsstex.com.br

Whatsapp (19)3515-6694

Hi Igor,

Thanks for reaching out to Jotform Support. Our Portuguese Support agents are busy helping other Jotform users right now, so 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, it might take a while until they're available again.

Now, coming back to your question, based on your screenshot, it seems that the integrated sheet has been modified. Unfortunately, doing modifications on the integrated sheet or in the form itself can cause the integration to break. If you want to modify the sheet, you can instead use the IMPORTRANGE function, as it allows you to create a live copy of the integrated sheet that you can edit freely.

To fix the Google Sheet integration, you will have to re-integrated it. First, we’ll remove the existing Action. Let me show you how to do it:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. In the menu on the left, click on Integrations and select the Google Sheets integration.
3. Then, hover over the Action section and click on the Three Dots icon.
4. In the dropdown menu, select Delete Action, and in the window that opens click on Yes, Discard.

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

1. While in Google Sheet Integration settings, click on the Add New Action button.
2. Now, select an action and click on Next.
3. Then, click on Add Action and customize settings as you want.
4. Once you finish customizing, click on the Save button at the bottom right of the settings.

If you select Create new spreadsheet, a new spreadsheet will be created in your Google account, where submissions will be collected. If you select Use existing spreadsheet, submissions will be collected in the spreadsheet you choose, which is already connected to your Google account. We also have a guide about How to Integrate Forms With Google Sheets that you can check out.

Reach out again if you need any more help.