Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Excerpt |
---|
This page provides details of the properties for the save node, which is part of an actionflow. Overview |
Image Added Use a
|
node to insert |
and update |
records for a selected table. |
Live Search | ||||||||
---|---|---|---|---|---|---|---|---|
|
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Example
Image Removed
In the actionflow above a user is saving values on an edit form (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 to 'Pending Approval', StatusUpdate to the current time and StatusUpdatedBy to the 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 savesBy default, Autosave Attributes is enabled, this saves any attributes on the driving input form |
that link to the table on the save node. |
Create Save Stream Action pop-up Window
- Auto InsertUpdate
- Insert
- Update
- Delete
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. For a worked example, see Save Action Configuration. Allocating Primary Key Values to New RecordsWhen 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.
|
Show Views and RecordsetsRight-click on a
|
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"Basic Settings
|
|
|
|
Will always delete a record on the attached table. For a record to be deleted
|
|
|
|
|
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 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).
|
Mapped AttributesA list of attributes to be updated manually. Click |
Image Added 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:
Advanced Settings
|
Live Search | ||||||||
---|---|---|---|---|---|---|---|---|
|
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Learn More
For links to all pages in this topic, see Understanding .