Inserting and Manipulating Grid Columns

Inserting Grid Columns

To insert a grid column:

Use one of these methods to insert a column:
- Select a page control from the Insert menu or the page control toolbar and click the grid.
- Drag a page field from inside the current page or from another page.
- Copy and paste a page field or record field.
- Drag a definition (such as a record field, a page field, or an entire record definition) from the project workspace.
  
  The new location of the definition or control is determined by the location of the upper left-hand corner of the drag rectangle, or by the mouse cursor if no drag rectangle appears. PeopleSoft Application Designer automatically places the first column on the left-hand side of the grid.
Click your mouse or release the field in the gray area of the grid.

Place new columns to the right of existing columns by clicking or releasing the control in the gray area of the grid where no columns are present. To place a column between two grid columns, release the new column in the first of the two columns.

When inserting subpages into your grid as a column, be aware that:

You can insert subpages by dragging them from the project workspace or by cutting and pasting from the page to the grid.
Only one column displays in the grid in PeopleSoft Application Designer representing all fields in the subpage.

At runtime, all fields display in the order they appear on the Order tab of the subpage.
You cannot insert subpages that contain fields that are not allowed in grids such as static text or radio buttons.

The system generates an error indicating the invalid field type. Similarly, if at a later point an invalid field type is added to a subpage already in a grid, the system generates a runtime error when the user accesses the page containing the subpage.
The subpage you insert can contain fields that are associated with subrecord record fields.

The same record name substitution mechanism that applies to subpages inserted onto a page applies to those inserted as grid columns. The system replaces the name of the subrecord as part of the expansion process and it is never seen at runtime.

See Understanding Subpages.

Note:

The rich text editor is not supported within grids. If you insert a long edit box and make it rich text-enabled, the system automatically sets the long edit box Use properties to Display Only. (Use tab > Field Use Options > Display Only.)

Note:

Long edit boxes inserted into grids and set to display only always display the field content in expanded mode, regardless of how the Expand Field When Display Only option is set. (Use tab > Field Use Options > Expand Field When Display Only.)

Deleting Grid Columns

To delete a grid column:

Select a column by right-clicking the column heading.

Be sure that you select only the column and not the grid as a whole; otherwise, you might delete the entire grid instead of just the column. The grid is selected when control boxes appear around the edges of the grid. The column is selected when it turns black.
Select Delete from the pop-up menu.

Moving Grid Columns on the Layout Tab

To move grid columns on the Layout tab:

Select a column by clicking the column heading.
Drag the column to its new location.
Release the mouse button over the column that is to the left of the new location.

Moving Grid Columns on the Order Tab

To move grid columns on the Order tab:

Select the column row by clicking the row number.

The grid and grid columns are clearly distinguished from other page fields on your page. The grid is identified by the Type column. All columns in the grid are directly below in a lighter green. Other page field rows are white.
Drag the row to the new position in the grid.

A red line indicates the new position of the column before you release it. You cannot move a column outside of the grid when working on the Order tab. Similarly, you cannot move an existing page field from elsewhere on the page into the grid. Both of these operations can be performed on the Layout tab.

Resizing Grid Columns

You can resize grid columns in PeopleSoft Application Designer by dragging the right border of the column heading.