Adding a column to a list

  1. From a list you want to personalize, select Options > Personalize.
  2. On the Column tab, click Add Field.
  3. Specify this information:
    Field
    Specify the column (field) you want to add. If you know business class and field names, begin typing in the field. The field uses an auto-complete feature, which starts searching as you type. It will search for any business class, one to one and one to many fields. Wildcards are not available.

    You must know the source code (LPL) name of the field you are searching for. To get the LPL name of a field, go to the field you want and place your pointer in the field. Press Ctrl + Shift + left-pointer-click. This shows the Field Information window where you can note or copy the field value.

    Label
    Specify the column name to show on the list.
    Sort Order
    Specify the order that data is shown in the column.

    Most of the available sort options here are for highly technical users. As an end-user, you may want to select ByUniqueID, which shows the data in key field order. By default, the sort order is the way in which the data is stored in the database.

    If you make a selection for sort order for an individual field, the individual field's setting will override the default sort order on the list.

    Totaling
    If the column you add is numeric data, you can use this option to calculate the total for data in the list and show it at the end of the list.

    Total: The total of all records

    Running Total: The total at the current point in the records

    Percent of Total: The percent of the total that this set of records represents

    Allow data to be updated in the list
    Select this check box to allow field values to be edited directly from the list.
  4. Click OK.
    The new column is added to the bottom of the list of fields for the list. Reorder the column in the list. Select the new row click Move Up or Move Down or drag and drop it into place.