function DTUpdate() { var num = $('#idtbl').handsontable("countRows"); x = $('#idtbl').handsontable("getDataAtCell", 0, 0); if (x != null) { for (var i = 0; i < num - 1; i++) { x = $('#idtbl').handsontable("getDataAtCell", i, 0); y = $('#idtbl').handsontable("getDataAtCell", i, 1); z = $('#idtbl').handsontable("getDataAtCell", i, 2); if (x != null && y != null) { serialasd = x.toString(); comp = y.toString(); pdt = z.toString(); $('[name=SN_' + ( 1 + i ) + ']').val(serialasd); $('[name=SNCmp_' + ( 1 + i ) + ']').val(comp); $('[name=SNCom_' + ( 1 + i ) + ']').val(pdt); } else { alert('Skipped adding serial number for row: ' + i + '. Please review the data and try to save again.' ); break; } } } }