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
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.
Note When a record is being autosaved, double clicking on another record is momentarily disabled.
Adding an Actionflow to the Auto Save Action
Auto save can extended with the addition of an Actionflow.
- 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
- Even though Auto Save has been enabled, the Auto Save Actionflow still requires a Save 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
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.