What is In-Grid Editing?

Grids can be configured to allow direct edits to their data, rather than through a separate form or screen.     

Setting up In-Grid Editing

1. On a grid, open the view configuration by right-clicking and selecting 

   Insert excerpt
   _view_show_config _view_show_config nopanel true

2. On the

   Insert excerpt
   _property_tabs _property_tabs name action nopanel true

   , Action Settings section, toggle on 

   Insert excerpt
   _toggle_on _toggle_on nopanel true

    Auto Save
   1. This will automatically save any changes made in the grid, however, it is possible to specify an action that goes beyond a simple save, such as, performing validation of input
3. Click on the

   Insert excerpt
   _property_tabs _property_tabs nopanel true

    and in the View Attributes section, double-click any attributes you want to make editable to open the View Attribute
   1. Alternatively, 

      Insert excerpt
      _finish _finish nopanel true

       the Properties and click the attribute header in the grid to open the View Attribute
4. In the Grid Settings section for each attribute, untick Read Only

5. Insert excerpt
   _save _save nopanel true

    all changes

To test the in-grid editing, double click your data and make a change, then click outside the cell to trigger save. If your data contains relational attributes, these will appear as a drop down list when Read Only is disabled.

Adding an Actionflow to the Auto Save Action

The auto save action can be extended with the addition of an Actionflow.

1. On a grid, open the view configuration
2. On the

   Insert excerpt
   _property_tabs _property_tabs name action nopanel true

   , Action Settings section, if Auto Save has been toggled on, an Auto Save Action Method option appears

3. Choose 

   Insert excerpt
   _actionflow _actionflow nopanel true

4. For the Auto Save Actionflow, click the 

   Insert excerpt
   _addIcon _addIcon nopanel true

    icon to create a new Actionflow or click the 

   Insert excerpt
   _actionflow_icon _actionflow_icon nopanel true

    icon to display a list of available Actionflows
   1. Even though Auto Save has been enabled, the Auto Save Actionflow still requires a 

      Insert excerpt
      _action_save _action_save nopanel true

       action node

Worked Example

Here's a worked example using the Shop Data (available from the Learning Centre).

In this example, we are using:  

• A Shop Stock screen containing a grid of the Shop Stock data, a pie chart of the Shop Stock data and a grid of the Shop Departments data  - this screen was created using the Multi-Tile template

Excerpt
name GridEditExample
In-Grid Editing for Stock Data Configure a grid to automatically save changes made directly to the grid. On the Shop Stock screen, open the Insert excerpt _action_view _action_view nopanel true  configuration for the Departments grid On the Insert excerpt _property_tabs _property_tabs nopanel true , in the View Attributes section, double-click the attribute, departmentName  In the Grid Settings section, untick Read Only Insert excerpt _finish _finish nopanel true  the View Attribute settings On the Insert excerpt _action_view _action_view nopanel true  configuration, click on the Insert excerpt _property_tabs _property_tabs name action nopanel true , and in the Action Settings section, toggle on  Insert excerpt _toggle_on _toggle_on nopanel true  Auto Save Insert excerpt _save _save nopanel true  all changes To test,  Insert excerpt _lock _lock nopanel true  the screen and double-click on an Name cell in the Departments grid, then make a change  Click outside of the cell to save the change Expand title Checkpoint

Note: For a worked example of specifying an Actionflow to be used by the Auto Save, see 2.03 Gateway Action Configuration.