Inline Functions activity

An activity that changes the data from your process or form control..


Inline Functions activity

Configure the Inline Functions activity

To configure the Inline Functions activity, do the procedure in this topic.

Examples

  • (Example) Create an Inline Function
  • Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Good to Know

How to Start

  1. Open Process Builder.

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


    Open Process Builder
  2. In Process Builder, in the Activity Library, open the Utilities tab.

    Open Utilities tab
  3. On the Utilities tab, drag the Inline Functions activity onto your process.

    Drag Inline Functions activity

Procedure

  1. Complete the fields on the General Configuration screen.
  2. Click Inline Functions Inline Functions icon.
  3. Complete the fields on the Inline Functions screen.
  4. (Optional) Click Advanced Advanced icon > Email Notifications E-mail Notifications icon.

    For more information, refer to Email Notifications screen (Process Activities).

General Configuration

Specifies the basic settings for the Inline Functions activity.

Figure: General Configuration screen

General Configuration screen

Fields

Field NameDefinition

Display Name

Description:
Specifies the activity name that shows in your process.
Allowed Values:
One line of text (a string).

Accepted:

  • Letters
  • Numbers
  • Spaces
Default Value:
None
Accepts Variables:
No
Example:
This is a common configuration field that is used in many examples. Refer to:
  • Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Description

Description:
Specifies an optional text description for your activity.
Allowed Values:
More than one line of text.
Default Value:
None
Accepts Variables:
No

Inline Functions

Configures one or more inline functions that change the data from your process or form control.

Figure: Inline Functions screen

Inline Functions screen

Fields

Field NameDefinition

Add Add icon

Opens this Screen:
Inline Functions
Function of this Screen:
Configures one or more formulas..
Example:
Refer to:

Result

Description:
Specifies the process data variable that stores the result of the inline function.
Allowed Values:
A process data variable.
Default Value:
None
Accepts Variables:
Yes
Example:
Refer to:

Formula

Function:
Shows the formula that changes the data from your process or form control.
Example:
Refer to:

Edit Edit icon

Function:
Changes the formula.

Delete Delete icon

Function:
Deletes the formula.

Inline Functions

Configures one or more formulas.

Figure: Inline Functions screen

Inline Functions screen

Fields

Field NameDefinition

Formula

Description:
Specifies the syntax of your formula.
Allowed Values:

An expression you build from the list of functions.

You can create a formula or expression using Text, Number, Currency, and Date functions from Inline Functions list, or process data variables.

To add more than one formula for your inline function, replace the text inside the parentheses () of one function with a different function, in thise format:

@function1(@function2(variable1, variable2))

Default Value:
None
Example:
  • @Max(Number1, Number2) - Gives the higher of the numbers represented by the varialbes Number1 and Number2.
  • @UpperCase(SourceString) - Gives the text represented by the variable SourceString in capital letters.
  • @UpperCase(@Substring(SourceString, StartIndex, EndIndex)) - Gives the specified substring of the text represnted by the SourString variable in capital letters.

Also refer to:

Inline Functions

Description:
Specifies the Text, Number, Currency, and Date functions to use in the formula.
Allowed Values:
  • Concat - Joins two or more specified text values into one string.
  • Stringlen - Gives the number of characters in the specified text value.
  • Replace - Replaces all the occurrences of a specified text value in the instance with another specified text value.
  • Remove - Deletes all the characters in the instance that begin at a specified position and continue through the last position.
  • Reverse - Reverses the order of the elements in the instance.
  • UpperCase - Returns a copy of the specified text value in capital letters, using the casing rule of the specified culture.
  • LowerCase - Returns a copy of the specified text value in small letters, using the casing rule of the specified culture.
  • TitleCase - Returns the specified text value in title case, except for the words that are in all capital letters, which are considered to be acronyms.
  • PadRight - Returns a new text value that left-aligns the characters in an instance by padding them on the right with a specified Unicode character, for a specified total length.
  • PadLeft - Returns a new text value that right-aligns the characters in an instance by padding them on the left with a specified Unicode character, for a specified total length.
  • Substring - Gets a substring from an instance. The substring starts at a specified character position and has a specified length.
  • GUID - Returns a text value of the GUID instance in a specific format.
  • Insert - Returns a new text value in which a specified text is inserted at a specified index position in the instance.
  • Trim - Remove all leading and trailing white space characters from the specified text.
  • XmlEncode - Returns the specified text with escape characters by adding slashes (/) to use in XML attributes.
  • XmlDecode - Returns the specified text as literal XML code.
  • Compare - Returns true if both the specified text values are the same. This function is case sensitive.
  • CompareIgnoreCase - Returns true if both the specified text values are the same. This function is not case sensitive.
  • Absolute - Returns the absolute value of a number.
  • Max - Returns the larger number of the two specified numbers.
  • Min - Returns the smaller number of the two specified numbers.
  • Power - Returns the specified number increased to the specified power.
  • Round - Rounds the decimal value to the nearest integral value.
  • Subtraction - Returns the difference of the specified n numbers. This function subtracts all numbers from the first number.
  • Sum - Returns the sum of the specified n numbers.
  • Average - Returns the mean of the specified numbers.
  • Multiple - Returns the product of the specified n numbers.
  • Modulo - Returns the remainder of the two specified numbers.
  • Percentage - Returns the percentage of the two specified numbers. Number1 represents current value and Number2 represents total value.
  • ToDecimal - Returns a decimal number.
  • ToDouble - Returns a double-precision floating-point number.
  • ToFloat - Returns a single-precision floating-point number.
  • ToLong - Returns a number to an equivalent 64-bit signed integer.
  • Currency - Shows the currency values in the format that you specify. This function shows the currency values with no decimal numbers.
  • Currency - Shows the currency values in the format that you specify. This function shows the currency values with a specified number of decimal places.
  • DateDiffDays - Calculates the difference in days between the two dates.
  • DateDiffHours - Calculates the difference in hours between the two dates.
  • DateDiffMinutes - Calculates the difference in minutes between the two dates.
  • DateDiffSeconds - Calculates the difference in seconds between the two dates.
  • FormatDate - Shows the date-time value in the format that you specify.
  • AddYears - Returns a new date that is result of addition of the specified number of years to the specified date value.
  • AddMonths - Returns a new date that is result of addition of the specified number of months to the specified date value.
  • AddDays - Returns a new date that is result of addition of the specified number of days to the specified date value.
  • AddHours - Returns a new date that is result of addition of the specified number of hours to the specified date time value.
  • AddMinutes - Returns a new date that is result of addition of the specified number of minutes to the specified date time value.
  • AddSeconds - Returns a new date that is result of addition of the specified number of seconds to the specified date time value.
  • AddMilliSeconds - Returns a new date that is result of addition of the specified number of milliseconds to the specified date time value.
  • AddTicks - Returns a new date that is result of addition of the specified number of ticks to the specified date time value.
  • ParseDateTime - Converts the specified string representation of a date and time into its date and time value with the specified date format.
Default Value:
None
Example:
Refer to:
Limitations:
The Currency function that supports the decimal point is available in these releases:

Description

Function:
Specifies the details of the function.
Default Value:
Read only.

Apply

Function:
Uses the configured formulas in your inline function.
Example:
Refer to: