How to display data in column based on dropdown

Getting help Questions
1

HI, How to display data in column based on select ?I’ve seen the documentation, but it’s very confusing, maybe some can help

var setting={
data: []
,
minSpareRows: 20,
columns: [
{type: ‘dropdown’, numericFormat: {pattern: ‘000’}, validator: ‘tps’, source: myTps}
{type: ‘text’, allowInvalid: true, editor:false}
],
rowHeaders: true,
colHeaders: [“id”,“NKK”],
filters: true,
dropdownMenu: false,
width: resizeGrid(),
height: 500,
maxRows: 300,
}

2

Hey @rizkyfathurahman172

by select do you mean the select cell type or the selection (selected cell/cells)?

3

Select, for example I have 2 columns, ID and name. Type of field ID (dropdown), type of name (text),
When the ID (dropdown) is selected, the column name displays result data from select ID,

4

So let’s say that here https://jsfiddle.net/fvxeyL0h/1/

If you select 2 you wan to show 1,2,3 instead of marry?

5

https://jsfiddle.net/xy8c6kt2/1/

When column A is selected (dropdown) then column B next to display results from column A (dropdown), column A (Dropdown) Select 1 = Column B (text) Displays 1!

6

Hi @rizkyfathurahman172

You could achieve this by listening to beforeChange hook.
Here is a demo with this approach - https://jsfiddle.net/handsoncode/e5tn7ogL/1/?utm_source=website&utm_medium=embed&utm_campaign=e5tn7ogL

Please read about cell dependencies on our blog post - https://handsontable.com/blog/articles/2016/4/expand-your-app-with-cell-dependencies

Let me know if you need anything else.

7

I guess that we can close this ticket as there are no additional questions.