Setting the dropdown value of a table based on another table

Tags: #<Tag:0x00007efc64b40570>
#1

Hello,
I have two tables, say table1 and table2 .
Both table looks like this:

image
image.png908×278 5.5 KB

In both table, the column “Time” is a dropdown list consist of value (8:00, 10:00, 12:00), while “first value” and “second value” is text column.

What I would like to achieve is when I select a time from the dropdown list in table1, the “time” column in table2 should change to follow what is selected in table1.
Currently I am able to get what is selected in table 1 and populate it in the text column in table2, but not able to populate it to the dropdown column “Time”.

Sample of expected result:

image
image.png876×417 12.3 KB

Thank you and appreciate any inputs!

Regards,
Lee

#2

Hi @leewesley18

We have an example that shows how to manage data correlation between two tables. That can be used as a reference while building your functionality.

https://jsfiddle.net/handsoncode/r60cu4td

#3

Hi Adrian,

Thanks for your reply!
Unfortunately I am only able to get it work with text columns like the example given, can I have an example using tables with dropdown column?

Thanks in advance!

Regards,
Lee

#4

Hi @leewesley18

We can prepare custom code snippets only within certain support plans. To confirm your support plan, can you send me your license ID at support@handsontable.com?

#5