Change Grid Column Order

Most form in the system have a Grid tab. It is used for viewing, entering, or editing records in a spreadsheet format. You can change the order of non-key columns can be useful for moving necessary fields to the front of the grid without having to remove columns from the grid.

Note: It is recommended that you do not unlock and move columns in the PR Timecard Entry form.
Warning: When changing the order of columns in the grid, it is important that you do not move columns that are dependent on another column. For example, if a grid contains job-related columns (e.g. JC Co, Job, Phase, and CT), you should not change the order of any of these columns since the Job column depends on the JC Co column, the Phase column depends on the Job column, and the CT column depends on the Phase column. Changing the order of these columns will cause errors when entering data.
  1. Unlock the grid by selecting the Unlock Column Order option in the Columns menu (View > Columns > Unlock Column Order).
  2. Click into the heading of desired column. The cursor changes to a down arrow.
  3. Drag the column to the desired position. Columns moved from the left will be placed to the right of the column on which they are dropped. Columns moved from the right will be placed to the left of the column on which they are dropped.
  4. Once all of the columns are in the desired position, lock them in place by unselecting the Unlock Column Order option (View > Columns > Unlock Column Order).

    To reset the columns to their original order:

  5. Select the Reset Column Order option (View > Columns > Reset Column Order). A message displays asking you to confirm that you would like to reset the column order.
  6. Click Yes to confirm.
  7. To implement your change, select an option in the prompt asking you to reload or cancel.
    • If you elect to reload, the system will automatically shut down the form, and then reload it for you.
    • If you elect to cancel, manually close the form and reopen it to implement the changes.