De integratie met Google Spreadsheets werkt niet zoals verwacht na het toevoegen van een veld aan Google Spreadsheets.

Betreft het formulier: Woonwaard

Ik heb de integratie met het Google docs document vorige week aangepast omdat ik een extra veld aan gegevens zichtbaar wilde hebben in Google docs. Sindsdien zijn er al twee formulieren niet goed overgekomen.

Ik tref onderstaande foutmeldingen aan. Wat betekent dit en hoe kunnen we dit voor toekomstige formulieren voorkomen?

Hi Budget_Broodjes,

Thanks for reaching out to Jotform Support. Our Dutch 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 Dutch, 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, the integration expects the original column structure, so any changes to column names or order may cause errors. To fix this, you just need to remove the integration, then add it back. It's easy to re-integrate the Google Sheet integration. 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.