Open

The 

Note: Delete actions will only delete records in tables with the Period of Transactional. 

For the full list of Delete action

1. Click the 

    icon in the toolbar to display any existing tables in the application

   1. Existing tables can be dragged from the Repository onto the canvas, then choose 

      to create a Delete node

2. Alternatively, drag the 

    icon from the toolbar onto the canvas

3. In the Create Delete Action window:

   1. Enter a name

   2. Choose the Table from the drop down where the records will be deleted

   3. Select Create Action

These settings are in addition to the steps above.

When creating delete actions it can be useful to set up confirmation messages that allow users to confirm or cancel the deletion. See Confirmation Message Configuration and Custom Confirmation Message Configuration.

Worked Examples

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

In this example, we are using:

• A Course Management screen containing a grid of the School Courses data - this screen was created using the Tile with Buttons template

• A Course Form screen containing form fields and associated with School Courses data by a background filter - this screen was created using the Edit Form template

We want to be able to delete courses on a Course Management screen, using the delete button on the Course Management screen and on the Course Form screen. To do this, we will creating two Delete Actionflows. Both will delete the selected record.

Create a Delete Action to delete courses in the School Courses grid on the Course Management screen.

Open

1. On the Course Management screen, right-click on the 

   Open

   

    button and choose 

2. Enter a name for the Actionflow,

   1. Name: Delete Course (Course Grid)

   2. Select Confirm

3. Select Click to Connect under Connections and for the input, choose the School Courses 

    View Component, then select Connect Input

4. In the Mappings window that opens, notice that by default the data being used is the selected record

   1. Drag the CourseID attribute from the left (School Courses Grid) into the Drag and Drop area on the right (Input Connection Point)

   2. Open

      

       

   3. Select Save

5. Click and drag the 

    icon from the toolbar onto the canvas

6. In the Create Delete Action window enter:

   1. Name: DeleteCourse

   2. Table: choose School Courses

   3. Select Create Action

7. Click and drag the 

    icon onto the 
    action node on the canvas

8. Right-click on the in connector and choose

   1. Select Map by Name to map the CourseID attribute on the left onto the CourseID attribute on the right

   2. Select Save
      
      Checkpoint
      

9. Close the Actionflow to return to the Course Management screen

10.  the screen and select a record in the grid, then press the 
    Open

    

     button

Create a Delete Action to delete courses in the School Courses grid on the Course Form screen.

Open

1. On the Course Management screen, select the 

   Open

   

    or

   Open

   

    button to open the Course Form

2.  the screen 

3. Right-click on the 

   Open

   

    button on the Course Form and choose 

4. Enter a name for the Actionflow,

   1. Name: Delete Course (Course Form)

   2. Click Confirm

5. Repeat the above steps to configure the Actionflow but make the following changes:

   1. the input is the Course 

   2. in the Settings, toggle on 

       Close screen after action completes - this will close the Course Form when 
       is pressed
      
      Checkpoint
      

6. Once you have configured the Actionflow, return to the Course Management screen

7.  the screen, select a record in the grid and press the  
   Open

   

    button

8. On the Course Form, press the 

   Open

   

    button

   1. We can see that the Actionflow is working correctly because the Course Form closes and the selected record is deleted from the School Courses grid