Parameters

The Parameters tab lets you configure parameter input for each iteration.

Formulas

Instead of assigning a static value it is possible to assign a formula to calculate the value when the task is executed. To provide a formula instead of a static value, toggle the 'fx' button to the left of the parameter input, and provide a formula expression, e.g. =1+1. It is possible to reference particular pre-defined variables from a formula, e.g. ["Due Date"], assigning the task due date as value to a parameter. Available variables are:

• ["Due Date"]
• ["Start Date"]
• ["Report Name"]
• ["Task Name"]
• ["Document ID"]
• ["Task ID"]

There are many built-in functions available, as well as relevant arithmetic and logical operators. (Please refer to the column modifier in the “OmniFi - User Guide” for a complete listing of supported functions).
A very useful example is the Business Days function, bd(). It calculates a business day offset from a particular date using the calendar assigned to the schedule that the task belongs to.

Ex: bd(["Due Date"], 5) calculates a date five business days after Due Date.
Ex: bd(["Due Date"], -20) calculates a date twenty business days before Due Date.

For a complete listing of all available functions, please see [Variables & Functions](doc:variables-functions

To test the expression before saving, click the debug button below the expression field.