Multi options in a single column dropdown on data load

Tags: #<Tag:0x00007efc65426fb8>
#1

I want different options against year dropdown on initial rendering in this example.
https://jsfiddle.net/du61xo9t/

#2

Hi @sarthak

as mentioned in this discussion - https://github.com/handsontable/handsontable/discussions/7879 we do not support multiple options in dropdown yet.

#3

I don’t want multi options in one dropdown.

I am looking for a way to update datasource in dropdown 2 based on the value in cell 1 when table is first rendered

#4

OK, then I have a demo that can help. We posted an article some time here https://handsontable.com/blog/articles/2016/4/expand-your-app-with-cell-dependencies about cell dependencies. In the Select-dependent cells paragraph, the first demo is exactly what you mentioned - the source of the last column changes based on what is chosen from the middle column.

If you would have any questions regarding this or any example please let me know,

#5