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.
Google Spreadsheet integration - how to change fields orderAsked 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 ?
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.
Please note that you should not change the column titles, most probably it will break the integration.
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?
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.