News.mscrm-addons.com Blog

DocumentsCorePack Property Syntax (Dynamics 365)

Wed, 25 Nov 2015 13:39:00 GMT

Certain properties of DocumentsCorePack templates consist of fixed text and Dynamics 365 fields. There are also some additional function calls available and data
from Dynamics 365 can also be manipulated.
Several DocumentsCorePack properties support the same syntax. A list of these
properties can be found at the end of this article. This article covers the basic syntax and the advanced options that can be used

The basic syntax:
Fields from Dynamics 365 are enclosed by << and >> when you insert them from the tree view.

Figure 1: Fields

Fixed text must be typed manually into the text field and must be enclosed by single quotes (' ).

Figure 2: String
To combine several Dynamics 365 fields and fixed text you have to use the plus sign (+).

Figure 3: Plus
The advanced syntax:
Function calls can be applied to Dynamics 365 fields by using a . (dot) and the actual function call.
There are also standalone method calls supported. The function call must end with brackets.
Certain functions may also support parameters or have mandatory parameters.

Figure 4: Function pos with parameters 2 and 5

Figure 5: Standalone function DATETIME without parameters

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

This syntax applies to the following properties and special fields:

Template Properties

Document Name and Subject
Sub Folder
Sharepoint Metadata

Special Document Fields

Calculated Fields
Advanced String
Hyperlink field
QR Code

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.

DocumentsCorePack: Custom Date and Time Format Strings

Fri, 06 Dec 2013 16:16:00 GMT

The following table shows the different custom date and time format strings for displaying the DATETIME() function for DocumentsCorePack templates (.docx).

Format specifier	Description	Examples
"d"	The day of the month, from 1 through 31.	6/1/2009 1:45:30 PM -> 1 6/15/2009 1:45:30 PM -> 15
"dd"	The day of the month, from 01 through 31.	6/1/2009 1:45:30 PM -> 01 6/15/2009 1:45:30 PM -> 15
"ddd"	The abbreviated name of the day of the week.	6/15/2009 1:45:30 PM -> Mon (en-US) 6/15/2009 1:45:30 PM -> Пн (ru-RU) 6/15/2009 1:45:30 PM -> lun. (fr-FR)
"f"	The tenths of a second in a date and time value.	6/15/2009 13:45:30.617 -> 6 6/15/2009 13:45:30.050 -> 0
"ff"	The hundredths of a second in a date and time value.	6/15/2009 13:45:30.617 -> 61 6/15/2009 13:45:30.005 -> 00
"fff"	The milliseconds in a date and time value.	6/15/2009 13:45:30.617 -> 617 6/15/2009 13:45:30.0005 -> 000
"ffff"	The ten thousandths of a second in a date and time value.	6/15/2009 13:45:30.6175 -> 6175 6/15/2009 13:45:30.00005 -> 0000
"fffff"	The hundred thousandths of a second in a date and time value.	6/15/2009 13:45:30.61754 -> 61754 6/15/2009 13:45:30.000005 -> 00000
"ffffff"	The millionths of a second in a date and time value.	6/15/2009 13:45:30.617542 -> 617542 6/15/2009 13:45:30.0000005 -> 000000
"fffffff"	The ten millionths of a second in a date and time value.	6/15/2009 13:45:30.6175425 -> 6175425 6/15/2009 13:45:30.0001150 -> 0001150
"F"	If non-zero, the tenths of a second in a date and time value.	6/15/2009 13:45:30.617 -> 6 6/15/2009 13:45:30.050 -> (no output)
"FF"	If non-zero, the hundredths of a second in a date and time value.	6/15/2009 13:45:30.617 -> 61 6/15/2009 13:45:30.005 -> (no output)
"FFF"	If non-zero, the milliseconds in a date and time value.	6/15/2009 13:45:30.617 -> 617 6/15/2009 13:45:30.0005 -> (no output)
"FFFF"	If non-zero, the ten thousandths of a second in a date and time value.	6/1/2009 13:45:30.5275 -> 5275 6/15/2009 13:45:30.00005 -> (no output)
"FFFFF"	If non-zero, the hundred thousandths of a second in a date and time value.	6/15/2009 13:45:30.61754 -> 61754 6/15/2009 13:45:30.000005 -> (no output)
"FFFFFF"	If non-zero, the millionths of a second in a date and time value.	6/15/2009 13:45:30.617542 -> 617542 6/15/2009 13:45:30.0000005 -> (no output)
"FFFFFFF"	If non-zero, the ten millionths of a second in a date and time value.	6/15/2009 13:45:30.6175425 -> 6175425 6/15/2009 13:45:30.0001150 -> 000115
"g", "gg"	The period or era.	6/15/2009 1:45:30 PM -> A.D.
"h"	The hour, using a 12-hour clock from 01 to 12.	6/15/2009 1:45:30 AM -> 1 6/15/2009 1:45:30 PM -> 1
"hh"	The hour, using a 12-hour clock from 01 to 12.	6/15/2009 1:45:30 AM -> 01 6/15/2009 1:45:30 PM -> 01
"H"	The hour, using a 24-hour clock from 0 to 23.	6/15/2009 1:45:30 AM -> 1 6/15/2009 1:45:30 PM -> 13
"HH"	The hour, using a 24-hour clock from 00 to 23.	6/15/2009 1:45:30 AM -> 01 6/15/2009 1:45:30 PM -> 13
"K"	Time zone information.	With DateTime values: 6/15/2009 1:45:30 PM, Kind Unspecified -> 6/15/2009 1:45:30 PM, Kind Utc –> Z 6/15/2009 1:45:30 PM, Kind Local -> -07:00 (depends on local computer settings) With DateTimeOffset values: 6/15/2009 1:45:30 AM -07:00 --> -07:00 6/15/2009 8:45:30 AM +00:00 --> +00:00
"m"	The minute, from 0 through 59.	6/15/2009 1:09:30 AM -> 9 6/15/2009 1:09:30 PM -> 9
"mm"	The minute, from 00 through 59.	6/15/2009 1:09:30 AM -> 09 6/15/2009 1:09:30 PM -> 09
"M"	The month, from 1 through 12.	6/15/2009 1:45:30 PM -> 6
"MM"	The month, from 01 through 12.	6/15/2009 1:45:30 PM -> 06
"MMM"	The abbreviated name of the month.	6/15/2009 1:45:30 PM -> Jun (en-US) 6/15/2009 1:45:30 PM -> juin (fr-FR) 6/15/2009 1:45:30 PM -> Jun (zu-ZA)
"MMMM"	The full name of the month.	6/15/2009 1:45:30 PM -> June (en-US) 6/15/2009 1:45:30 PM -> juni (da-DK) 6/15/2009 1:45:30 PM -> uJuni (zu-ZA)
"s"	The second, from 0 through 59.	6/15/2009 1:45:09 PM -> 9
"ss"	The second, from 00 through 59.	6/15/2009 1:45:09 PM -> 09
"t"	The first character of the AM/PM designator.	6/15/2009 1:45:30 PM -> P (en-US) 6/15/2009 1:45:30 PM -> 午 (ja-JP) 6/15/2009 1:45:30 PM -> (fr-FR)
"tt"	The AM/PM designator.	6/15/2009 1:45:30 PM -> PM (en-US) 6/15/2009 1:45:30 PM -> 午後 (ja-JP) 6/15/2009 1:45:30 PM -> (fr-FR)
"y"	The year, from 0 to 99.	1/1/0001 12:00:00 AM -> 1 1/1/0900 12:00:00 AM -> 0 1/1/1900 12:00:00 AM -> 0 6/15/2009 1:45:30 PM -> 9
"yy"	The year, from 00 to 99.	1/1/0001 12:00:00 AM -> 01 1/1/0900 12:00:00 AM -> 00 1/1/1900 12:00:00 AM -> 00 6/15/2009 1:45:30 PM -> 09
"yyy"	The year, with a minimum of three digits.	1/1/0001 12:00:00 AM -> 001 1/1/0900 12:00:00 AM -> 900 1/1/1900 12:00:00 AM -> 1900 6/15/2009 1:45:30 PM -> 2009
"yyyy"	The year as a four-digit number.	1/1/0001 12:00:00 AM -> 0001 1/1/0900 12:00:00 AM -> 0900 1/1/1900 12:00:00 AM -> 1900 6/15/2009 1:45:30 PM -> 2009
"yyyyy"	The year as a five-digit number.	1/1/0001 12:00:00 AM -> 00001 6/15/2009 1:45:30 PM -> 02009
"z"	Hours offset from UTC, with no leading zeros.	6/15/2009 1:45:30 PM -07:00 -> -7
"zz"	Hours offset from UTC, with a leading zero for a single-digit value.	6/15/2009 1:45:30 PM -07:00 -> -07
"zzz"	Hours and minutes offset from UTC.	6/15/2009 1:45:30 PM -07:00 -> -07:00
":"	The time separator.	6/15/2009 1:45:30 PM -> : (en-US) 6/15/2009 1:45:30 PM -> . (it-IT) 6/15/2009 1:45:30 PM -> : (ja-JP)
"/"	The date separator.	6/15/2009 1:45:30 PM -> / (en-US) 6/15/2009 1:45:30 PM -> - (ar-DZ) 6/15/2009 1:45:30 PM -> . (tr-TR)
"string" 'string'	Literal string delimiter.	6/15/2009 1:45:30 PM ("arr:" h:m t) -> arr: 1:45 P 6/15/2009 1:45:30 PM ('arr:' h:m t) -> arr: 1:45 P
%	Defines the following character as a custom format specifier.	6/15/2009 1:45:30 PM (%h) -> 1
\	The escape character.	6/15/2009 1:45:30 PM (h \h) -> 1 h
Any other character	The character is copied to the result string unchanged.	6/15/2009 1:45:30 AM (arr hh:mm t) -> arr 01:45 A

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.