Selection Grid > Features and Functions

When you need to select a grant, grant application, user or other record from the eGrants database, a selection grid appears.

Selection grids are designed for fast location and retrieval of information.  Follow the instructions below to locate information and select it for viewing or data entry.

Select Entry

To select an entry for viewing or editing, click the Select or Edit icon Description: 00padpencil in its row.

Delete Selection

To delete an entry in a selection grid, click the Delete icon Description: 00x in its row.  Note that the entry is deleted only from the current selection grid and is no longer associated with the current record.  The entry is not removed from the database.

Sort by Column

To change the sort order alphabetically or numerically:

1.       Click any column heading to sort the contents of the grid in order (A-Z, 1-100) of the column. 

2.       Click the column heading a second time to reverse the order (Z-A, 100-1).

Filter Grid Contents

Filter Contents with a Single Column

To display only selected items in the selection grid, use the column filter:

1.       Click the blank field above the column.

2.       Type the word(s) or character(s) you wish to locate.  Note that the filter is case-sensitive.

3.       Click the Filter icon Description: 00filter.  The list displays only records with data fields containing the characters.

Filter Contents with Multiple Columns

To filter the selection grid using multiple columns:

1.       Click a blank field above the column.

2.       Type the word(s) or character(s) you wish to locate.  Note that the filter is case-sensitive.

3.       Click another blank field.

4.       Type the word(s) or character(s) you wish to locate.  Note that the filter is case-sensitive.

5.       Click the Filter icon Description: 00filter in either column.  The list is restricted to display only records containing characters with the combination you entered.

Change the Selection (Page Controls)

Use the page control bar at the bottom of the grid to move among pages of entries.

Description: 11selectiongridcontrols

1.       Click a page number to move to a different page of the grid. 

2.       Click the first page arrow or last page arrow to move quickly to the first |ƒ or last „| page.

3.       Click the arrow keys to move forward „ or backward ƒ a page.

4.       Click the Page size dropdown and click a number to display a different number of records in the grid.

Export Selections to Excel

You can save the contents of the current selection grid as an Excel spreadsheet.  Each column of information is stored as a separate column on the spreadsheet.  Each entry in the grid is stored as a separate row.

1.       Use the Sort or Filter options to display the entries to export.

2.       Click the Export to Excel icon Description: 00exportexcel at the bottom of the selection grid.

3.       The export selection window opens.  Click one of the options to create the spreadsheet.

Open:  Click this option to open the spreadsheet in a new Excel session.

Save / Save As: Click the Save options to save the spreadsheet to a file.  Use the standard Windows Save options to select the folder and enter the file name.

4.       Click OK. 

After you have created the spreadsheet, return to eGrants to continue working.

Export Selections to PDF

You can save the contents of the current selection grid as a read-only PDF file that displays the contents in table format. 

1.       Use the Sort or Filter options to display the entries to export.

2.       Click the Export to PDF icon Description: 00exportpdf at the bottom of the selection grid.

3.       The Adobe Acrobat application opens in the screen.  The current contents of the selection grid are displayed as a PDF file.

4.       Use the standard Adobe controls to view, print or save the file.

5.       Click the Back button on your Internet browser to return to eGrants.

Export Selections to CSV

You can save the contents of the current selection grid as a comma-separated variables (CSV) text file. 

Each row of information is stored as a separate text line.  Each column entry in the row is stored as text, separated by commas:

1.       Use the Sort or Filter options to display the entries to export.

2.       Click the Export to CSV icon Description: 00exportcsv at the bottom of the selection grid.  The export selection window opens.

3.       Click one of the options to create the file.

Open with:  Use the dropdown to select the application for viewing the file.  Click this option to open the file in the selected application.

Save / Save As:  Click the Save options to save the file.  Use the standard Windows Save options to select the folder and enter the file name.

4.       Click OK.

After you have created the file, return to eGrants to continue working.

Export Selections to Microsoft Word

You can save the contents of the current selection grid as a Microsoft Word document file (.DOC). 

The grid and its contents are formatted as a table.  Each column of information is stored as a separate column on the table.  Each entry in the grid is stored as a separate row.

1.       Use the Sort or Filter options to display the entries to export.

2.       Click the Export to Word icon Description: 00exportword at the bottom of the selection grid.  The export selection window opens.

3.       Click one of the options to create the file.

Open:  Click this option to open the document in a new Word session.

Save / Save As:  Click the Save options to save the file.  Use the standard Windows Save options to select the folder and enter the file name.

4.       Click OK.

After you have created the file, return to eGrants to continue working.

 

For more information:

The eGrants Start Page

Main Menu > Features and Functions

Data Entry Windows > Features and Functions

Standard System Icons > Features and Functions

Shortcuts and Special Features