# Formula Builder screen

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

## How to Start

1. Open eForm Builder.

For information about how to open this screen, refer to eForm Builder screen.

2. On the Advanced Controls tab, drag a Formula form control onto your eForm.
3. Complete the fields as necessary.
4. On the eForm Builder screen, click the Formula form control, and click Formula.

## Fields

Field NameDefinition

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:

Operators

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

Functions

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.
• avg - Gives the mean of a specified numbers.
• dow - Gets the number of week days from a specified date.
• moy - Gives the number of the month from a specified date.
• getYear - Gives the year from a specified date.
• getTime - Gives the time in millisecond (ms) from a specified date
• getHours - Gives the number of hours from a specified date.
• getMinutes - Gives the number of minutes from a specified date.
• getSeconds - Gives the number of seconds 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.
• max - Gives the largest number of the specified numbers.
• min - Gives the smallest number of the specified numbers.
• pow - Gives the specified number increased to the specified power.
• floor - Gives the largest integer number that is smaller than or equal to the specified number.
• round - Rounds the decimal value to the nearest integer.
• trunc - Gives the integer part of a specified by removing the decimals.
• abs - Gives the absolute value of a specified number.
Default Value:
None
Example:
Refer to:
Limitations:

The moy, getYear, getTime, getHours, getMinutes, getSeconds, avg, max, min, pow, floor, round, trunc, and abs options are available in these releases: