< back

Universal Table Controls for Editing Data

Return to: Data Tables.

The following functions will be available as appropriate for Data table content.

Return to: *Data Tables.

Edit a Record

Click the button next to the record you want to edit and activate the row. Upon activation, all changes can be made directly in the table. Click the green check icon to save the updates.

Add a Record

Click the Add New link located at the bottom of the table. Enter the new data table records into the newly created row. Click the green check icon.

Delete a Record

Click the delete button next to the record to be deleted. A confirmation box will appear. Click OK to complete the deletion, or Cancel to go back to the table view without deleting the record.

Customize the Fields Viewed

You can choose which fields to display on the screen in each table. By doing so, you can hide fields that are unused or not relevant to your organization, and focusing on the important fields.

Click Custom View. An edit window will appear, displaying all available fields for the current table. Check off the fields you wish to display, and click Save. You can check all or uncheck all fields by clicking Select All or Unselect All. Clicking Reset will restore and save the default selections for that table.

Navigate through Table Records

Many tables will contain more records than BALANCEaap can easily display on one screen. In these cases, the records will be sorted by pages.

The number of records displayed per page can be selected from the Records per page drop-down list. Please note that the more records displayed per page, the longer it will take the page to load.

You can move through the pages sequentially by clicking the arrow buttons, or jump to a specific page by clicking the page number. Clicking the double arrow buttons will skip to the first or last page.

Sort Records

The order in which the records appear can be changed by sorting by any column. Click the column header for a column, and the records will sort in ascending order by that column. Click the header again, and the records will sort in descending order. An arrow will appear next to the column header to indicate that sorting is being done by that column, and the arrow’s direction will indicate if the sort is ascending or descending.

Search

If sorting and navigating through the pages does not allow you to find a desired record easily, you can search for that record. Enter text to search by in the Filter field, and click Search. Try to be as specific as possible. Any record that matches the search criteria in any field will be displayed. Records that do not match the search will be hidden.

To clear the filter and display all records again, click Clear.