• 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)

889 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  No
Related Articles
  • Sample Templates 
  • Step-by-Step: How to create an account sales report template
  • Step-by-Step: How to create a NDA-contract template 
  • Step-by-Step: How to create a work order template
  • Step-by-Step: How to create a quote template 
  • Step-by-Step: How to create an initial contact template for a lead
Latest Articles
  • Sample Templates 
  • Step-by-Step: How to create an account sales report template
  • Step-by-Step: How to create a NDA-contract template 
  • Step-by-Step: How to create a work order template
  • Step-by-Step: How to create a quote template 
Popular Articles
  • DocumentsCorePack Template Designer – Getting Started
  • Step-by-Step: How to configure a One-Click-Action
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • mscrm-addons.com Application Access for Dynamics 365 (App Access) – DocumentsCorePack
  • DocumentsCorePack Online Service Configuration
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
  • Step-by-Step: How to configure a One-Click-Action
  • How licenses are counted
Categories
  • *News and General Infos* 52
  • Webinars 37
  • Template Designer(DCP 192
  • DocumentsCorePack(DCP 204
  • TelephoneIntegration (TI 65
  • AttachmentExtractor (AE 64
  • PowerSearch (PS 48
  • ActivityTools (AT 59
  • SmartBar (SB 53
  • GroupCalendar (GC 46
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.