Versions Compared

Version Old Version 15 New Version 16
Changes made by

Zoe Baldwin

Zoe Baldwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameactionflow
nopaneltrue

 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.  

Tip

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.


Expand
titleAssignment 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
Tip

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


Expand
titleHint

Use a Lookup 

Insert excerpt
_action_view
_action_view
nopaneltrue
 action to return the Employee IDs.


Expand
titleHint

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


Expand
titleHint

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

.

Expand
titleSolution

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.

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


Expand
titleHint

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


Expand
titleSolution

Drop Target Setup

Mappings - Drag Type to Input

Mappings - Input to Calculate

Calculate Setup

Mappings - Calculate to Save

Save Setup


Assignment 2

Difficulty Level: Medium

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
Expand
titleHint

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


Expand
titleHint

In the Confirmation Phase, use Lookup 

Insert excerpt
_action_view
_action_view
nopaneltrue
 actions to retrieve the records for the rejected companies.


Expand
titleHint

Use a 

Insert excerpt
_action_calculate
_action_calculate
nopaneltrue
 to perform the counts.


Expand
titleHint

Use a 

Insert excerpt
_action_calculate
_action_calculate
nopaneltrue
 to create an array (Structured Data) of the rejected Company IDs, which can then be used in the Lookup 
Insert excerpt
_action_view
_action_view
nopaneltrue
 action filters to retrieve the orders and employees for the rejected companies only.


Expand
titleSolution

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 
    Insert excerpt
    _action_bulkupdate
    _action_bulkupdate
    nopaneltrue
     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
Expand
titleHint

Use a 

Insert excerpt
_action_calculate
_action_calculate
nopaneltrue
 action to generate the website.


Expand
titleHint

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

.

Expand
titleSolution

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 as an API.

Set up an 

Insert excerpt
_actionflow_api_endpoint
_actionflow_api_endpoint
nametext
nopaneltrue
that returns all the data from the table, EmployeesAdditionalInformation in JSON format. This table can be found in your application under 
Insert excerpt
_tables
_tables
nopaneltrue
s 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

Insert excerpt
_console
_console
nopaneltrue
.

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

Expand
titleHint

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

Expand
titleHint

On the toJson function in a

Insert excerpt
_actionflowaction_api_endpointcalculate
_actionflow_api_endpointnametextaction_calculate
nopaneltrue
 remember  action to configure the convert the data returned from the lookup to JSON. The syntax is toJson(lookupConnector).


Expand
titleHint

On the 

Insert excerpt
_actionflow_api_endpoint
_actionflow_api_endpoint
nametext
nopaneltrue
 remember to configure the Output Attributes and the Outgoing Mappings for the lookup.


Expand
titleHint

On the 

Insert excerpt
_actionflow_api_endpoint
_actionflow_api_endpoint
nametext
nopaneltrue
 no filter is needed on the lookup as we want to return all data.


Expand
titleHint

On the 

Insert excerpt
_actionflow_api_endpoint
_actionflow_api_endpoint
nametext
nopaneltrue
 remember to map the constructed JSON attribute from the Calculate to the body attribute on the output.


Expand
titleHint

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


Expand
titleTesting Hint

In the

Insert excerpt
_console
_console
nopaneltrue
, 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.

.

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 - Lookup View Setup

Image Added

API Endpoint Setup - Calculate Setup - Constructed JSON

Image Added

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

Image RemovedImage Added

Actionflow Setup - Including Optional Screen Display

System Console - Response from URL

Image RemovedImage Added

Expand
titleSolution

API Endpoint Setup

Image RemovedImage Added

API Endpoint Setup - Mappings - Input to Calculate

API Endpoint Setup - Lookup View Setup

Image Removed

API Endpoint Setup - Calculate Setup - Constructed JSON

Image Removed

Code Block

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 
    Insert excerpt
    _action_loop
    _action_loop
    nameloop
    nopaneltrue
     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.


Expand
titleHint

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


Expand
titleHint

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


Expand
titleHint

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


Expand
titleHint

Use a 

Insert excerpt
_action_calculate
_action_calculate
nopaneltrue
 to convert the data entering the Actionflow into an integer.


Expand
titleHint

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


Expand
titleHint

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


Expand
titleHint

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).


Expand
titleSolution

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

Image Removed

Image Added

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 

Insert excerpt
_edit
_edit
nopaneltrue
. 

Actionflow Setup - HTTP

Actionflow Setup - Mappings -  HTTP to JSON

Actionflow Setup - JSON 

Image RemovedImage Added

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
    Insert excerpt
    _action_for_each
    _action_for_each
    nopaneltrue
     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


Expand
titleHint

Use a 

Insert excerpt
_action_calculate
_action_calculate
nopaneltrue
 action, to split in the incoming list, by the comma separator, into an array. 


Expand
titleHint

Use the trim function to trim white space on the array values being mapped out of the  

Insert excerpt
_action_for_each
_action_for_each
nopaneltrue
 action. Remember values returned by the Input Expression are available in the Output Attribute's expressions as _result.value.


Expand
titleHint

Use a 

Insert excerpt
_action_calculate
_action_calculate
nopaneltrue
 action, to split in the incoming list by the comma separator. 


Expand
titleSolution

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.