Dynamic multicolumn List of values inside handsontable

Tags: #<Tag:0x00007efc62200638>
#1

I want to display multi column List of values (Record no,name,date of birth) against a handsontable column . data selected from oracle database.

List of values will be populated depending on another column(employee code) of that handsontable.

After selecting a row from the list , value of name will be displayed against the handsontable column.
Any help is appreciated.

Thanks in advance.

#2

Hi @susmita_karar

Did you made any steps to achieve this goal? If not I would recommend using setDataAtCell() to fill data on depending columns but I guess that it all depends on the type of cell. When it comes to a dropdown or an autocomplete you can update it’s source.

#3

Hi ,
Thanks a lot for your response. I am very new to Handsontable. Don’t know how to achieve this.
Can you please provide some sample code to display drop down list from database against a column inside handsontable.

Regards
Susmita Karar

#4

Hi @susmita_karar
Here’s an example http://jsfiddle.net/qcr2r6fp/ how you can achieve it. It’s not elegant but I hope it would bring you some clues.

#5