What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Spreadsheet integration - how to change fields order

    Asked by PositusPrimus 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
    JotForm Support

    Answered by Mike_T 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

    Answered by benbennett 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
    JotForm Support

    Answered by Kevin_G 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.