# Formula Builder screen

Lets you configure a formula to do math calculations for your eForm and it's form controls..

## How to Start

1. On the Application Explorer screen, do one of these:
2. Do one of these:
• Add a Formula control:
1. On the eForm Builder screen, in the Toolbox, open the Advanced Controls tab.
2. On the Advanced Controls tab, drag a Formula form control onto your eForm.
• Change a Formula control:
1. On your eForm, click the control, and click Edit .
3. Complete the fields as necessary.
4. On the eForm Builder screen, click the Formula form control, and click Formula .

## Fields

Field Name Definition

Formula

Function:
Specifies the formula with the form control, functions, and logical operators to run in the eForm.
Accepted Values:
• A valid formula or expression.

You can create a formula or expression using function, operators, fileds, and process data variables.

Default Value:
None
Example:
\${Expenses/ExpenseAmount:[this]}*\${Expenses/ConversionRate:[this]}

Also refer to:

Fields/Tokens

Function:
Specifies the form control or token to associate with the formula.
Accepted Values:
A valid form control or token from the list.
Default Value:
• user:domainname
Example:
Refer to:

Operator

Function:
Specifies the operator to use in the formula.
Accepted Values:
• +
• -
• *
• /
• %
• <=
• <
• >=
• >
• !=
• =
• &&
• ||
Default Value:
None
Example:
Refer to:

Keywords

Function:
Shows the list of keywords to use in the formula to show specific values on the eForm.
Accepted Values:
• randomstring - Let's you use a random alphanumeric string on the eForm which can be used to validate the form user.
• now - Let's you use the current day in the formula.
• days - Let's you use the current day as a number. For example, Sunday is 0, Monday is 1 and so on.
• months - Let's you use the month in the formula.
• years- Let's you use the year in the formula.
Default Value:
• randomstring
• now
• days
• months
• years

Function

Function:
Shows the list of functions to use in the formula to do specific actions on the eForm.
Accepted Values:
• datediff - Gets the difference in hours, minutes, seconds, days, weeks, or months between two dates.
• sum - Gives the sum of a group of numbers.
• dow - Gets the number of week days from a specified date.
• instr - Searches a string for a substring using characters and returns the position in the string that is the first character of a specified occurrence of the substring.
• lowerstr - Changes the capital letters of a specified string expression to small letters.
• upperstr - Changes the small letters of a specified string expression to capital letters.
• substr - Gives the characters in a string that starts at the specified location, and ends at the specified number of characters.
• if - Specifies an if condition.
• decimal - Gives a number in decimal format.
Default Value:
None
Example:
Refer to: