Versions Compared

Version Old Version 2 New Version 3
Changes made by

Sarah Gibson

Sarah Gibson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameactionflow
nopaneltrue

This page provides details of the properties for the calculate save action node and associated expressions. These are part of actionflows.

Overview

A calculate action... Todo-Fionasave node is used to insert, update or delete records for a selected table.

Insert excerpt
_property_tabs
_property_tabs
namebasic-h
nopaneltrue

Insert excerpt
_parent
_parent
nopaneltrue

Basic Settings

The expression properties has sections for Parent Details , Audit Summary and the following Basic Settings:

Field

DescriptionNameEnter an expression name.Type

Select one of the data types: Todo-Fiona - what does this do?

  • String
  • Bigstring
  • Integer
  • Float
  • Decimal
  • Date
  • Datetime
  • Graphic
  • TrueFalse
An attribute nameTodo-Fiona - what does this do?Expression

Enter an expression. To work in a larger pop-up window, click Image Removed.

See also:

OrderWhere the calculate action runs multiple expressions, enter a number to indicate the order in which this expression will be run. Remember that an expression that generates a value should run before an expression that uses the value.An application can have many actionflows, and an individual actionflow can have many actions. This can lead to many items being listed in the repository. Use this option to omit the action from the repository
FieldDescription
NameEnter the name for the action node.Show in the Explorer.
Insert excerpt
_
check
actionflow_
box_tick
properties
_
check_box_tick
actionflow_properties
nameshow-name
nopaneltrue

 to display this action node in the repository.

Insert excerpt
_checkactionflow_box_untickproperties
_check_box_untickactionflow_properties
nameshow-text
nopaneltrue
 to omit this action node from the repository.

Pass Through

Pass data through to subsequent action nodes.

Input Connection Points]

Todo-Fiona - duplicate from elsewhere

Calculate Action Expressions

Calculate actions process data using expressions; see pages in the topic Expressions and Scripts.

This section has a toolbar with standard buttons. The grid contains a list of the expressions that the calculate action will perform. 

...

Type
  • Auto
    Will either insert or update records using the following condition:
    • If the node is provided with a primary key of an existing record, the node will update that record.
    • If the node is not provided with a primary key of an existing record, the node will insert a new record.
  • Insert
    Will 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.
TableThe table where the data is going to be updated.

Attributes

A list of attributes to be updated. 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:

  • to edit the attribute's properties, double-click an attribute; see View Attributes
  • to delete an attribute, right-click and select 
    Insert excerpt
    _delete
    _delete
    nopaneltrue
     
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
_description
_description
nopaneltrue

...