Inline Functions activity

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

Add

Opens this Screen:

Inline Functions

Function of this Screen:

Configures one or more formulas..

Example:

Refer to:

• (Example) Create an Inline Function

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:

• (Example) Create an Inline Function

Formula

Function:

Shows the formula that changes the data from your process or form control.

Example:

Refer to:

• (Example) Create an Inline Function

Edit

Function:

Changes the formula.

Delete

Function:

Deletes the formula.

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:

• (Example) Create an Inline Function

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:

• (Example) Create an Inline Function

Limitations:

The Currency function that supports the decimal point is available in these releases:

• AgilePoint NX OnDemand (public cloud)
• AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v7.0, Software Update 2, Cumulative Update 6 or higher.

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:

• (Example) Create an Inline Function