Google Spreadsheet integration - how to change fields order

  • Profile Image
    PositusPrimus
    Asked on February 26, 2013 at 02:24 PM

    I'd like there to be a way to organize the field data "columns" in google drive to be in a certain order.  Im using some hidden fields for some columns.  I currently have the hidden fields at the end of the form - should I insert these hidden fields into the form sequentially where Id like to see them in order or ?  How else might I address this ?

     

    thanks

     

    Steve

  • Profile Image
    Mike_T
    Answered on February 26, 2013 at 03:31 PM

    Thank you for contacting us.

    According to my test it is possible to move the columns on the Google Spreadsheet itself. You will need to integrate your form with the Google Spreadsheet, then open the online Spreadsheet and change the fields order.

     

    Move rows and columns

    Please note that you should not change the column titles, most probably it will break the integration.

  • Profile Image
    benbennett
    Answered on February 22, 2017 at 06:03 AM

    Hi, this seems to work with those forms already submitted, but when you get a new submission it goes into the old format, is there a way of fixing this?

     

    THanks,

  • Profile Image
    Kevin_G
    Answered on February 22, 2017 at 08:12 AM

    I have tested with two different integrations with Google Spreadsheet, through the JotForm's direct integration and through Zapier

    I noticed that the Zapier integration allows you to move the columns and receive the submissions in the same order, so if you have moved it you will still receive properly the submissions. 

    Please, give it a try using this Zap: https://zapier.com/app/editor/template/1927 

    Hope this helps.