[SOLVED] Validation in Editable Grids in Dynamics 365 Customer Engagement not working.



Blog Validation Thumbnail
Introduction
In this blog we will be discussing about the Business Rule validation issue in  Editable grids caused when the fields are not present in the views.

Scenario
In our demonstration we will take the example of a contact form and design a business rule to lock the email field if the Job Title field is blank. 

Implementation
Step 1: First we enable editable gird for the contact entity as shown in the image below

Editable Grid Configuration


Step 2:  Then we create a business rule for the contact form  to lock the Email field if the Job Title field is blank. The Business Rule is shown below

Business Rule

Step 3: Now in the editable grid we can see that the Email field is locked as the Job Title is blank.
Ediable Grid

The field is unlocked once the job title is entered
Email Field Unlocked


Step 4: Now we edit the criteria of the Business Rule and add a new condition to also check if the Description field contains data  as shown in the image below.

Business Rule


Step 5: When we go to the editable grid we see that even though the Job Title field is blank the Email field is unlocked which should have been locked.
No Job Title

Step 6: The reason behind this is that the My Active Contacts view does not contain the field description hence the validation fails.
Step 7: To solve this we add the Description column to the view as shown below.
Views
Step 8: Now if we check in the editable grid we see that the validation works correctly and the email field is locked.
Email Field Locked
Conclusion
This is important to be noted as , if there is some validation done using business rules, JavaScript  and field is not present in the views the validation wont work and there will be incorrect data entries made using the editable grid. 

Comments

Post a Comment

Popular posts from this blog

Run Workflow directly from a button in Dynamics 365 Customer Engagement V9.0

Image
Introduction: In this blog we will demonstrate how to call a workflow directly from a button without any custom JavaScript code. Implementation: Step 1:  Create the required workflow. In this example i have created a  simple workflow on the opportunity and remember to select the  “As an on-demand process” option. Step 2:  After the workflow is created store the GUID of the workflow. To get the GUID select the workflow and copy down the ID from the URL as shown in the below image. Step 3:  Now create the custom button on Opportunity entity using Ribbon Workbench. Step 4:  Create a new Command and click on “Add Action>JavaScript Action” as shown in the image. Step 5:  In the library option write the following “ /_static/_forms/form.js ” and in the Function Name field “ Mscrm.FormAction.launchOnDemandWorkflowForm “. Then as shown in the above image add two Parameters as follows: Crm Parameter = PrimaryEntityTyp...
Read more

Create and Associate Records in a single operation using Xrm.WebAPI in D365 Customer Engagement

Image
Introduction In this blog we will demonstrate how to create and associate records using Xrm.WebApi which provides methods to use Web Api to create and manage records. Implementation Step 1: The syntax to create a new entity record is as follows: Here entityLogicalName(string) and data(object) parameters are required where,  "data" is the JSON object defining the attributes and values for the new record. Step 2: In this example we will create a sample account record along with a primary contact for that account, associate an opportunity to the account and create task and notes for the opportunity all in a single operation. This type of process if called deep insert. The code for the same is as shown below: Screenshots: 1. A New Account is created with the name “CRAYONS LTD” and in the primary contact file the primary contact is set with the name Clinton Dmello as set in the code. 2. Also an opportunity is associated to the account as shown below in the associate...
Read more

Use Audit Logs in Dynamics 365 : Actionable Audit

Image
Introduction: In this blog we will see how audit logs in D365 can be fetched that can be used for reporting purposes. Auditing helps to track changes made to the data in D365. The System Auditing entity cannot be accessed. Actionable Audit is a App by Microsoft Labs in which the required audit logs can be stored in the actionable audit entity which can be used later on by fetching the records of that entity. This audit log can be helpful to create Dashboards in Power BI, create reports etc to get meaningful information from the data. Implementation: Step 1: First we enable the auditing for the organization(globally) in Settings > Auditing Step 2: We then enable auditing for the required entities and fields. Step 3: Download the Actionable audit app from the AppSource  Step 4: After accepting the terms and condition is done, it will take some time to install the solution as shown in the notification below.  Step 5: In the plug-in registration tool we can see the assembl...
Read more