• Release History
  • Documentation
  • Back to www.mscrm-addons.com
  • Release History
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)/How to create relationships using DocumentsCorePack Template Designer (Advanced)

How to create relationships using DocumentsCorePack Template Designer (Advanced)

1440 views 0 Updated on November 21, 2022

This article outlines how to create more complex relationships in the DocumentsCorePack (DCP) Template Designer.

The following three step-by-step tutorials will teach you how to create and manage these complex relationships with the DCP Template Designer “Additional” tab. Essentially, relations can be solved for 1:N (1:many) and N:N (many:many) relationships. All custom entities, as well as system entities, are supported.

Step-by-Step Video:

Tutorial 1: How to add a predefined relationship

Predefined relationships are helpful when you create a common template, for example, a quote template. With a predefined relationship, you do not have to manually create a new template every time.

Step 1: Create a new template

For further information on how to create a template, please read this blog article.

Step 2: Navigate to the “Additional” tab in the Template Designer
Next, open the “Additional” tab. It has been designed to manage additional relationships.

Figure 1: DCP Template Designer – Additional tab​

Step 3: Add a relationship/entity
A click on the “Add Relationship/Entity” button will open the relationship designer (see tutorial 2), while a click on the Dropdown Arrow expands a menu with predefined relationships.

Figure 2: The [Add Relationship/Entity]-button

Figure 3: Add Relationship/Entity dropdown menu – predefined relationships

The highlighted area in Figure 3 shows all predefined relationships. DocumentsCorePack already has a variety of different predefined relationships for standard CRM entities ready for you (for example, All Contacts of an Account, Quote Products of a Quote, etc). They facilitate the creation of templates. Simply click on the predefined relationship to add it. The related fields will then be visible in the Template Designer TreeView.

Tutorial 2: How to add a relationship from scratch

When you are dealing with more complex relationships, it can be helpful to create a relationship from scratch.

Step 1: Create a template and insert fields
For further information on how to insert fields, read this blog article. As you see below, we have inserted the following fields: <<accountid>> and <<name>>

Figure 4: Insert fields

Step 2: Add a new relationship

Next, go to the “Additional” tab and open the “Add Relationship/Entity” dropdown menu. Then, select “Add New Relationship…”

Figure 5: Add New Relationship

The Configure Fields and Datasource dialog will open. Select a relationship you would like to insert ❶ and add attributes by checking the boxes next to the attributes ❷. In the example below, we have chosen the relationship “Account -> Activity [regardingobjectid]” and added the following attributes: “Activity”, “Actual End”, “Actual Start”, “Due Date”.

Figure 6: Add a new relationship

The chosen attributes of the entity are now also visible in the “Additional” tab of the Template Designer. From here you can insert any of the fields into the document. But usually, there are more complex relationships needed. That is why you may expand the complexity of the relationship by adding more levels.

Figure 7: Resolved fields

Step 3: Add further relationships

If you would like to add further relationships, click on “Edit” in the “Additional” tab.

Figure 8: Click on the [Edit]-button

This action opens the Configure Fields and Datasource dialog again, providing you with the former established relationship. Select “Add” ❶ and add another relationship ❷ here. In the example below, we added “Activity [activityid] -> Attachment [objected]” and the entities “Attachment Number”, “Entity”, “File Name”, “Subject”. ❸

Figure 9: Add another relationship

As you can see, the resolved entities are now also visible in the “Additional” tab of the Template Designer. From here you can insert any of the fields into the document.

Figure 10: Additionally resolved fields

Please Note: You may repeat these steps as often as you would like to in order to enhance the complexity of your relationships.

​

Tutorial 3: How to create a relation to a separate entity
The creation of a relation to a separate entity follows the same rules as the creation of an entity from scratch (with one exception). In order to create a relation to a separate entity, follow the steps in Tutorial 2 carefully, but make sure that you change the following parameter when you select a new relationship:

Instead of checking “Relationships”, check “Separate Entities” ❶ in the “Select existing Relation” section. The main difference is that you will now be provided with separate entities ❷ instead of relationships.

Figure 11: Insert separate entities

Additional Filtering

The most common additional steps when adding a relationship is adding additional filters to limit returned results. For example, if you only want to see active records, you would add an additional filter for that. How to create or modify additional filters is described here.

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

Was this helpful?

Yes  1 No
Related Articles
  • Office Theme Support of DocumentsCorePack
  • Dynamic Document Properties
  • Switch environments in the DocumentsCorePack Template Designer
  • Working with Field Service Inspection responses
  • Create an inspection report for a Work Order
  • Create an inspection report for a Work Order Service Task
Latest Articles
  • New DocumentsCorePack Connector features for Power Automate
  • Office Theme Support of DocumentsCorePack
  • AssureSign for DocumentsCorePack
  • Dynamic Document Properties
  • How to conditionally remove a watermark in DocumentsCorePack templates
Popular Articles
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • mscrm-addons.com Application Access for Dynamics 365 (App Access) – DocumentsCorePack
  • DocumentsCorePack Template Designer – Getting Started
  • DocumentsCorePack Online Service Configuration
  • Step-by-Step: How to configure a One-Click-Action
Top Rated Articles
  • 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
  • Online Services: Required Application Permissions
  • Information on Security roles: Which roles are needed for which solution?
Categories
  • *News and General Infos* 51
  • Webinars 35
  • Template Designer(DCP 173
  • DocumentsCorePack(DCP 191
  • TelephoneIntegration (TI 65
  • AttachmentExtractor (AE 62
  • 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.