How to check the mandatory fields in handson table on click of submit/save button?

I want to do the mandatory check for some of the fields in handson table on click of submit button /save button?
How to do this?
I had 4000/5000 records/rows with 95 columns each, So iterating over these so many records will have performance issue…

So I am looking for some feasible solutions how to do mandatory/null check on click of the submit/save button.



Checking all the records on submit? I don’t think there is any other way then iterating over them all.

You can validate the fields on input in Handsontable. With allowInvalid: false the mandatory fields can’t be emptied. You can use custom validator for the “required” fields.

Kind regards