Google Sheets: Fields are in different order

I cloned last years form and had to add questions throughout the form and it now the additional answers are showing at the end of the google sheet whereas we want them in the order they are on the form.

Hi Prue,

Thanks for reaching out to us for help. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

When you integrate your Jotform with Google Sheets, the fields are sent to the spreadsheet in the order they appear on the form at the time of integration. If you add new questions throughout the form after cloning, those new fields may appear at the end of the Google Sheet because the integration maps fields based on when they were added.

To have the fields appear in the desired order in Google Sheets, you may need to redo the integration after finalizing your form's questions. This will refresh the field mapping and reflect the current order of the form fields in the spreadsheet.

Here’s how to do it:

1. Go to Settings in your form builder.
2. Select Integrations and find Google Sheets.
3. Remove the current integration and then set it up again with the updated form.

This will create a new spreadsheet or worksheet with the fields in the correct order as they appear on your form.

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

Hi Prue,

By default, questions are sent to Google Sheets based on their order in your form. If your integration is having an issue with the order of the field and columns, I suggest re-integrating your form with Google Sheets.

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.