PerfectApps™ Help Guide

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Printable Version
Save Permalink URL

Using the Formula and Condition Editor

Many apps can benefit from the use of a formula or a condition. Formulas and conditions can be assigned to app fields, buttons, other objects and even events.

The most common use of a formula is the Set Field behavior command which allows you to assign a formula to a app field.

The most common locations for conditions are:

•Simple Branch behavior (true/false If condition)

•Multiple Branch behavior (multiple If conditions)

•Workflow diagram stage transition

The general use of the editor is the same for formulas and conditions. On the left side is the main compose area. Each line can contain:

•A text or number value, date, state, value of a field or special value.

•An operator (+,-,/,*)

•A function (see the Functions table for a complete list)

When the editor loads, the main area will contain a single line with <empty> in it. You can change this line by selecting a value from the right.

•Text or number - Whatever literal value you enter here will be used in the line.

•Date - Allows you to specify a date.

•State - Allows you to set a field to be true (checked) or false (unchecked) by default.

•Field - Points to a specific app field which is then inserted on the line.

•Special - Gives access to a list of special codes or app properties.

The following are some common tasks you might want to complete in the editor:

Adding Lines	To add a new line, click Add Line. A new operator and a new field line are displayed. You can then change the field from <empty> to your requirements. You can also change the operator if the default + is not appropriate.
Removing Lines	Click the delete button to remove a line.
Adding Parentheses	If you need to build more advanced mathematical expressions, use parentheses buttons to add these to an expression. Use the Add ( ) button to surround the selected line with parentheses.
Reordering Lines	You can move a line up and down the list by selecting the line and then clicking the up and down arrows.
Copy, Paste or Delete	Use CTRL+C, CTRL+V or contextual menus (right mouse click) to copy, paste or delete selected sections. Certain restrictions apply; see below.