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 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 changesTo test,  Insert excerpt_lock_locknopaneltrue the screen and double-click on a cell for the attribute you modified - the cell can be typed into and changed 

Adding 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

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

GIF/SCREENSHOT OF FINISHED RESULT

In-Grid Editing for Stock Data

Configure an area to open a screen on clicking.

ZB MY NOTES, DELETE: AUTOSAVE AND READ ONLY REMOVE FROM ATTRIBUTE 'ITEM TYPE'. ADD ACTIONFLOW TO CHECK FOR NUMBERS, FIELD ONLY ALLOWS STRINGS

a grid to save changes made directly to the data in the grid.

1. On the Shop Stock screen, open the view configuration for the Available Stock grid

2. On the

   Insert excerpt
   _

   layers

   property_tabs _property_

   layers

   tabs nopanel true

   ) to open its propertiesOn a grid, open the view configuration by right-clicking and selecting  Insert excerpt_view_show_config_view_show_confignopaneltrueOn  in the View Attributes section, double-click the attribute, itemType 
   1. In the Grid Settings section, untick Read Only
   2. Click 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
   3. 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
   Click on the Insert excerpt_property_tabs_property_tabsnopaneltrue and in the View Attributes section, double-click any attributes you want to make editable 
   4. In the Grid Settings section for each attribute, untick Read Only

3. Insert excerpt
   _save _save nopanel true

    all changes
4. To test, 

   Insert excerpt
   _lock _lock nopanel true

    the screen and double-click on a cell for the attribute you modified - the cell can be typed into and changed  TipRelational attributes will appear as a drop down list. Adding non-primary table attributes from a related table onto the form will be added as Read-Only by defaultan Item Type cell, then type into the cell 
5. Click outside of the cell to save the changes Insert excerptCreating a GridCreating a Gridnameautosavenopaneltrue

   Adding an Actionflow

6. On a grid, open the view configuration
On the Insert excerpt_property_tabs_property_tabsnameactionnopaneltrue, Action Settings section, if Auto Save has been toggled on, an Auto Save Action Method option appearsChoose  Insert excerpt_actionflow_actionflownopaneltrueFor the Auto Save Actionflow, click the  Insert excerpt_addIcon_addIconnopaneltrue icon to create a new Actionflow or click the  Insert excerpt_actionflow_icon_actionflow_iconnopaneltrue icon to display a list of available Actionflowschange

1.02 Actionflow Principles