How to map each records with database ID column in Handsontable

Tags: #<Tag:0x00007efc650f7e28>
#1

Hi,

I need a solutions on how to map a handsontable each row with database Id column. For example I have a data base table called Supplier with following columns:
Supplier ID (-> Unique Id for each supplier)
Supplier Name

When data is loaded in handsontable grid I need to map each row data with the supplier IDs but right now there is no way to map each supplier id to respective rows of handsontable like we have in JQgrid.

Please suggest if there is any column or row property where we can specify the supplier Id to add as “id” attribute to each TR.

#2

Hi @mahendrapratap.mishr

Have you considered to use metadata?

Here is an example http://jsfiddle.net/handsoncode/uymcettp/ that uses setCellMeta and getCellMeta methods.

#3