Can I set the column/field order of submissions data

  • edustarsas
    Asked 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.

     

  • Charlie
    Replied 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.

  • edustarsas
    Replied 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

  • BJoanna
    Replied on July 24, 2015 at 3: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.