Formula Builder screen

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:

• The videos on this page
• (Example) Create a Formula to Calculate the Total Hours Requested for the Create Absence Request eForm
• (Example) Create a Formula for a Unique ID for the Create Absence Request eForm

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:username
• user:domainname

Example:

Refer to:

• The videos on this page

Operator

Function:

Specifies the operator to use in the formula.

Accepted Values:

• +
• -
• *
• /
• %
• <=
• <
• >=
• >
• !=
• =
• &&
• ||

Default Value:

None

Example:

Refer to:

• The videos on this page

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:

• The videos on this page