Google Sheets integration: I added new fields and want to reorder columns in Google Sheets without changing the Sheets URL.

mtl_tech_admin
Asked on June 02, 2021 at 05:00 PM

I have had to add fields to a published form. In our Google Sheet integration, the new fields added have been added as columns after the originally published form fields.
How can I retain the current Google Sheet URL, but reorder the columns to reflect the new fields and where they are inserted?
Thanks, Peter

This is a re-post of a comment on How to Integrate Forms with Google Sheets
Laura

Jotform Support

Answered on June 02, 2021 at 11:24 PM

Hi Peter,

Unfortunately, we do not recommend making changes to the sheets and columns, as in some cases this might cause conflicts with the integration.

We would suggest creating a new sheet instead within the same spreadsheet file, and then replicate the data to the new sheet. On the new sheet, you can order the columns to your liking.
Please see the guide below for more details:
https://support.google.com/docs/answer/75943?co=GENIE.Platform%3DDesktop&hl=en

Another option would be to re-integrate the integration by removing and adding it, but this way you will also lose the current sheet URL.

Let us know if you need further assistance.