1 Reply Latest reply on Feb 15, 2017 3:15 PM by beverly

    order of columns when exporting to excel

    perjonas

      For FM12, when exporting a preview of a layout to excel, what governs the order  of which field goes in to which column. Is there anyway one can control which field goes in to which column?

        • 1. Re: order of columns when exporting to excel
          beverly

          EXPORT does give you a dialog to choose the fields (in any order).

           

          Send/Save Records (as Excel) does not have a dialog. However, if you switch to Table View, you can arrange the columns as needed (even add or hide columns!) This will not affect the Form view. Just click the "Modify" in the right of the Status area (while in Table View), and arrange or add/remove. When you then Send/Save Records (as Excel), you will get the same order as the Table view. This is the easiest way.

           

          beverly

          1 of 1 people found this helpful