How to make Dynamics 365 editable grid read only on a field change

(0) Share

Report

Posted on by Shaik

Hi,

We have a business requirement to make dynamics 365 editable grid read only, we need to restrict user not to edit any more records after a field value is changed on a form, any suggestions ?

Thanks,

Shaik

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

Amine Amine 132 on at

Like (0)

Report

Hi,
You can use JavaScript .

Editable Grid support the below JavaScript events :

OnRecordSelect

OnSave

OnChange

See this :

community.dynamics.com/.../dynamics-365-editable-grids-javascript-example

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report
Hi Shaik,

Try the code below. Register this function on change of the field.

function DisableSubgrid(){ // Get field value var value = Xrm.Page.getAttribute("AttributeName").getValue(); // Get subgrid control var subGridCtrl = Xrm.Page.getControl("SubgridName"); //Check the field value if(value == 'value') { // Disable the subgrid control subGridCtrl.disabled = true; } }

Hope this helps.

Was this reply helpful? Yes No
Shaik on at

Like (0)

Report

Hi Nithya - Thanks for your reply. we tried above code, its not working for Microsoft Dynamics CRM 365 editable subgrid, any other suggestions you have ?

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report
Hi,

Please replace the code as shown below.

function DisableSubgrid(){ // Get field value var value = Xrm.Page.getAttribute("AttributeName").getValue(); // Get subgrid control var subGridCtrl = Xrm.Page.getControl("SubgridName"); //Check the field value if(value == 'value') { // Disable the subgrid control subGridCtrl.setDisabled(true); } }

Was this reply helpful? Yes No
Iswarya 1,347 on at

Like (1)

Report

hi,

i too have same requirement please guide to achieve this

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (1)

Report

You need to get the context of the subgrid. Once you get the context, you can run the following code:

function setGridReadOnly(context) {

var entityObject = context.getFormContext().data.entity;

entityObject.attributes.forEach(function (attribute, i) {

var ctrl = attribute.controls.get(0);

ctrl.setDisabled(true);

}

});

}

The code does not disable the subgrid, but disables all the columns/cells in the subgrid

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Aric, I tried implementing the code, I couldn't achieve disabling the columns/cells in the subgrid. Though I have triggered the script on record select.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

What happens when you click on a row in the grid. Does it show locks next to each field, or are they editable?

The code above does not make the subgrid read only just disabled the columns in each row.

When you attached the code to the RecordSelect event, did you check the Pass Execution Context checkbox?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
I hope following code helps, but you have to select every record to make it non editable.

var editableGridLoadRetryCount = 0; function CRMEditableGrid_DisableFields(gridName) { var editableGridControl = Xrm.Page.getControl(gridName); // addOnRecordSelect doesn't work until the grid has propertly loaded. if (editableGridControl.getGrid().getTotalRecordCount() == 0 && editableGridLoadRetryCount <= 3) { editableGridLoadRetryCount = editableGridLoadRetryCount + 1; setTimeout("CRMEditableGrid_DisableFields(\"" + gridName + "\")", 500); return; } // Make fields read-only in Grid. editableGridControl.getGrid().addOnRecordSelect(function (executionContext) { var entityObject = executionContext.getFormContext().data.entity; entityObject.attributes.forEach(function (attribute, i) { if (attribute.getName() == "emailaddress1") { var emailControl = attribute.controls.get(0); emailControl.setDisabled(true); break; } }); } ); }

Thanks!!!

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Guys,

Code is Ok, apart from syntax error :) just to be precise.

function EditableGridReadOnly(context){

var entityObject = context.getFormContext().data.entity;
entityObject.attributes.forEach(function (attribute, i) {
var ctrl = attribute.controls.get(0);
ctrl.setDisabled(true);
}
)}

On the same, where do you get grid name?

Was this reply helpful? Yes No