Chil grid, Need to disable a column while editing another

[Javier A Aguilera]

Good night gentlemen,

I'm having trouble with a child grid, I need to disable the column "EstatusID" while editing the column "DesarrolladorID" (both columns have values for their foreignKeyField like 1,2,3...etc)

The thing is, that when EstatusID is 1 I need DesarrolladorID column disabled.

And I need DesarrolladorID column enabled when Estatus has a value of 2 or a bigger number 

Also, I would like to know, when I edit EstatusID is there a way to set a value for column DesarrolladorID ??

columns: [

                { field: 'NumeroClientePorDesarrolladorID', visible: false, isPrimaryKey: true, isIdentity: true },

                { field: 'ClienteID', visible: false, defaultValue: e.data.ClienteID },

                { field: 'DesarrolladorID', headerText: 'Desarrollador', foreignKeyField : "DesarrolladorID", foreignKeyValue : "NombreDesarrollador", dataSource : @Html.Raw(Json.Serialize(@ViewBag.Desarrolladores))  },

                { field: 'EstatusID', headerText: 'Estaus', foreignKeyField: "EstatusID", foreignKeyValue: "Estatus", dataSource : @Html.Raw(Json.Serialize(@ViewBag.EstatusCliente))  },

                

[Rajapandi Ravi]

Hi Javier, 

Greetings from syncfusion support 

Based on your query we found that you need to disable editing for a particular row. We have already discussed about your requirement in our documentation section. Please refer the below documentation link for more information.  

Documentation: https://ej2.syncfusion.com/documentation/grid/how-to/disable-editing-for-particular-row-cell/ 

Regards,
Rajapandi R 

[Javier A Aguilera]

Goodafternoon,

Well, thats not exactly the problem, I have to disable a certain cell for a specific row when I edit another cell of the same row

"I need to disable the column "EstatusID" while editing the column "DesarrolladorID" (both columns have values for their foreignKeyField like 1,2,3...etc)"

I mean, When change the value in column "DesarrolladorID" I need to disable the column "EstatusID" if the value in Desarrollador is 1 or 2, but column "EstatusID" remains enabled if the value in DesarrolladorID is 3 or more

Also, I need to set values to other columns when the value in DesarrolladorID is changed

[Rajapandi Ravi]

Hi Javier, 

Thanks for the update 

We have analyzed your query and we could see that your requirement was related to our cascading dropdown feature. You can achieve the Cascading DropDownList with grid Editing by using the Cell Edit Template feature. We have already discussed about your requirement in our documentation. Please refer the below documentation for more information. 

Documentation: https://ej2.syncfusion.com/aspnetcore/documentation/grid/how-to/cascading-drop-down-list-with-grid-editing/ 

Please see the preview in the below JavaScript document 

Documentation: https://ej2.syncfusion.com/documentation/grid/how-to/cascading-drop-down-list-with-grid-editing/ 

Regards, 

Rajapandi R