What is a For Each Action?

Image Added

The 

Insert excerpt
_action_foreach _action_foreach nopanel true

 action iterates over a set of records or list of values, and generates an output record for each one. It is most commonly used to split data, such as an array, into individual records, or it can be used in conjunction with a 

Insert excerpt
_action_calculate _action_calculate nopanel true

 action to firstly convert a user-inputted list into an array for the 

Insert excerpt
_action_for_each _action_for_each nopanel true

 action to process - see worked example below.   

Creating For Each Actions

1. Click and drag the 

   Insert excerpt
   _action_foreach _action_foreach nopanel true

    icon from the toolbar onto the canvas
2. Enter a name in the Create For Each Action window and select Create Action
3. In the 

   Insert excerpt
   _action_foreach _action_foreach nopanel true

    action 

   Insert excerpt
   _property_settings _property_settings nopanel true

    on the right, populate the following:

Worked Example

Here's a worked example using the Company Data (available from the Learning Centre).

In this example, we are using:  

• A Company Merger Pop upFor Each Example screen containing:
  • an input String Field 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 Multi-Tile no Buttons template

Split a List Into Individual Records

In this example, we'll limit the users/user groups that can run the Actionflow that merges two companies togethertake a list of values inputted by a user and convert these into individual records.

gif

Actionflow Setup

For this example, we'll limit permission to run an Actionflow that merges two companies together. This Actionflow was created in 3.04 Bulk Update Action Configuration. If you have not completed this chapter, expand the section below and follow the steps to create the Actionflows.

Create Limited Access User

Testing

1. Log out and login as the user Limited AccessClick the Run Acquisition buttonOpen the Company For Each Example screen
2. Add an

   Insert excerpt
   _actionflow _actionflow nopanel true

    to the Save button
3. Configure the Input as the CompanyForEachExample form
4. Map the attribute Text into the Actionflow

Calculate Action - Convert List to Array

Use the split function in a 

Calculate Action - Create Session ID (Optional)

Create a SessionID attribute in a 

For Each Action - Convert Array to Records

Use a 

1. Create a 

   Insert excerpt
   _action_for_each _action_for_each nopanel true

    action 
   1. Name: Convert to Records
2. Connect it to the Calculate action and map across the Split attribute
3. On the For Each action, enter the following:
   1. Input Expression: in.Split
   2. Input Attributes: Split
   3. Create two Output Attributes: 
      1. Name: Name
         1. Type: String
         2. Expression: trim(_result.value)
            1. The trim function is used here to remove the whitespace after the comma separator in the list
            2. If this was not used and the list "one, two, three" was entered, the records "two" and "three" would be saved with prefixed whitespace
      2. Name: LastUpdated
         1. Type: Datetime
         2. Expression: now()

4. Insert excerpt
   _finish _finish nopanel true

Expand
title Checkpoint
Image Added

Create a Sequence Number for UID (Optional)

Create a Sequence in your application to give each record a unique value. Alternatively, the UID attribute can be left unmapped and PhixFlow will automatically create a unique identifier.

1. Open the 

   Insert excerpt
   _repository _repository nopanel true

    for your application
2. Expand the 

   Insert excerpt
   _sequences _sequences nopanel true

    option, then click 

   Insert excerpt
   _add_icon _add_icon nopanel true

   1. Name: Unique_ID
   2. Start Value: 1
   3. Block Size: 1

3. Insert excerpt
   _finish _finish nopanel true

Image Added

Add the Sequence Number to the UID Attribute (Optional)

Create an Output Attribute, UID, on the

Save Action 

Use a 

Output - Map SessionID Onto Screen (Optional) 

If you have created a SessionID attribute, an output will need to be created to map this value onto the SessionID String Field on the screen, so that it can be used for filtering.

Testing

Image Modified