Using PeopleSoft Grids



  1. On some pages, you may want some of the fields to repeat in order to enter multiple rows of data. For this purpose, PeopleSoft uses grids. With grids, you have the ability to add, edit, and view multiple occurrences of data for a group of fields on one page.


    The Emergency Contact Other Phones page in the Emergency Contacts component contains a grid area.

    Step 1
  2. Instead of using a traditional scroll bar to scroll through the rows of data in a grid, PeopleSoft uses navigation buttons and hyperlinks. Most often, you will find these buttons and hyperlinks in the navigation header for each area, with the exception of the Insert Row and Delete Row buttons.

    Step 2
  3. Use the Find link to find a specific row of data.

    Step 3
  4. Use the View All link to display all rows of data on a page. When this feature is enabled, the link changes to read View 1, so that you can return to the original setting.

    Step 4
  5. The First link takes you to the first row of data.

    Step 5
  6. Use the Previous Row arrow to navigate to the previous row of data.

    Step 6
  7. The number system for the rows shows the number of rows you are currently viewing.

    Step 7
  8. Use the Next Row arrow to navigate to the next row of data.

    Step 8
  9. The Last link takes you to the last row of data.

    Step 9
  10. The Add Row button inserts a new row of data.

    Step 10
  11. The Delete Row button deletes the current row of data.

    Step 11
  12. Grids look similar to a spreadsheet with column headings, rows, and cells. The cells are equivalent to fields. Fields within a grid may be represented as edit boxes, drop-down list boxes, check boxes, and radio or prompt buttons.

    Step 12
  13. Rows of data in grids and scroll areas alike always share the same high-level key(s). For example, for the Emergency Contact Other Phones page, you can have multiple rows for the different phone types. If you have multiple rows, each of these rows has the same Person ID as the key field. If you insert a new row, the system automatically copies the shared key data into the new row.

    Step 13
  14. Another type of grid is a tabbed grid. These grids provide a means of viewing multiple columns of information without having a horizontal scroll to view them.


    The Quick Enrollment component has a tabbed grid section. You select a tab to view the additional columns.


    Click the Units and Grade tab.

    Step 14
  15. Notice that different columns are displayed.


    Click the Class Enrollment tab.

    Step 15
  16. Some tabbed grids have a button that can be used to expand the grid columns to the right so that tabs are no longer needed.


    Click the Show Columns button.

    Step 16
  17. You can return to the tabbed view if desired.


    Click the Show Tabs button.

    Step 17
  18. To add a new row of data to a grid, you click the Add Row button to insert a row just below the row you are on. Each time you add a new row, you are actually adding a new row of data to the database table.


    Click the Add Row button.

    Step 18
  19. A new row is now available.


    If you want to delete a row, you click the Delete Row button.


    Click the Delete Row button.

    Step 19
  20. The system displays a confirmation message asking if you want to proceed with the deletion. It also reminds you that the row will not be deleted from the database until a save occurs; however, the row is automatically removed from the grid.


    Click the OK button.

    Step 20
  21. To get the row to return, you can click the browser's Back button or close the transaction without saving your changes. If you close without saving, any other changes you made are not saved as well.


    Click the Back button.

    Step 21
  22. The second row has now returned to the grid.

    Step 22

In summary, PeopleSoft's grid area navigation structure makes it easy to work with multiple rows of data.

Table of Contents  Start Topic