Open

Lookups are denoted by a dotted double-ended connector transferring data into and out of a 

• Request (Incoming) Mappings: the attributes being passed into the View Action via the lookup connector

• Output Attributes: the attributes being used by View Action to filter results

• Return (Outgoing) Mappings: the attributes being passed out of the View Action via the lookup connector 

For the full list of View action

For more information on views, see View Action Configuration.

1. Hover over an action node, e.g. a Calculate Action, on the canvas and select 

   Open

   

2. Enter a name for the Lookup Connector

3. Click onto a 

    action on the canvas

4. Alternatively, click onto any empty space on the canvas to create a new 

    Action

Lookups are useful in many scenarios.

Solution: See how-to guide, Lookups with Dynamic Parameters.

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

In this example, we are using:

• A Classroom Management screen  - this screen was created using the Tile with Buttons template, and contains:

  • A basic card container of the Classroom data

  • A basic card container of the Courses data

  • An empty string field, FilterField

In this example, we want to see the courses held in each classroom when each classroom is clicked. To do this, we will use the classroom data to lookup and retrieve the associated courses data, then output that data back to the screen where it can be used to filter the courses data.

Open

To do this it we will:

• Lookup the courses using the Classroom ID, which is found on both the Classroom and Course tables

• Write those courses' Course ID(s) back to the screen onto a string field

• Setup a background filter to only show courses in a Courses card container that match the Course ID in the field

Event handlers facilitate actions occurring in response to a user action. For this example, we want a user clicking on a classroom card to run an Actionflow that populates a string field that we will later to use to filter the information that can be seen on screen

1.  Click on the top card on the Classroom Management screen to open the 

   for the area, Card (under Classrooms)

2. Click on the 

3. Click the 

    icon in the Event Handler section

4. In the New Card (On Click) Event Handler tab, click 

   1. Enter a name for the Actionflow:

      1. Name: Filter Courses

Open

1. Select Click to Connect and for the input, choose the Classrooms Card Component, then select Connect Input   

2. In the Mappings window that opens, drag the ClassroomID attribute from the left to the right

   1. Select Save

3. Click and drag the 

    icon from the toolbar onto the canvas

4. In the Create Calculate Action window enter:

   1. Name: GetCourses

   2. Select Create Action

      For the input data, the attributes pass through the Calculate action without being processed. For the output data, the Calculate action processes the data into an array. 

5. Click and drag the 

    icon onto the 
    action node

6. Right-click on the in connector and choose

   1. Drag the ClassroomID attribute on the left onto the Drag and Drop area on the right

   2. Select Save

7. To look up to the School_Courses table, hover over the 

    action node and choose, Add Lookup

   1. On the Add Connection Point window, name the lookup: luc

      1. We recommend choosing a name to indicate the action taking place, e.g. "luc" for look up courses

   2. Click Confirm

8. With the red arrow attached to your mouse, click anywhere on the canvas

9. In the Create View Action window enter:

   1. Name: Courses

   2. Primary Table: choose School_Course 

   3. Select Create Action

1. The Output Attribute Selection window will open automatically 

   1. Click the tick box next to CourseID

   2. Drag it into the Output Attributes in the Properties

   3. Click Next

2. The Request (Incoming) Mappings window will open automatically

   1. Drag the ClassroomID attribute from the left (Calculate Action) into the Drag and Drop area on the right to create a corresponding attribute in the 

       action

   2. Select Next

3. The Return (Outgoing) Mappings window will open automatically

   1. Drag the CourseID attribute from the left (View Action) to the Drag and Drop area on the right to map a corresponding attribute back to the

       action
      1. Open

         

   2. Click Confirm and Create Filter

4. We need to filter the data coming out of the lookup 

   1. Name: ByClassroomID

   2. Click abc to tell PhixFlow to interpret the field as an expression

   3. Filter Conditions: 

   4. Select Finish

Open

1. Click on the

    action on the canvas to open its

2. In the Output Attributes section, click the 

    icon to create a new attribute:

   1. Name: CourseIDArray

   2. Type: Choose Structured Data   

      1. This will return the results as an array

   3. Expression: 

      luc.CourseID

   4. Click 

3. Under Connections on the left, select 

    Add

4. Add an Output Connection Point:

   1. Name: output

   2. Type: choose Output

   3. Click Create Connection Point

5. In the Connect Output window, choose the ClassroomAvailabilityManagement 

   , then Connect Output

   1. Close the Mappings window that opens as we don't have any attributes to map to this yet

6. Hover your mouse over the

    action on the canvas and click out

7. When the red arrow shows, click on the 

    node under Connections

   1. On the Mappings window, drag across the CourseIDArray attribute from the Calculate action into the Drag and Drop area on the right to create a corresponding attribute on the output

   2. Click Save

8. Click the output connection point, under Connections

   1. On the Mappings window, drag the CourseIDArray attribute from the output to the string field, FilterField

   2. Click Save

9. The Actionflow is now built

Open

The Event Handler and Actionflow will now populate the string field, FilterField, by clicking each classroom card, but the Courses card container needs a background filter setting so it can be filtered by the values in the string field.

1. Return to the Classroom Management screen 

2. Click on the Courses card container to open the Card Component 

    

   1. Ensure you click on the white space underneath the top contact card to open the Card Component

3. On the 

   , in the Background Filter Rules section, click 

   1. Enter the Rule Expression: true

4. Create a new filter by pressing 

    next to Filter:

   1. Name: ByFilterField

   2. In the Filter Details section, click Select an option and choose the CourseID in the Table Attributes

   3. Filter Details: 

      Open

      

   1. Click 

       on both the Filter and Filter Rule 

5.  the screen and click a classroom card to see the Actionflow working

Having trouble? See Troubleshooting above.