Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
This page provides details of the properties for the
action. This is a node in an actionflow. Insert excerpt _action_save _action_save nopanel true
Overview
Use a
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Live Search | ||||||||
---|---|---|---|---|---|---|---|---|
|
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Example
TBC
Allocating Primary Key Values to New Records
When the save action 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 | ||||||||
---|---|---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Basic Settings
Field | Description | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Name | Enter the name for the action node. | ||||||||||||||||||||
|
| ||||||||||||||||||||
Type |
| ||||||||||||||||||||
Table | The table where the data is going to be updated. | ||||||||||||||||||||
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. |
Attributes
A list of attributes to be updated. 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 Properties
- 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. 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 | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|