Training Exercise

You have now learnt how to create and configure Actionflows requiring advanced business logic and can competently use all Actionflow features. To reinforce the techniques you have learnt, complete these assignments.

Don't worry, this is not an exam. You can use the Help to broaden your understanding and assimilate knowledge. A number of hints have been provided; use these if you are struggling as each hint gives you more information on the solution.

A training instance is required to complete these assignments. Use the application: Actionflow Advanced Application.

.Remember to close and reopen your screen if you do not see the changes you expect.

Assignment Hint

You may find it useful to use the debug function within your Expressions to add messages to the System Console.

Assignment 1

Difficulty Level:

Task 1

When deleting rejected companies in bulk, we need to also delete all employees associated with that company from the application.

On the Company Rejected Companies screen, modify the Actionflow that you created in 3.01 Bulk Delete Action Configuration on the Delete All button to also delete all employees associated with the rejected companies

Before starting, roll back and reinstate the data in the Companies, Orders and Order Lines tables, if you have not already.

Hint

Use a Lookup View action to return the Employee IDs.

Hint

Add an Output Attribute to the Calculate action that converts the Employee IDs to structured data.

Hint

Remember to set a filter on the Bulk Delete action containing the criteria of the records to be deleted.

.

Solution

Step 1: Employee Lookup Setup

Step 2: Calculate Action Setup

Step 3: Bulk Delete Employees Setup

Step 4: Mappings - Calculate to Bulk Delete

Task 2

On the Company Approval Review screen, the area holding the icon requires setup to allow companies to be dragged and dropped onto this area and then subsequently rejected.

If you have not already completed the optional example, Example 2: Reject Company Using Drag and Drop on 3.04 Drag and Drop Configuration, configure this now

The Actionflow must:

Set the Company's Status to Rejected
Update the Company's UpdatedByName attribute, using the same syntax as can be seen in the existing data
Update the Company's UpdatedTime attribute

Hint

Revisit the worked example on 3.04 Drag and Drop Configuration to familiarise yourself with the drop target and Actionflow setup.

Solution

Drop Target Setup

Mappings - Drag Type to Input

Mappings - Input to Calculate

Calculate Setup

Mappings - Calculate to Save

Save Setup

Assignment 2

Difficulty Level:

Task 1

When deleting rejected companies in bulk, we need to provide the user with more details, such as counts of the companies, orders and employees that will be affected by the deletion. In addition, we should give the user the ability to cancel or confirm the deletion using this information.

Add the confirmation screen, Company Bulk Delete Confirmation, to the Actionflow on the Delete All button on the Company Rejected Companies screen
In the Actionflow, create counts of the affected companies, orders and employees, and map these onto the screen

Hint

Add a Confirmation Phase before the Processing Phase on the BulkDeleteRejectedCompanies Actionflow.

Hint

In the Confirmation Phase, use Lookup View actions to retrieve the records for the rejected companies.

Hint

Use a Calculate to perform the counts.

Hint

Use a Calculate to create an array (Structured Data) of the rejected Company IDs, which can then be used in the Lookup View action filters to retrieve the orders and employees for the rejected companies only.

Solution

Actionflow Overview and Calculate Action Setup

Rejected Companies - Lookup View Setup

Rejected Orders - Lookup View Setup

Rejected Employees - Lookup View Setup

Mappings - Calculate to Open Screen

Task 2

A number of companies have created webpages on their company website for their employees. The website for the employees is the company website followed by "/employeeportal" .

On the Company Management screen, expand the AdditionalDetails area on the Employees card and find the dynamic text component, Website
This component is backed by the attribute, Website, which is currently empty
On the Company Form screen, add an Actionflow to the Update Employee Website button that updates the Website attribute on the Employee table using a Bulk Update action
Every employee for the selected company should be updated
The syntax for the employee website is CompanyWebsite/employeeportal, e.g. www.phixflow.com/employeeportal

Hint

Use a Calculate action to generate the website.

Hint

Remember to set a filter on the Bulk Update action containing the criteria of the records to be updated.

.

Solution

Actionflow Setup

Mappings - Screen to Input

Mappings - Input to Calculate

Mappings - Calculate to Bulk Update

Bulk Update Setup

Company Management - Screen Setup

.

Assignment 3

Difficulty Level:

Task 1

Additional information about all employees has been made available. We need to make sure it is available across all applications and can be called by external systems.

Set up an API Endpoint that returns all the data from the table, EmployeesAdditionalInformation in JSON format. This table can be found in your application under Tables in the Repository.

On the Company Employee Extra Information screen, create a button that calls the API. The Response from URL can be seen in the System Console.

Optional: If you wish, you can create a screen to display the results.

Hint

Use the JSON script from 3.11 Setting up an API Endpoint to help you write the script for this task.

Hint

On the API Endpoint remember to configure the Output Attributes and the Outgoing Mappings for the lookup.

Hint

On the API Endpoint no filter is needed on the lookup as we want to return all data.

Hint

On the API Endpoint remember to map the constructed JSON attribute to the body attribute on the output.

Hint

Ensure Log Traffic to enabled on the HTTP action on the Actionflow calling the API so that the Response from URL is logged.

Testing Hint

In the System Console, find the Completed Task for the Actionflow calling the API and click on it to view the Messages. Double-click on the Response from URL, then click on Message Detail tab to see the JSON returned.

.

Solution

API Endpoint Setup

API Endpoint Setup - Mappings - Input to Calculate

API Endpoint Setup - Lookup View Setup

API Endpoint Setup - Calculate Setup - Constructed JSON

do(
    // Get the number of companies
    $count = countElements(lu.CompanyID),
     
    //  Create an array with an item for each company
    $countList= [],
    $countList = 1..$count,
     
    //Initiate the output
    $output = '{\n"output":[\n',
     
    // Create the JSON output to be returned by the API
    forEach($var, $countList,
     
        // Get the record details
        $EmployeeID       = getElement(lu.EmployeeID,$var),
        $CompanyID     = getElement(lu.CompanyID, $var),
        $Department     = getElement(lu.Department, $var),
        $start_date     = getElement(lu.start_date, $var),
              
        //Construct the JSON text
        $output = $output +
         
        // Add a tab for the first record's bracket
        if($var == 1, '\t')+
        '{\n'+
        '\t\t"EmployeeID": '  + $EmployeeID + ',\n' +
        '\t\t"CompanyID": '  + $CompanyID + ',\n' +
        '\t\t"Department": "'  + $Department + '",\n' +
        '\t\t"start_date": "'  + $start_date + '",\n' +
        '\n\t}'+
         
        // Add a comma, except for the last record
        if($var != $count, ',')
    ),
     
    // Finalise output
    $output = $output + '\n\t]\n}',
     
     
    // Output
    $output
)

API Endpoint Setup - Mappings - Calculate to View (Incoming)

API Endpoint Setup - Mappings - View to Calculate (Outgoing)

API Endpoint Setup - Mappings - Calculate to Output

Actionflow Setup

Actionflow Setup - Including Optional Screen Display

System Console - Response from URL

Task 2

We need to call the API containing the additional information about employees to obtain their start dates.

On the Company Employee Extra Information screen, add an Actionflow to the Run button that displays Employees from the Employees Additional Information API you set up in Assignment 3, Task 1 above, with an start date between the two set parameters as shown in the drop down fields on the Company Employee Extra Information screen.

Important:

You can either create a new Actionflow or add to the one you made in the task above
Your Actionflow must contain a Loop and loop through each year parameter.

Optional Task: For the purposes of this example we save the data to the table Employee Start Date Analysis but you can use the Employee ID to merge the Start Dates into the Employees table.

Hint

Remember to set up a JSON action on the API endpoint to receive the incoming parameters.

Hint

On the API endpoint, use the incoming parameters to filter the data being returned from the lookup.

Hint

Look at the Actionflow setup on 3.08 Loop Action Configuration to help with setup.

Hint

Use a Calculate to convert the data entering the Actionflow into an integer.

Hint

Rename the From attribute going into the HTTP action to make it easier to distinguish it from the From attribute elsewhere in the Actionflow.

Hint

On the HTTP action, pass in parameters using curly {} brackets.

Hint

On the End Loop action, set the Max Loops to be a sensible number. In this example the maximum number of loops that can occur is 4 as a loop is processed for each date in the drop down field on the Company Employee Extra Information screen (2018-2021).

Solution

The API Endpoint (setup in Task 1) requires a JSON action to allow it to receive parameters that can be used in the lookup filter.

API Endpoint Setup - JSON

API Endpoint Setup - Mappings - Input to JSON

API Endpoint Setup - Mappings - JSON to Calculate

API Endpoint Setup - Mappings - Calculate to View (Incoming)

API Endpoint Setup - View/Lookup

Actionflow Setup

Actionflow Setup - Mappings - Screen to Input

Actionflow Setup - Mappings - Input to 'Convert to Integer' Calculate

Actionflow Setup - 'Convert to Integer' Calculate

Actionflow Setup - Mappings - 'Convert to Integer' Calculate to Loop Start

Actionflow Setup - Mappings - Loop Start to HTTP

The attribute has been renamed on the HTTP side of the Mappings by right-clicking and clicking Edit.

Actionflow Setup - HTTP

Actionflow Setup - Mappings - HTTP to JSON

Actionflow Setup - JSON

Actionflow Setup - Mappings - JSON to Save

Actionflow Setup - Save

Actionflow Setup - Mappings - Save to 'Increment By 1' Calculate

Actionflow Setup - 'Increment By 1' Calculate

Actionflow Setup - Mappings - 'Increment By 1' Calculate to End Loop

Actionflow Setup - End Loop

Actionflow Setup - Mappings - End Loop to Start Loop

Task 3

We need a way to quickly create a number of companies where we have limited information about them, e.g. just their name.

On the Company Management screen, click the Quick Add button to open the Company Quick Add screen
On this screen, add an Actionflow to the Save button, using a For Each action, that allows new companies to be added to the Companies table using just their name
Users should be able to enter a list of company names, separated by a comma
When a record for each company is created, a unique ID number should be generated
Each company's Status should be set to "New" so that they populate the Company Approval Review screen

Hint

Use a Calculate action, to split in the incoming list, by the comma separator, into an array.

Hint

Use the trim function to trim white space on the array values being mapped out of the For Each action. Remember values returned by the Input Expression are available in the Output Attribute's expressions as _result.value.

Hint

Use a Calculate action, to split in the incoming list by the comma separator.

Solution

Actionflow Setup

Mappings - Screen to Input

Calculate Setup

Mappings - Calculate to For Each

For Each Setup

Mappings - For Each to Save

Save Setup

Testing

Ensure you test your Actionflows are working, and where relevant, test for both a positive and negative result.

Once you have verified your Actionflows are working, the screens and data can be modified in any way you wish. For example, you may wish to add additional screens to process the Employees data and practice some of the techniques you have learnt using that data.

3.13 Advanced Actionflows - Training Exercise

Training Exercise

Assignment 1

Task 1

Task 2

Assignment 2

Task 1

Task 2

Assignment 3

Task 1

Task 2

Task 3

Testing