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
Relational 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
Note When a record is being autosaved, double clicking on another record is momentarily disabled.
Adding 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
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 save changes made directly to the data in the grid. On the Shop Stock screen, open the view configuration for the Available Stock gridIn-Grid Editing for Stock Data