How to use autocomplate dropdown but the column data source is from hotSettings data

Tags: #<Tag:0x00007f8b1d634408>
#1

Hello,
It is possible to use column source from hotSettings data?
Here’s the code
https://jsfiddle.net/muha_ramdani/peorkjta/

Thank you

#2

Hi @muha_ramdani,
AutocompleteEditor’s source might be a function. Its context is the cell’s meta-object (which also bind a main Handsontable’s instance). You can read data from the row’s source in the following way: https://jsfiddle.net/do3ws5e9/.

#3

Thank you for your help @piotr.laszczkowski

#4

Hi @piotr.laszczkowski
I try your code and it’s work, but when i try to implement Cell Dependencies, and add “data: ‘data.location’” above “souce:” the dropdown value is appear, but cannot be clicked, after that the dropdown become stuck. Here is what it look like

image
image.png758×270 23.6 KB

Scenario: After selecting “No CRG”, dropdown value on “Meaning CRG” changed.

#5

On the forum, we can only suggest some solutions or verify if the reported problem is a bug in Handsontable - only if we got an example or code snippet.

Creating custom solutions on demand is a part of our consulting services. Please reach out to our sales team at sales@handsontable.com to ask about available consulting options or support plans covering the client’s code review.

#6

Hi @piotr.laszczkowski,
I’m sorry for not providing the code on previous question, here is my code looks like
https://jsfiddle.net/muha_ramdani/jpv4mtso/
Thank you

#7

No problem, I see what causes the issue.
You defined in the second column data as a reference to an array dictionary_cedict.0.meaning. The current architecture doesn’t allow to do that. You can change that key to something that might store primitive values, then autocompleteEditor works correctly: https://jsfiddle.net/1mz7pkr9/.

Multi-value cells are on our long-term roadmap. However, we have no ETA yet.

#8