Load a new source based on selected dropdown

Tags: #<Tag:0x00007efc64f77530>

I have two columns, One have some dropdown data,Other One is empty dropdown , If I select any one of the data the second columns source should be loaded

Please help me

Hi @vedaselvaraj27,
Accordingly to our documentation for the source option, you can use a function to return a dynamic list of possible options.

This function’s context is set to the cell’s metadata. The following snippet shows the way how you can get access to the Hansontable instance:

const hot = new Handsontable(container, {
  columns: [
    {
      type: 'autocomplete',
      source(query, callback) {
        // this - it's CellMeta object of the cell that you open to edit
        // this.instance - it's a reference to the Handsontable instance

        callback(/* items */); // returns available options
      } 
    }
  ]
});