Grid Validation - Dependent on another column

[Michael]

I have a Kendo grid that has 15 editable columns and I am currently using inline editing.  I also have a comments column that is only required if one of the other columns has changed its value.  How do I manage that with custom validation?  

In the example below, I am able to click into the row to begin editing.  However I only require the Comments field to be required if ColA,ColB,ColC are edited.I can see that the row has been changed by tying into the hasChanges of the dataSource on the grid, but how do I force the required attribute to be applied to the Comments field?

ColA    ColB    ColC    Comment
0           0         0 

 

                    var grid = $('#grid').data('kendoGrid');
                    var selectedRow = grid.dataItem('tr.k-grid-edit-row');
                    if (grid.dataSource.hasChanges()) {
                        debugger;
                        alert("there are changes");
                    }

[Michael]

I think I have it.

In the code above, you can access the value of the Comments from the selectedRow then validate there by checking the dirty flag in the row.

 

var selectedRow = grid.dataItem('tr.k-grid-edit-row');

[Eyup]

Hello Michael,

I'm glad you've managed to find a solution to your specific scenario.
From user perspective, you can also opt for the comments column input to be disabled by default and when the user changes one of the other field values, you can access and enable it.

Regards,
Eyup
Progress Telerik

[Michael]

Do you have a sample of similar functionality?  I kind of like your idea of making the field disabled by default then making it required when the user changes one of the other fields.

[Eyup]

Hello Michael,

You can find a similar sample here:
https://dojo.telerik.com/IduYIdUM/5

It uses the following steps:

1. Define a column editor/s to configure the structure of the editing:
https://demos.telerik.com/aspnet-core/grid/editing-custom

2. Use the change event handler of the combo to capture the selection moment:
https://docs.telerik.com/kendo-ui/api/javascript/ui/combobox/events/change

3. Access the picker accordingly and hide it depending on the chosen option. You can also choose to disable or make it readonly instead of hiding:
https://docs.telerik.com/kendo-ui/api/javascript/ui/datetimepicker/methods/enable

Regards,
Eyup
Progress Telerik