4.6.2 Editing Rows in an Interactive Grid

Edit rows of an editable interactive grid with the Row Actions Menu, Edit button, and other functions in the interface.

4.6.2.1 About the Row Actions Menu in an Editable Interactive Grid

The Row Actions Menu appears in editable interactive grids. Users can quickly edit the rows of an editable grid with functions such as adding, duplicating, deleting, refreshing, and reverting rows.

Single Row View

Single Row View changes the grid display to a single-page view of a row’s contents. Used for viewing an individual row in detail, one row at a time.

Available controls include:

  • Report View - Closes the Single Row View and returns to the grid.
  • Change Menu - Displays the options Add Row, Duplicate Row, Delete Row, and Refresh Row.
  • Setting Menu - Enable or disable Exclude Null Values and Display Values settings.
  • Previous and Next- Click the Previous and Next buttons to navigate between rows in the grid.

Add Row

Adds a new row below the current one.

Duplicate Row

Creates a copy of the currently selected row and inserts the copy below the original.

Delete Row

Deletes the current row.

Refresh Row

Reloads the row by calling the database and pulling in any updates.

Note:

Refresh a row to update it without reloading the entire application page.

Revert Changes

Undoes any changes to the row since the grid was last saved.

4.6.2.2 About the Edit Button in an Editable Interactive Grid

The Edit button toggles Editing mode in editable interactive grids. When enabled, you can single-click a cell to edit it; when disabled, you must double-click. While Editing mode enables quicker editing of multiple cells in succession, it can impede navigation in larger grids.

4.6.2.3 Editing a Cell in an Interactive Grid

Double-click a cell in an editable interactive grid to edit the contents.

To edit the contents of a single cell in an editable interactive grid:

  1. Double-click a cell.
    Editing mode engages and a cursor displays in the cell.
  2. Edit the cell contents.
  3. Press Tab or Shift + Tab to edit an adjacent cell in the row or Enter or Shift + Enter to edit an adjacent cell in the column.
  4. To exit editing mode, press Escape.
  5. Click Save to save your changes.
Changes to the interactive grid are saved.

4.6.2.4 Editing Multiple Rows in an Editable Interactive Grid

Select the desired rows of an editable interactive grid to edit, then select an option from the Selection Actions menu.

To edit multiple rows in an editable interactive grid:

  1. Select rows by selecting check boxes in the check box column.

    Tip:

    Click the check box in the column heading to select all rows. With all rows selected, click it again to deselect all rows.
  2. In the column heading of the interactive grid, click the Selection Actions menu icon
  3. Select a valid option. Options include Copy to Clipboard, Duplicate Rows, Delete Rows, Refresh Rows, Revert Changes, Copy Down, Fill, and Clear.
The selected change applies.