• Documentation
  • Back to www.mscrm-addons.com
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)/The “Insert Computed-Field”-button in Open Office XML template (.docx)

The “Insert Computed-Field”-button in Open Office XML template (.docx)

115 views 0 Updated on March 25, 2020

This article outlines the new “Insert”-functionalities within the “Computed Items”-button in Open Office XML template (.docx). The “Insert Computed-Fields”-button allows you to make basic arithmetical operations with CRM-number-fields. Important: It is crucial that the CRM-fields contain a number!

Requirements: Available for DocumentsCorePack for MS CRM 2013, v6.10 and higher. All our addons come with a 14 days free trial! Please click here to download and test it!

Example: 

 

image_thumb[15]

 

Figure 1: Use the math functions of the Computed-Fields functionality and a possible result after the merge.

OVERVIEW: “Computed-Items”-button 

The new “Computered Items”-button contains following new functionalities:

  • The “Insert Advanced String-Field”-button: allows you to insert as many fields as you want in one single field.
  • The “Insert Computed-Field”-button: allows you to make basic arithmetical operations with CRM-number-fields.

 

image_thumb10

 

image_thumb11

Figure 2: Computed Items > Insert String/Computed field

As you can see in the screenshot above we have rearranged  the “Insert QR Code-Field”-button to be found under “Computed Items”.

Click here to read more about the other useful functionalties of the “Insert”-button.

GENERAL INFORMATION 

The “Insert Computed-Fields”-button allows you to make basic arithmetical operations with CRM-number-fields. Important: It is crucial that the CRM-fields contain a number! There are already predefined CRM-number-fields.

 

image_thumb45

Figure 3: Predefined CRM number fields

Note: You can define other CRM-fields to be a number field. E.g: if you don’t need the “Middle Name”-field in the contact entity and rather prefere to type in any number, this field can also be inserted and calculated! In this case you will see next message box:

 

image_thumb[7]

Figure 4: Message box – no number field

HOW TO: Use the “Insert Computed-Field”-button, step-by-step description

1. Open DocumentsCorePack Task Pane 
You can find the new function in the “DocumentsCorePack Task Pane”. To get there, please open an existing or create a new template. Got to the “www.mscrm-addons.com”-tab, click on “Insert MailMerge Fields” in the toolbar and create a “Office Open XML (.docx)“-document by answering the question with [Yes]. See screenshot below:


Figure 5: Open DCP Task Pane

The “DocumentsCorePack Task Pane” appears.

 

image

Figure 6: DCP Task Pane

2. Choose the appropriate “Insert”-functionality
Click on the [Insert] drop-down-button and choose the “Insert Advanced String”-functionality. See next screenshot:

 

image_thumb[3]

 

image_thumb[4]

Figure 7: Insert Computed-Fields

3. Add/Subtract/Divide/Multiply CRM-number and money-fields
In the next window you have the possibility to make basic arithmetical operations with CRM-number-fields by inserting add +, subtract –, divide / and multiply * number-fields with a double-click. You can also define a name for this field e.g. “Invoice Dec. 213”. If no name is typed in the default name “Computed Field” will be set.

 

image_thumb[15]

Figure 8: Add/Subtract/Divide/Multiply CRM number and money fields

4. The result
If the calculation can be performed you will see the result value in the merged document.

 

Figure 9: Result 

If the calculation can not be evaluated you will see this result in your document. This might be the case if your calculation uses a string field that does not contain a number as a value. See next screenshot, click to enlarge:


Figure 10: Result – Error 

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

reworkneeded .. multiple articles about the same .. merge to one

Was this helpful?

Yes  No
Related Articles
  • How to solve the issue with DocumentsCorePack fields in Arabic text
  • How to access mscrm-addons product settings in Dynamics 365
  • How to create totals in the footer of a table
  • How to set a specific Language in your Template
  • Azure Active Directory Licensing counts explained
  • When to use the „Do not use DataProvider“-setting in DocumentsCorePack
Latest Articles
  • How to display various activity-attributes within multiple rows in Gantt view
  • Recap: European Power Platform Conference 2022
  • How to solve the issue with DocumentsCorePack fields in Arabic text
  • How to access mscrm-addons product settings in Dynamics 365
  • One-Click-Actions (OCAs) in DocumentsCorePack
Popular Articles
  • DocumentsCorePack Online Service Configuration
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • mscrm-addons.com Application Access for Dynamics 365 (App Access) – DocumentsCorePack
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • How licenses are counted
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
  • Can you save data capacity by moving email content?
  • DocumentsCorePack Property Syntax (Dynamics 365)
Categories
  • *News and General Infos* 50
  • Template Designer(DCP 160
  • DocumentsCorePack(DCP 180
  • TelephoneIntegration (TI 64
  • AttachmentExtractor (AE 55
  • PowerSearch (PS 43
  • ActivityTools (AT 57
  • SmartBar (SB 51
  • GroupCalendar (GC 45
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
  • © 2020 www.mscrm-addons.com. All Rights Reserved.