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

    Can I set the column/field order of submissions data

    Asked by edustarsas on July 23, 2015 at 10:43 PM

    Hi, 

    I've cloned an existing form and extended it. Both the existing and new form are collecting data from different users. The new form collects more data than the old, but it is inserted (visually at least) between some of the data that is common to the new and old form.

    When submissions are received for the new form the order of the columns/fields seems to be set by the visual order on the form. Is that correct? 

    Is it possible to set the field/column order of submitted data so that I can align the submission data for both forms?

    The purpose of this ordering is to allow for easier data analysis in external tools following export of the submissions from both forms.

     

    Submissions new form different external tools
  • Profile Image
    JotForm Support

    Answered by Charlie on July 24, 2015 at 12:42 AM

    Hi,

    I'm having quite a hard time visualizing your workflow process. Could you kindly give us more information?

    If I understand it correctly, you would like to change the order of the form fields in your form? You can do that by opening the form in the form builder and edit it, you can drag drag and drop or follow this guide on how to position fields: http://www.jotform.com/help/90-Form-Field-Positioning.

    For data analysis, you might also want to integrate your form to Google spreadsheet. You can also check our tools in the Apps page for data management and analytics/reporting.

    I hope that somehow this helps. Do let us know if you need more information on this.

  • Profile Image

    Answered by edustarsas on July 24, 2015 at 12:52 AM

    Charlie - sorry it isn't clear. Let me try again.

    When exporting submissions into a CSV or Excel file the order of the columns appears to be fixed and to have a relationship to the position of the fields in the form (i.e. left most column in data is the top most field in the form).

    Is there a way to change the order of the columns without changing the order that the fields appear within the form? 

    Regards

    Simon

  • Profile Image
    JotForm Support

    Answered by BJoanna on July 24, 2015 at 03:55 AM

    Unfortunately that is not possible to achieve inside of JotForm. 

    However when you export your submissions  into Excel you can change manually the order of the columns.

    http://www.extendoffice.com/documents/excel/590-excel-swap-rows-or-columns.html 

    Hope this will help. Let us know if you need further assistance.