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
- On a grid, open the view configuration by right-clicking and selecting Show the View Configuration
- On the Actions tab, Action Settings section, toggle on 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
- Click on the Properties tab and in the View Attributes section, double-click any attributes you want to make editable to open the View Attribute
- Alternatively, Apply and Close the Properties and click the attribute header in the grid to open the View Attribute
- In the Grid Settings section for each attribute, untick Read Only
- Apply all changes
- must click outside cell to trigger save - test if this is another row or can be area?
- double clciking into another cell is disabled at this point
Relational attributes will appear as a drop down list when Read Only is unticked.
remove 2 coloured boxes
Note When a record is being autosaved, double clicking on another record is momentarily disabled.
Adding an Actionflow to the auto save
Auto save can extended with the additon of an acitionflow. replaces save - make clear. requires save node
- On a grid, open the view configuration
- On the Actions tab, Action Settings section, if Auto Save has been toggled on, an Auto Save Action Method option appears
Choose Actionflow
- For the Auto Save Actionflow, click the icon to create a new Actionflow or click the 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
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 Configure a grid to automatically save changes made directly to the data in a grid. On the Shop Stock screen, open the view configuration for the Available Stock gridIn-Grid Editing for Stock Data
Note: For a worked example of specifying an actionflow to be used by the Auto Save, see 2.03 Gateway Action Configuration.
further reading - creating test data