| Insert excerpt |
|---|
| _Banners |
|---|
| _Banners |
|---|
| name | actionflow |
|---|
| nopanel | true |
|---|
|
This page provides details of the properties for the save node, which is part of an actionflow.
OverviewSave Node Properties Image Modified
Use a | Insert excerpt |
|---|
| _action_save |
|---|
| _action_save |
|---|
| nopanel | true |
|---|
|
node to insert and update records for a selected table. By default, Autosave Attributes is enabled, this saves any attributes on the driving input form that link to the table on the save node. Specific attributes can be overridden manually by specifying the attributes, or if Autosave Attributes is not enabled the Save node will only save attributes which are mapped to it and ignore any that have not been included.A Save node must be attached to a table with a Type of Transactional. |
Example
Image Removed
In the actionflow instance illustrated in the screenshot above, an application has a Company Edit Form. When the application user makes a change and clicks the button, the actionflow runs.
- The Calculate node sets the following attributes:
- Status to 'Pending Approval'
- StatusUpdate to the current time
- StatusUpdatedBy to the user's name.
- The Save node saves any attributes on the driving input form 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.- Specific fields can be manually added and mapped in the Attributes section to the save to override attribute values coming from the input form.
Allocating Primary Key Values to New Records
When the save 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.
Worked ExampleFor full details on how to create a Save node, including worked examples, see Save Action Configuration. | Insert excerpt |
|---|
| _property_tabs |
|---|
| _property_tabs |
|---|
| name | basic-h |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _parent |
|---|
| _parent |
|---|
| nopanel | true |
|---|
|
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 | |
|
- : 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.
| | Table | The table in which the records will be updated. This table must have a Period of Transactional. | | Auto Save Attributes | | Insert excerpt |
|---|
| _check_box_tick |
|---|
| _check_box_tick |
|---|
| nopanel | true |
|---|
|
to save unmapped attributes from the driving input form or view, matched by identifier.- If an attribute on the target table has not been mapped, the save node checks for a value using the identifier. This finds the attribute associated with a field that was created by dropping the attribute onto a form.
- If there are multiple values for an attribute, the save node will report an error.
- If there are no values for an attribute, it will not be updated.
|
Mapped AttributesA list of attributes to be updated manually. Click  Image Modified 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 |
Advanced Settings| Field | Description |
|---|
| Prioritise throughput over ordering | | Insert excerpt |
|---|
| Actionflow Properties |
|---|
| Actionflow Properties |
|---|
| name | PrioritiseThroughputOverOrdering |
|---|
| nopanel | true |
|---|
|
|
| Insert excerpt |
|---|
| _description |
|---|
| _description |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _access |
|---|
| _access |
|---|
| nopanel | true |
|---|
|
|
| nopanel | true |
|---|
| 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 |
|---|
|
|
Learn More
For links to all pages in this topic, see Understanding Actionflows.
| Insert excerpt |
|---|
_terms_changing | _terms_changing