Versions Compared

Old Version 22

changes.mady.by.user Anthony George

Saved on

compared with

New Version Current

changes.mady.by.user Zoe Baldwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Insert excerpt
_Banners
_Banners
name
actionflow
TableActions
nopaneltrue

This page is for application designers who want to configure actions.

Overview

Insert excerpt_action_concepts

_action_conceptsnopaneltrue

When you are creating a 

stream-item

record-action for a table, use this property tab to add an expression that evaluates to the new value for that table attribute.

  1. Create a
Stream Item Action. 
  1. record-action.
  2. In the Basic Settings →  Attributes to Update section there is a grid of attributes.
  3. In the grid, double-click on a attribute.
  4. PhixFlow opens the
stream
  1. record-
item-
  1. action attribute property tab. 

Properties

This property tab is

Record-action properties are not available from the repository. It only opens from

 the Record

 the record-

actions properties

action properties → Basic Settings →  Attributes to Update section.

Insert excerpt
_property_tabs
_

standard_settings_standard_settings

property_tabs
namebasic-h
nopaneltrue

Insert excerpt
_parent
_parent
nopaneltrue

Basic Settings

FieldDescription
OrderEnter the order in which the attribute expression will be evaluated. 
AttributeSelect the name of the table attribute that will be populated.
Expression

Enter an

Expression

expression to generate a new attribute value. 

To refer to table attributes, pipes and screen zones in the expression, use:

  • <attribute-name> to refer to the current value of
the stream-item you
  • the record you are about to update.
  • <pipe-name> to refer to lookup pipes on the same table as the action. The pipe cannot reference _out variables directly.
  • <screen-zone-name> refers to selected
stream-items
  • records from other views using their screen zone names.
Panel
titleExample

For example:

  • A screen zone name is ACCTS.
  • In the screen, the user will
select stream-items in
  • select records in a grid view.
  • For the selected
stream-items
  • records, you want the action to sum the values in the amount attribute.

Enter an expression:

Code Block
sum(ACCTS.amount)


You can also use the following prefixes:

  •  _prompt.<form-field-name> to refer to fields from any user input form associated with this action.

  • _form.<form-field-name> to refer to the current value displayed in a field on the form.

    Panel
    titleExample

    In the screenshot below, the expressions use _form to refer to fields Unit Price, Quantity and VAT Percentage. The user sees these fields on a form.

    Image Modified



  • _out.<attribute-name> to refer to the current value of an attribute in the action.
    For example, in the screenshot above, you could refer to the value for the attribute ChargeAmount in VATAmount with the expression _out.ChargeAmount.

  • _context.<context-variable-name> refer to any context variable defined for this action.

  • _gridRow.<table-view-attribute-name> to refer to the edited value of an attribute when the Filter Type is Edited Items.
     _gridRow contains a
streamset
  • recordset pointing to an individual row that has been modified.

Messages

You can use the following message functions in the expression. When the action runs, any messages are written to the system console and logs.

 
(message)
 
(message)
(message)
(message) 
Note

If PhixFlow reports an error, it stops the action from being completed for the

current stream-item in

current record in the table.  However, the error does not stop the action from updating or inserting other

stream-items.

records.



Live Search
spaceKey@self
additionalnone
placeholderSearch all help pages
typepage

Panel
borderColor#00374F
titleColorwhite
titleBGColor#00374F
borderStylesolid
titleSections on this page

Table of Contents
maxLevel3
indent12px
stylenone


Learn More

Insert excerpt
_terms_changing
_terms_changing
nopaneltrue