Update rows in One column based on another row Dropdown

Tags: #<Tag:0x00007efc61bc8ec8> #<Tag:0x00007efc61bc8d88>

I cannot figure out how to update rows based on a dropdown dynamically.
what i want is if the dropdown in the 2nd row is changed some default values should be filled in the editable cells.

but cannot figure out how to do it.

Hi @iamsayanchowdhury200

Thank you for contacting us. Can you please clarify to what values should the other cell be changed? The one chosen from the dropdown?

See for example If i have selected option 1, then the rest rows shall be filled with some standard values :
image
now, if i change the drop down to option 2, those valued will be changed, and new values which suits option 2 shall be filled in the cell dynamically.
image

The use case is that with the option change the default values shall also change, so that the user don’t have to fill any thing manually. they can toggle the option and default values will be changed.

Hi @iamsayanchowdhury200

We have an example that might be a good start to implement such functionality: https://jsfiddle.net/handsoncode/j9w4yaxc/

It’s just a general idea and can definitely be tweaked to suits your requirements better, but it show how it can be done.

Thank you very much. This is what i was looking for. But if multiple columns are coming in that case how I will do?
https://jsfiddle.net/ev9n407u/1/ like in this example

Hi @iamsayanchowdhury200

The general rules and usage of hooks would be similar, but as I mentioned, my example requires modifications to match your requirements.

I am not able to prepare more complex examples before we can confirm your current support plan. Please, send us your license ID at support@handsontable.com.