By the end of this chapter you will understand what a Delete action is and how to use them, and you will have created a Delete Actionflow in your application.

What is a Delete Action?

The 

Note: Delete actions Delete actions will only insert or update delete records in tables with the Type of TransactionalPeriod of Transactional. 

For the full list of Delete action

Creating Delete Actions

1. Click the 

   Insert excerpt
   _delete _delete nopanel true

    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 

      Insert excerpt
      _delete _delete nopanel true

      to create a Delete node
2. Alternatively, drag the 

   Insert excerpt
   _delete _delete nopanel true

    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 inserted or updateddeleted
   3. Select Create Action

Creating Delete Actions for File Tables

These settings are in addition to the steps above.

Confirmation Messages

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

Earlier in this course we created two Open Screen Actionflows that open an input form for adding and editing courses to the School Courses grid. In this example we will configure the Save action.

Note: When creating a new input form in PhixFlow, a Form Actions wizard can configure the Save Record and Delete Record actions for you. For the purposes of understanding the mechanics of Actionflows, we will create these manually.

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.

Example 1: Delete Action for Grid

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

Image Added

1. On the Course Management screen, press either the Image Removed or Image Removed button to open the Course Form Rightright-click on theImage Removedthe Image Added button and choose 

   Insert excerpt
   _actionflow_add _actionflow_add nopanel true

2. Enter a name for the Actionflow,
   1. Name: Save Delete Course (Course Grid)
   2. Select Confirm
3. Select Click to Connect under Connections and for the input, choose the Course  School Courses 

   Insert excerpt
   _formgrid _formgrid nopanel true

    datasource View Component, then select Connect Input
4. In the Mappings window that opens, drag notice that by default the data being used is the selected record
   1. Drag the CourseID attribute from the left (
   Course Form) to
   1. School Courses Grid) into the Drag and Drop area on the right (Input Connection Point)
   2. Image Added 
   3. Select Save
5. Click and drag the 

   Insert excerpt
   _action_savedelete _action_savedelete nopanel true

    icon from the toolbar onto the canvas
6. In the Create Save Delete Action window enter:
   1. Name: SaveCourseType: choose Auto Insert/Update DeleteCourse
   2. Table: choose School _ Courses
   3. Select Create Action
7. Click and drag the 

   Insert excerpt
   _driving_interface_connection_point _driving_interface_connection_point name icon nopanel true

    icon onto the 

   Insert excerpt
   _action_savedelete _action_savedelete nopanel true

    action node on the canvas
8. Right-click on the in connector and choose Open MappingsDrag

   Insert excerpt
   _open_mappings _open_mappings nopanel true

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

   2. Select Save

   Click on the Save action node and in the 

   1. 
      
      Checkpoint
      Image Added

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

10. Insert excerpt
    _lock _lock nopanel true

     the screen and select a record in the grid, then press the Image Added button

Example 2: Delete Action for Form

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

Image Added

1. On the Course Management screen, select the Image Added or Image Added button to open the Course Form

2. Insert excerpt
   _

   property_settings

   unlock _

   property_settings

   unlock nopanel true

   , toggle on  the screen 
3. Right-click on the Image Added button on the Course Form and choose 

   Insert excerpt
   _toggleactionflow_onadd _toggleactionflow_onadd nopanel true

    Auto Save AttributesFinally, in the Settings above the canvas
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 

      Insert excerpt
      _form _form nopanel true

   2. in the Settings, toggle on 

      Insert excerpt
      _toggle_on _toggle_on nopanel true

       Close screen after action completes

   Close the Actionflow to

   1. - this will close the Course Form when Image Added is pressed
      
      Checkpoint
      Image Added

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

7. Insert excerpt
   _lock _lock nopanel true

    the screen, select a record in the grid and press the Image Removedor the   button
8. Either enter new course details or edit the existing course details and press Image Removed to see the Actionflow in actionOn the Course Form, press the Image Added 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 is updated with the data we have just created/edited 

--

Image Modified