Versions Compared

Version Old Version 3 New Version Current
Changes made by

Zoe Baldwin

Zoe Baldwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameactionflow
nopaneltrue

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
    nopaneltrue
  2. On the
    Insert excerpt
    _property_tabs
    _property_tabs
    nameaction
    nopaneltrue
    , Action Settings section, toggle on 
    Insert excerpt
    _toggle_on
    _toggle_on
    nopaneltrue
     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
    nopaneltrue
     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
      nopaneltrue
       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
    nopaneltrue
     all changes

To 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  TipRelational attributes

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

. Adding non-primary table attributes from a related table onto the form will be added as Read-Only by defaultClick outside of the cell to save the changes

when Read Only is disabled.

Insert excerpt
Creating a Grid
Creating a Grid
nameautosave
nopaneltrue

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
    nameaction
    nopaneltrue
    , Action Settings section, if Auto Save has been toggled on, an Auto Save Action Method option appears

  3. Choose 

    Insert excerpt
    _actionflow
    _actionflow
    nopaneltrue

  4. For the Auto Save Actionflow, click the 
    Insert excerpt
    _addIcon
    _addIcon
    nopaneltrue
     icon to create a new Actionflow or click the 
    Insert excerpt
    _actionflow_icon
    _actionflow_icon
    nopaneltrue
     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
      nopaneltrue
       action node

Worked Example

Here's a worked example using the Shop the Retail 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
Tip

If you are completing this chapter as part of the Actionflow course and using a training instance, the data and screens have already been pre-loaded into the Actionflow Intermediate Application. For this example, we'll be working on the grid on the Shop Stock screen.

GIF/SCREENSHOT OF FINISHED RESULT


Excerpt
nameGridEditExample

In-Grid Editing for

Stock

Department 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

On the screen where the Actionflow will be initiated from, Shop Stock, find the area, Split Area Top (use the 

a grid to automatically save changes made directly to the grid.


Image Added

  1. On the Shop Stock screen, open the

    Insert excerpt
    _

layers

  1. action_view
    _

layers

  1. action_view
    nopaneltrue

) to open its propertiesOn a grid, open the view configuration by right-clicking and selecting 

  1.  configuration for the Departments grid

  2. On the
    Insert excerpt
    _property_tabs
    _property_tabs
    nopaneltrue
    , in the View Attributes section, double-click the attribute, departmentName 
    1. In the Grid Settings section, untick Read Only
    2. Insert excerpt
      _
view_show_config_view_show_config
    1. finish
      _finish
      nopaneltrue
             the View Attribute settings
  2. On the
    Insert excerpt
    _action_view
    _action_view
    nopaneltrue
On Click on the
  1.  configuration, click on the
    Insert excerpt
    _property_tabs
    _property_tabs
    nameaction
    nopaneltrue
    , and in the Action Settings section, toggle on 
    Insert excerpt
    _toggle_on
    _toggle_on
    nopaneltrue
     Auto Save
  • 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
    1. Insert excerpt
    _property_tabs
    _property
    1. _
    tabsnopaneltrue and in the View Attributes section, double-click any attributes you want to make editable 
  • In the Grid Settings section for each attribute, untick Read Only
    • Insert excerpt_
    1. save
      _save
      nopaneltrue
       all changes
    2. To test, 
      Insert excerpt
      _lock
      _lock
      nopaneltrue
       the screen and double-click on
    a
    1. an Name 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 default
    1. in the Departments grid, then make a change 

    2. Click outside of the cell to save the

    changeslick 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 Actionflows1.02 Actionflow Principles

    1. change

    Insert excerptCreating a GridCreating a Gridnameautosavenopaneltrue

    Adding an Actionflow

  • 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, c
    1. Expand
      titleCheckpoint

      Image Added


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


    Image Added

    HTML Comment
    hiddentrue

    further reading - creating test data