The following table contains a list of all available functions that can be applied to Dynamics 365 fields.
For all examples bellow please assume the <> field will be MSCRM-addons.com after the merge.

Function

Description

Example

<>.pos(x,y)

will insert y signs from the xth
position.

<>.pos(2,5)
Result: "CRM-a"

<>.left(x)

will insert the first x – signs.
E.g.: <>.left(5)

<>.left(5)
Result: "MSCRM"

<>.right(x)

will insert the last x signs of the string. E.g.: <>.right(3)

<>.right(3)
Result: "com"

<>.upper()

displays all values in the field in capital letters.

Result: "MSCRM-ADDONS.COM"

<>.lower()

displays all values in the field in small letters.

Result: "mscrm-addons.com"

<>.caps()

displays the first letter in the field before as capital letter.

Result: "Mscrm-addons.com"

<>.firstcaps()

displays the first letter in a
sentence in capital letter

Mscrm-addons.com

<>.invert()

reverses every case

Result: "mscrm-ADDONS.COM"

The following table contains a list with all available functions that can be applied to Dynamics 365 fields

Function

Description

Example

guid()

generates a unique serial
number

b8a4d649-342e-4bfc-9a6f-b4afd4741b4

DATETIME()

inserts the actual and local date
and time

06.12.2013 16:06

DATETIME(dd.MMMM.yy, de-DE)

there are many different
formatting options for displaying
the culture name for different
countries For more information
please click here.

06.Dezember.13

DATETIME(DD.MMMM.YY ' '
mm:ss, de-DE)

For more information about the
different cultures which can be
displayed, please click here.

06.Dezember.13 16:06