knowledgecenter-breadcrum

Knowledge Center

03 Jul, 2022

How to lock fields on editable grid in D365 CE?

Posted on 03 Jul, 2022 by Admin, Posted in Dynamics 365 , Power Platform , Dynamics-365 Sales

How to lock fields on editable grid in D365 CE? Blogs

Introduction:
Recently I got a situation where I need to lock the fields in editable grid. I tried to find the solution on internet. I found a suggestion as to use business rule having scope to “Entity”. But it did not worked as it was locking the fields on forms also. Then I created another business rule having scope to “All Forms” to unlock fields. But it was unlocking the fields on grid also. So, decided to add a script on view load, but there is no event for that. There are only onSave and onRecordSelect handlers for views. Then I learned that whenever we try to edit a field the records automatically get selected. So, I can achieve desired result by adding script on onRecordSelect event handler.

In this blog I am going to explain how to lock fields on editable grid.

Step-by-Step:
Create a newscript web resource and add below code
function fnLockFields(executionContext) {
      let oFormContext = executionContext.getFormContext();
      if (oFormContext) {
          let arrFields = ["subject", "regardingobjectid", "ownerid"];
          let objEntity = oFormContext.data.entity;
          objEntity.attributes.forEach(function (attribute, i) {
                 if (arrFields.indexOf(attribute.getName()) > -1) {
                    let attributeToDisable = attribute.controls.get(0);
                    attributeToDisable.setDisabled(true);
                 }
          }
});
}

Now, go to Settings -> Customization -> Customize the System -> Entities(select your entity) -> Events -> Add Web resource library->Add OnRecordSelect event handler and add function name.

Pass the execution context as first parameter.
Save and publish.
Now, when you try to edit any locked attribute, selected attributes will be locked.

Comment

Loading

Recent Updates

Thumbnail D365 for Marketing
Blogs
16 Dec, 2024

10 Reasons Why You Need Dynamics 365 for Marketing

This blog discusses the top 10 reasons to choose Dynamics 365 for Marketing to improve your business's marketing efforts.  …

READ MORE
Thumbnail_top 10 benefits of
Blogs
02 Dec, 2024

Top 10 Benefits of Microsoft Dynamics 365

This blog lists the advantages of Microsoft Dynamics 365, focusing on how it can improve your business operations.    …

READ MORE
Thumbnail_Microsoft365 Vs D365
Blogs
12 Nov, 2024

Microsoft 365 vs Dynamics 365

This blog will help you understand the key difference between Microsoft 365 and Dynamics 365, so you can make an…

READ MORE