This page provides details of the properties for the save node, which is part of an actionflow.
Overview
Use a
| Insert excerpt |
|---|
| _action_save |
|---|
| _action_save |
|---|
| nopanel | true |
|---|
|
action node node to insert, update or delete records for a selected table.
| Live Search |
|---|
| spaceKey | @self |
|---|
| additional | none |
|---|
| placeholder | Search all help pages |
|---|
| type | page |
|---|
|
| Panel |
|---|
| borderColor | #00374F |
|---|
| titleColor | white |
|---|
| titleBGColor | #00374F |
|---|
| borderStyle | solid |
|---|
| title | Sections on this page |
|---|
|
| Table of Contents |
|---|
| maxLevel | 3 |
|---|
| indent | 12px |
|---|
| style | none |
|---|
|
|
| Note |
|---|
A save node must be attached to a table with a Type of Transactional. |
The save node will make a change to a record in the table. Depends on the selected save Type.
For Auto Insert/Update - depends on the what is passed in through the incoming connection (todo-fiona: check this is right. original phrase was "provided with"
fkldjjf
Example
In the actionflow instance illustrated in the screenshot above a user is saving values on an edit form (, an application has a Company Edit Form) to a Company table. In this workflow all changes must be approved by a second colleague. All attributes on the edit form need to be saved and a Status attribute to manually set . When the application user makes a change, to the form clicks Auto Save Attributes on the form, the actionflow runs.
- The calculate node sets the following attributes:
- Status to 'Pending Approval'
, - StatusUpdate to the current time
and
users name using a calculate node
To automatically save all the attributes on the form all the user has to do is click 'Auto Save Attributes'. This automatically saves - The save node saves any attributes on the driving input form
which - that link to the table on the save node.
This means if any additional fields are added to the backing table and input form they do not need to be mapped to the save node.
Create Save Stream Action pop-up Window
Field | Description
Name | | Type | - Auto InsertUpdate
- Insert
- Update
- Delete
|
| Stream | Click the show list icon and Drag and drop it in from the repository |
Allocating Primary Key Values to New Records
When the save action node is inserting a new record to the table, PhixFlow allocates a unique primary key value to the record. How PhixFlow allocates a value is determined by the Table properties → Advanced → Primary Key Generator.
- Internal: By default, PhixFlow automatically allocates a unique, numeric value to the primary key attribute.
- Sequence: Configure PhixFlow to allocate a value from your own sequence using the Primary Key Generator Sequence option. see Stream > Data Generation Options and Sequence.
| Insert excerpt |
|---|
| _property_tabs |
|---|
| _property_tabs |
|---|
| name | basic-h |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _parent |
|---|
| _parent |
|---|
| nopanel | true |
|---|
|
Save requires a transactional table to be attached. Dragged in when you create it - listed in the Table property
The save node will make a change to a record in the table. Depends on the selected save Type.
For Auto Insert/Update - depends on the what is passed in through the incoming connection (todo-fiona: check this is right. original phrase was "provided with"
fkldjjf
Basic Settings
| Field | Description |
|---|
| Name | Enter the name for the action node. |
| Insert excerpt |
|---|
| _actionflow_properties |
|---|
| _actionflow_properties |
|---|
| name | show-name |
|---|
| nopanel | true |
|---|
|
| | Insert excerpt |
|---|
| _actionflow_properties |
|---|
| _actionflow_properties |
|---|
| name | show-text |
|---|
| nopanel | true |
|---|
|
|
| Type | - Auto Insert/Update
Insert or update records using the following condition:- If the incoming connection passes in the primary key of an existing record, this save node updates the record in the attached table
- If the incoming connection does not pass in the primary key of an existing record, this save node inserts a new record.
- Insert
Always insert a new record into the attached table - Update
Will always update a record for the attached table. For a record to update successfully a primary key must be provided. - Delete
Will always delete a record on the attached table. For a record to be deleted successfully a primary key must be provided.
|
| Table | The table where the data is going to be updated. must be transactional |
| Auto Save Attributes | If selected, this action will automatically save unmapped attributes from the driving input form or view, matched by id. If an attribute on the target table has not been mapped, the save action will check for a value by id (on a form the field will automatically be associated with the stream attribute if it has been added by dropping the stream attribute on the form). If there are multiple values for an attribute, the action will error. If there are no values for an attribute it will not be updated. |
Autosaving Attributes
If selected, this action will automatically save unmapped attributes from the driving input form or view, matched by id. If an attribute on the target table has not been mapped, the save action | node will check for a value by id (on a form the field will automatically be associated with the stream attribute if it has been added by dropping the stream attribute on the form). If there are multiple values for an attribute, the action will error. If there are no values for an attribute it will not be updated. |
Attributes
A list of attributes to be updated manually. Click 
to show the list of attributes for the table. Drag the attributes you want to add to the save node into this list.
In the list:
- to edit the attribute's properties, double-click an attribute; see View Attribute
- to delete an attribute, right-click and select
| Insert excerpt |
|---|
| _delete |
|---|
| _delete |
|---|
| nopanel | true |
|---|
|
| Note |
|---|
Attributes not added to this list will not be changed unless 'Auto Save Attributes' is ticked. If a record is being inserted and an attribute is not present in the save node, the default value for this field will be _NULL |
| Insert excerpt |
|---|
| _description |
|---|
| _description |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _access |
|---|
| _access |
|---|
| nopanel | true |
|---|
|