The Expression Builder is a valuable tool used to assist in the creation and examination of expressions. An expression, in a programming, is a combination of variables, constants, functions and operators that represents a particular value. Many procedures or actions that one might want to perform with expressions are already contained in AutoMate's list of available actions. However, expressions can be used to further expand the capabilities of an action or add more intelligence to a task due to its ability to resolve dynamic data during task execution. The Expression Builder essentially incorporates all of the elements needed in order to create a properly formatted expression for use in any step of an AutoMate task.
The Expression Builder provides a hierarchical view of all supported functions, constants, datasets, variables, and arrays. It also provides a list of system objects, such as AMError and AMTrigger, which can be used to determine a variety of key elements that occur during runtime. For instance, when a task is triggered, it automatically creates an AMTrigger object which can be used to determine the name of the event or condition that initially started the task, the date and time of when the trigger occurred and which machine it occurred on. If an errro occurs, an AMError object can be used to determine detailed infomation about the error that occurred, such as corresponding error code, verbose dditionally, if a task generates an error, the Error object can be used to acquire a description of the error that occurred, which step it occurred on and which task generated the error.
The Expression Builder also allows for the creation of arrays and variables directly from its UI (User Interface). Double-clicking the Add Variable or Add Array option located in the bottom part of the Expression Builder's left window pane will open the 'Create Variable' or 'Create Array' properties dialog. These are identical dialog boxes that normally appear when selecting the 'Create Variable' or 'Create Array' action from the Task Builder's Available Actions pane.
The Expression Builder interface can be accessed from the Task Builder by clicking the Insert Expression/Variable popup button which is available while editing the steps of a task. In the properties dialog box of any action, clicking inside any text box that accepts an expression will allow the Insert Expression/Variable button to appear to the right of the box. Pressing this button (or the F2 key) while in an action’s properties causes the Expression Builder interface to be displayed. An expression may then be visually constructed, tested and inserted into the step parameter.
NOTE: The Expression Builder can also be accessed from the Task Builder's Tools menu by selecting Tools -> Expression Builder.
Expression Builder is arranged in three panes. The lower left pane contains folders for functions, variables, constants, etc., and the lower right pane shows the contents of whichever folder is selected. Your expression is shown in the upper pane, and operators are shown just below the upper pane.
The Expression Builder is arranged in four primary sections as illustrated above. Each section plays an important role in the creation of an AutoMate expression. Each section is described in further detail below:
Folders Pane: The lower left window pane includes folders containing all available functions, extended function, variables, datasets, constants constants, etc. This section also includes the ‘Create Variable’ and ‘Create Array’ options, which allows for the creation of variables and arrays directly from the Expression Builder interface.
Contents Pane: The lower right window pane displays the contents of a folder selected from the lower left Folders pane. Help for each function can be found by selecting the desired function from this window pane and pressing the F1 key, or by right-clicking and selecting Help from the popup menu that appears.
Expression Pane: When double-clicking an item from the Contents pane, the expression is displayed in the upper Expression pane. Help can also be found for a function from this pane by placing the insertion cursor inside a function name and pressing F1.
List of Operators: Operators which can be added to the expression are shown just below the Expression pane.
Help for each function can be found by selecting the desired function from the right-hand side of the window and pressing the F1 key, or by right-clicking and selecting Help. Help can also be found for a function by placing the insertion cursor inside a function name in the upper expression pane and pressing F1.
The Expression Builder can be used to view specific objects that are created as a result of specific events. The Variables folder located in the Folders pane of the Expression Builder becomes populated if a 'Create Variable' action is used to create the specified variable(s) in an earlier step. Additionally, the datasets folder becomes populated when the specified datasets are initially created by running the step that creates and populates a dataset names and its contents, however, the dataset name itself is available in the Expression Builder if a step that creates the dataset appears in the task.
For example, imagine creating a task that includes a 'POP3 Email' action as the first step to retrieve email messages from a POP3 mail box. The General tab of this action contains a parameter labeled Create and populate dataset with which specifies the name of the dataset that should be created and populated with the mail message data upon execution as shown in Figure 1-2.
Open Expression Builder from an action dialog box by clicking the Insert Expression button .
Add elements to your expression as follows:
Click a folder in the left pane to reveal its contents in the right pane.
Double-click elements in the right pane to add them to your expression.
Select and replace characters in the expression as needed.
Click operators below the expression pane to add them to the expression.
After you have created your expression, click Test to test it.
When satisfied with the expression, click the Insert button to insert it into the specified action’s properties. When the expression is added to the action parameter, the percentage signs (%) will automatically be added to the beginning and end of the expression.
The BASIC Language Grouped by Type
AutoMate Extended Functions