• Release History
  • Documentation
  • Back to www.mscrm-addons.com
  • Release History
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)/DocumentsCorePack Condition Syntax (Dynamics 365)

DocumentsCorePack Condition Syntax (Dynamics 365)

1921 views 0 Updated on March 14, 2023

Certain properties of DocumentsCorePack templates consist of conditions based on Dynamics 365 fields. This article covers the basic syntax and the advanced options that can be used.
Several DocumentsCorePack properties support the same syntax. A list of these properties can be found at the end of this article.

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

    Figure 1: Fields

    Fixed text has to be typed manually into the text field and has to be enclosed with single quotes ( ‘ ).

    Figure 2: Fixed text

    Values from User Prompts can be used by placing the name of the user-prompt enclosed by << and >>.
    User Prompt as Field property
    To combine several Dynamics 365 fields and fixed text you have to use the plus sign (+). (see figure 3)

    Figure 3: Combining properties via ‘+’ sign.

  2. Supported datatypes and available operators
Datatype Value
Bool True, false, 0, 1
Decimal/Numbers Format z.B.: 1.1
Currency € 1.1 or $1.1 (when decimal, the currency symbols €, $ are deleted)
Date #2015-12-13# or #2015-12-13T12:00:59+01:30#
Text
Operator Description Used with the following datatypes
= equals for each
<> does not equal for each
> greater than for each
< less than for each
>= greater than or equal for each
<= less than or equal for each
+ addition Decimal, Numbers, Currency, Text
– substraction Decimal, Numbers, Currency
* multiplication Decimal, Numbers, Currency
/ division Decimal, Numbers, Currency
% modulo Decimal, Numbers, Currency
LIKE LIKE comparison, wildcard *,% text

Boolean Operators: AND, OR, NOT

  1. Special values and functions
Null / NULL null
true true
false false
ISNULL ISNULL(field, substitute value)
LEN LEN(text) returns the string-length
IIF IIF(condition, valuetrue, valuefalse)
TRIM TRIM(text) deletes the whitespace at the beginning/end
SUBSTRING SUBSTRING(text, start, len)
CONVERT CONVERT(value, destType) destType must be a .Net datatype, e.g.: System.Int32

This syntax applies to the following properties and special fields:

Template Properties 

  • Remove Watermark

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

#reworkneeded..Titel ist irreführend

Was this helpful?

Yes  2 No
Related Articles
  • Ensuring correct time zone display for DateTime fields
  • How to compare a date-fields with the current date 
  • Create a template for XML or plain text
  • E-Invoicing with DocumentsCorePack
  • How to add content from SharePoint to a document
  • Using MS Word field codes in DocumentsCorePack templates
Latest Articles
  • Document Generation via Copilot in Dynamics 365 Sales using DocumentsCorePack
  • DocumentsCorePack: Best practices for Dynamics 365 on-premises to online migration projects
  • Multilingual Support in DocumentsCorePack
  • Recap: ColorCloud 2025
  • Configure DocumentsCorePack within custom pages
Popular Articles
  • DocumentsCorePack Template Designer – Getting Started
  • Step-by-Step: How to configure a One-Click-Action
  • Application Access for Dynamics 365
  • How to find your environment’s unique name in Microsoft Dynamics 365
  • How licenses are counted
Top Rated Articles
  • “Undefined”-labels in Chrome and Edge 114 and higher
  • Important information for Dynamics 365 online customers using DocumentsCorePack and/or AttachmentExtractor
  • How to activate the DocumentsCorePack Connector for PowerApps & Microsoft Flow
  • How licenses are counted
  • How to insert Condition Fields in DocumentsCorePack Templates designer
Categories
  • *News and General Infos* 62
  • Webinars 45
  • Template Designer(DCP 196
  • DocumentsCorePack(DCP 251
  • TelephoneIntegration (TI 65
  • AttachmentExtractor (AE 72
  • PowerSearch (PS 50
  • ActivityTools (AT 61
  • SmartBar (SB 54
  • GroupCalendar (GC 47
Our Vision

“We see it as our purpose to provide products that simplify and speed up our customers’ Microsoft Dynamics 365 experience.”

Knowledgebase
LogIn
mscrm-addons.com
  • Products
  • Online Shop
  • Downloads
  • My Account
About Us
  • About Us
  • Case Studies
  • Newsletter
  • Partner Program
  • Contact
Support
  • Support
  • Terms & Conditions
  • Documentation
  • Webinars
  • Legal Documents
  • Impressum
  • © 2022 www.mscrm-addons.com. All Rights Reserved.