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

 Tick 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.

 Tick to prompt the user to browse to and select the file they want to upload.

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'))

 Tick to run a task plan as part of the action.  Any expression evaluated during this task plan can reference any context parameter.

 Untick to report the result in a message without any information about warnings. You can view the warnings in the console.

 Tick to include warning messages generated by the action/table-action to be listed in the result message.

 Untick to report the result in a message without including any information about errors. You can view error messages in the console.

 Tick to include error messages generated by the action/table-action to be listed in the result message.

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")}

 Untick so that a user can run this action/table-action multiple times, even if the previous run has not completed.

 Tick so that a single user cannot run this action/table-action more than once at the same time. For example, if a user has started this action, they will not be able to start it again until the first action/table-action has finished.

 Untick so that the action/table-action can run 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  Show Table 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.