Google Sheet: Newly Added Fields Does Not Show at Their Correct Position

Dear JotForm Support Team,

I have integrated one of my forms with Google Sheets. Recently, I made some corrections and added new fields in my form. However, I noticed that whenever I add a new field, it always appears at the last column of the integrated Google Sheet, regardless of where I placed the field in the actual form.

Ideally, I would like the newly added fields to appear in the same position in the Google Sheet as per their placement in the form (for example, between existing fields), instead of always being added at the end.

Can you please guide me:

• Is there a way to maintain the field order in the Google Sheet as per the form layout?
• Or is there any workaround or re-integration process that helps?

Looking forward to your guidance.

Hi Airr,

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

Regarding your Google Sheets integration issue, when you add new fields to your form, they will appear as the last column in the integrated Google Sheet by default. Unfortunately, there is no direct way to maintain the exact field order in Google Sheets as per the form layout.

However, here’s what you can do:

1. Remove the current integration: In Form Builder, go to Settings > Integrations, select Google Sheets, and remove the integration.
2. Reintegrate the form: Set up the integration again following the standard process to sync your form fields with the sheet.
3. Manually reorder columns: After integration, you can manually rearrange columns in Google Sheets if needed, but be cautious as renaming or moving columns may break the integration.

Keep in mind that changes in Google Sheets do not affect your form entries, and renaming columns can cause issues with the integration.

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

Let us know if you have any other questions.

Best regards,
Jotform Support

Hi airrnewsindia,

When you add new fields to your form, Google Sheets integration will by default add these new fields as the last column in the spreadsheet. Unfortunately, there is no direct way to maintain the exact field order in Google Sheets as per the form layout.

You can remove the integration and set it up again so the new sheet will show the correct order of the fields. 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.