What is a Save Action?

The 

Save actions only save attributes mapped into them. However, if If the Save action has Auto Save Attributes enabled, this saves unmapped attributes from the input form or view, matched by identifier. This finds the attribute associated with a field that was created by dropping the attribute onto a formthe primary key. The primary key must be mapped. Where it is empty, a new record is inserted but if it is populated, the existing record is updated.

Note: Save actions must be attached to a table with a Type of Transactional. Reword? "Save actions will only insert or update records in tables with the Type of Transactional."with a Period of Transactional. 

Creating Save Actions

1. Click On an Actionflow, click the 

   Insert excerpt
   _action_save _action_save 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
      _action_save _action_save nopanel true

      to create a Save node
2. Alternatively, drag the drag the 

   Insert excerpt
   _action_save _action_save nopanel true

    icon from the toolbar onto the canvas
3. In the Create Save Action window:
   1. Enter a name
   2. Choose a Type:
      1. Auto Insert/Update -: Insert or update records using the following condition:
         1. If the input data passes in the primary key of an existing record, the save action updates the record in the chosen table
         2. If the input data does not pass in the primary key of an existing record, the save action inserts a new record in the chosen table
      2. Insert -: Always insert a new record into the chosen table
      3. Update -: Always update a record for the chosen table. For a record to update successfully a primary key must be provided.
   3. Choose the Table from the drop down where the records will be inserted or updated
   4. Select Create Action

Worked Example

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

In this example, we are using:

• A Course Form screen containing form fields and associated with School Courses data by a background filter - the 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 save new courses and edit existing ones on a Course Management screen. To do this, we will configure a Save Action on an input form, Course Form screen, that saves the data to the School Courses table. 

Image Added

Save Action to Add and Edit Data

Create a Save Action to save data to the school courses table.

1. On the Course Management screen, press either the Image Removed or Image Removed button to open the Course Form Rightscreen where the Actionflow will be initiated from, Course Form, right-click on the button and choose 

   Insert excerpt
   _actionflow_add _actionflow_add nopanel true

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

   Insert excerpt
   _form _form nopanel true

    datasource data source, then select Connect Input
4. In the Mappings window that opens, drag the CourseID attribute from the left (Course Form) to into the Drag and Drop area on right (Input Connection Point)
   1. Select Save
5. Click and drag the 

   Insert excerpt
   _action_save _action_save nopanel true

    icon from the toolbar onto the canvas
6. In the Create Save Action window enter:
   1. Name: SaveCourse
   2. Type: choose Auto Insert/Update
   3. Table: choose School_Courses
   4. 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_save _action_save nopanel true

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

   Insert excerpt
   _input _input nopanel true

    and

   Insert excerpt
   _action_save _action_save nopanel true

    action node, and choose

   Insert excerpt
   _open_mappings _open_mappings nopanel true

   1. Drag the CourseID attribute on the left onto the CourseID attribute on the right
   2. Select Save
9. Click on the Save action the 

   Insert excerpt
   _action_save _action_save nopanel true

    action node and in the 

   Insert excerpt
   _property_settings _property_settings nopanel true

   , toggle on 

   Insert excerpt
   _toggle_on _toggle_on nopanel true

    Auto Save Attributes

10. Insert excerpt
    _finish _finish nopanel true

     the properties tab

11. Finally, in the Settings above the canvas, toggle on 

    Insert excerpt
    _toggle_on _toggle_on nopanel true

     Close screen after action completes

    Expand
    title Checkpoint
    Image Added

    
    

12. Close the Actionflow to and return to the Course Management screen

13. Insert excerpt
    _lock _lock nopanel true

     the screen and press the click Image Modifiedor Image Removed buttonEither enter new course details or edit the existing course details and  or Image Added to open the Course Form
14. Enter/change the course details, then press  to see the Actionflow in action
    1. We can see that the Actionflow is working because the School Courses grid on the Course Management screen is updated with the data we have just created/edited 

Image Modified