What is a Loop Action?
The Bulk Update action updates re
Creating Bulk Update Actions
- Click the Bulk Update icon in the toolbar to display any existing tables in the application
- Existing tables can be dragged from the Repository onto the canvas, then choose Bulk Update to create a Bulk Update node
- Alternatively, drag the Bulk Update icon from the toolbar onto the canvas
- In the Create Bulk Update Action window:
- Enter a Name
- Choose to Allow Audited Table to display tables with Audit Manual Changes enabled in the Table drop down
- By default, tables with Audit Manual Changes enabled are not shown in the Table drop down list
- Choose the Table from the drop down where the records will be updated
- Or click the table icon to display tables in the Repository
- Select Create Action
When creating update actions it can be useful to set up confirmation messages that allow users to confirm or cancel the update. See 1.13 Confirmation Message Configuration.
Worked Example
Here's a worked example using the Company Data (available from the Learning Centre).
In this example, we are using:
- A Company Management screen containing a grid of the Companies data and a card container of their associated Employees - this screen was created using the Multi-Tile template
- A Company Merger Pop up screen containing:
- two manual drop down fields of the company name's of the companies to be merged
- two string fields showing the company ID's of the companies to be merged
- a button to initiate the Actionflow - this screen was created using the Tile no Buttons template
- A Company Orders screen containing two grids of the Orders and OrderLines 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 Advanced Application. For this example, we'll be working on the Company Management screen.
Bulk Update Employees and Orders for Company Acquisition
In this example, a company is being merged into another company and we need to update the employees and orders to reflect the change.
GIF
Actionflow Setup
- Open the Company Management screen
- Click the Merge button to open the Company Merger Pop up screen
- Create an Actionflow on the Run Acquisition button
- Name:
RunCompanyAcquisition
- Name:
- On the Actionflow canvas,
Testing
- Close all screens and reopen the Company Management screen
- Choose two companies to merge and make a note of their employees so you can see if the merge is successful
- Open the Company Orders screen and make a note of any Orders and Order Lines for the two companies
- On the Company Management screen, click the Merge button to open the Company Merger Pop up screen
- Select the two companies to merge and click the Run Acquisition button
- Review the screens to check the merge was successful