Dropdown depending on another dropdown

Tags: #<Tag:0x00007f34421211a0>

My database table is like below. I need to display distinct col1 in first dropdown and based on col1 selection col2 dropdown should populate values and based on col2 selection col3 should populate values. These col1, col2 and col3 gets changed frequently and I cannot hardcode these values in code. Please help me to fix this.

col1 col2 col3
Text1 Ans1 Yes
Text1 Ans2 No
Text1 a Yes
Text1 b No
Text1 c Yes
Text1 d No
Text1 e Yes
Text1 f No
Text1 g Yes
Text1 h Yes
Text1 i Others
Text2 x Yes
Text2 y No
Text2 z Others
Text2 a Others
Text2 b Yes
Text2 c No
Text3 m Others
Text4 n Yes
Text4 o No

Hi @madanmame

Here is an example on how to change the source of a dropdown based on the value of another cell in the same row https://jsfiddle.net/3zdkq2bs/ The change is possible by watching the cell value via beforeChange hook.