Formula Builder screen

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

Screen



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]}

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

Operator

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

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