run an action/table-action without requesting user confirmation.

 when a user triggers an action/table-action, PhixFlow displays a popup message asking them to confirm. By default, the message is:

Please confirm that you want to apply action Action Name

To provide a customised confirmation message, use the Confirmation Message property.

Use this property for an action/table-action that will upload a file.

Enter an expression that sets the value of the tag for the file. You can use this tag in a file collector to read into PhixFlow files that the table-action has uploaded.

The tag expression can refer to:

• any values entered on the Form View using: _prompt.<Form Field Name>

• the values of any Context Parameters using: _context.<ContextParameter Name>

You can return a list of the names of uploaded files using the _files variable.

Enter a validation expression. This expression is evaluated at the start of any Insert or Update table-actions or record-actions. If the validation expression generates any error messages (using the error function) then the action is abandoned. The validation expression is not used to decide whether or not to run the selected task plan.

The validation expression can include multiple statements by wrapping them in a do() clause. A number of internal variables are available in these expressions:

• _this:

• a reference to all the selected records within the view to perform the table-action

• .
• _prompt:

• a reference to all the user prompted table-action attributes.

The usual message functions debug(message), info(message), warning(message), and error(message) are all available to be used in these expressions and will result in messages being written to the system console logs.

Example 1

Validate that the sum of the selected record amounts equate to zero before allowing the action/table-action to be executed.

if(sum(_this.amount) == 0, info('OK'), error('Not performing Action as the Sum does not equate to zero'))

Example 2

Validate that the user entered comment is at least 10 characters long, else write a warning to the log.

if(stringLength(_prompt.UserComment) >= 10, info('OK'), warning('Comment should be at least 10 characters'))

Using values from other views

You can also refer to records selected in other

views by using their

screen zone names. E.g. if the

screen also contains a

screen zone name ACCTS that is bound to a view, you could use the following in your validation expression:

if(sum(ACCTS.amount) == 0, info('OK'), error('Error as ACCTS Sum does not equate to zero'))

Enter the text for a message that PhixFlow will display when the action/table-action has completed. Use the toolbar to format the message. You can use the message to notify the user of a summary of the action, or the to provide information about the completed state.

You can

include expressions within the message by enclosing each expression in curly brackets { } . PhixFlow evaluates each expression in turn before displaying the message.

For result messages that report on the status of the action

/table-action, you can use the following internal variables in the expressions:

• _error: Details of the error messages generated.
• _errors: The number of error messages generated.
• _warning: Details of the warning messages generated.
• _warnings: The number of warning messages generated.
• _messages: The number of warning messages generated.
• _taskPlan: The name of the

• task plan that the

• action/table-action ran (may be null)
• _runId: The runId of any

• table data generated by this

• action/table-action (may be null).
• _action: The name of the

• action/table-action.
• _file: Details of files processed (imported or exported) by the

• action/table-action.
• _fileCount: The number of files processed by the

• action/table-action.

Action {_action} failed with {_errors} errors and {_warnings} warnings.

You can also use context parameters and values to report different messages. For example, if you have a context parameter (called balance) that calculates the outstanding balance, you can use an expression that reports different messages depending on the calculated value.

{if(_context.balance < 0,"Money still owed", "Balance paid")}

/table-action multiple times, even if the previous run has not completed.

immediately. Only untick this check box if your action does not depend on any data or context parameters from the screen.

You can specify a form view to appear when the user starts the action/table-action. They will be able to enter values on this form view, and the values can be used to update selected records for an update action, or populate fields for an insert action.

Select a form view

• either from the drop-down list of all forms views in PhixFlow
• or click

  Insert excerpt
  _

• table_show _

• table_show nopanel true

   to open the repository showing all the

• tables. From the repository, drag a form view from the

• table into this field.

Values entered in the form view are referenced in expressions in the table-action with the form.

_prompt.<form field name>

For example, if there is a field on the form with the label Name, then the value entered in that field by the user can be referenced in subsequent expressions as

_prompt.Name

If this is an update table-action, then the form will be pre-populated with the values from the selected record. Where multiple records are selected, then only those values which are common to all the selected records will be displayed. For insert table-action, when the form pops up all fields will be blank.