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 2, 2021 at 5: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

  • Laura JotForm Support
    Replied on June 2, 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.