Replies: 24 comments 1 reply
-
Did you consider using Handsontable in Handsontable instead of Autocomplete? http://handsontable.com/demo/handsontable.html I know the documentation lacks an example for the thing that you ask about, but it should be possible. I will try to write an example soon |
Beta Was this translation helpful? Give feedback.
-
+1 |
Beta Was this translation helpful? Give feedback.
-
Afaik, this is not possible currently without a plugin like https://github.com/trebuchetty/Handsontable-select2-editor/ |
Beta Was this translation helpful? Give feedback.
-
@warpech would you consider merging this feature in if I built it out? This is an old issue but it looks like it would be useful so I'd love to contribute. Otherwise maybe a plugin would be a good route. |
Beta Was this translation helpful? Give feedback.
-
We are closing issues related to feature requests to create a full document based on that ideas from all our sources. It is avaiable is our wiki section. |
Beta Was this translation helpful? Give feedback.
-
Any update on this? This is a highly desirable feature. I too would be happy to contribute to this. |
Beta Was this translation helpful? Give feedback.
-
Any update on this feature? Is it available now? I think without this feature handsontable autocomplete is useless. |
Beta Was this translation helpful? Give feedback.
-
Hi @ahghatol it's not under development yet - when it will be issue gets reopened or updated. |
Beta Was this translation helpful? Give feedback.
-
I've been looking for it for about 2 years now. It's unbelievable how it still does not exist in Handsontable. |
Beta Was this translation helpful? Give feedback.
-
@afbruno you could use a custom select plugin to create this custom field in your table, https://select2.github.io/ is a great plugin for that |
Beta Was this translation helpful? Give feedback.
-
As there aren't many comments on closed issues, we decided to reopen the feature requests as Github Discussions. Please feel free to share any feedback that will allow us to compose the full list of requirements for the proposed change. |
Beta Was this translation helpful? Give feedback.
-
What's the current best workaround to have this functionality? i.e. a dropdown where the value displayed is different than the value saved |
Beta Was this translation helpful? Give feedback.
-
Hi @AMBudnik - i have seen that demo before, but when i choose a name for a cell (i.e. "Mike") the value "Mike" is saved in the cell rather than the other numerical value. In any case, I have found another way to solve my problem. Perhaps this will be useful to other users. What I do is to display the options I want in the dropdown, then I use a hook so that when the cell value changes I apply a custom function to transform the cell value into the format I need. Not ideal, but it works for what we need. |
Beta Was this translation helpful? Give feedback.
-
Is there any update on this? Has this been integrated? |
Beta Was this translation helpful? Give feedback.
-
Hi @Ron168 It hasn't been integrated yet. This demo is the current solution: https://jsfiddle.net/handsoncode/f0b41jug/ |
Beta Was this translation helpful? Give feedback.
-
we really need this feature, the demo solution doesn't filter the list. |
Beta Was this translation helpful? Give feedback.
-
Wanted to give some insights I didn't see here. I too, find it very odd that this hasn't been implemented yet. I'm glad they let us create our own class extensions, at least. Either case, for better or worse, the solution I've currently landed on is to store your key-value data in your prepare override, then in your setValue override, you convert the Label text to your id using your locally stored key value data, and send your id to super.setValue(id) then in getValue, you convert it back, getting your id from super.getValue, then returning the label based on your data. The real trick is in how to handle searching/filtering the list. First you override queryChoices, set this.query to query, then run this.updateChoicesList(this.stripValuesIfNeeded(arrayOfStrings)), where "arrayOfStrings" is a list of labels from your dataset. This gets you mostly there, but Handsontable's searches can get weird. For better or worse, Handsontable uses your overridden getValue method to get the query, which currently returns the id instead of the label. So, make an exception in getValue, that skips the id lookup, and just returns the string if the dropdown is currently active. To return the full list when the user first goes to edit the dropdown, check if the query == this.originalValue in getValue, if that's true, return a blank string! This solution is super hacky, and I can't guarantee that any code I might submit here would work for future releases, so instead I opted to take the time to write up my process, in hopes it helps someone. (or better yet, gives Handsontable info that could help them implement this so it works out of the box, but it's been nearly 10 years, this is pure wishful thinking on my part, ha!) |
Beta Was this translation helpful? Give feedback.
-
I am running into an issue with autocomplete at the moment. I'm wondering if something is already in place to solve my problem, otherwise it may be a good feature to add in. What I need is something similar the following:
The
columns
option in the table constructor could accept an object that can contain data related to the autocomplete choice. This way I could have information related to the particular autocomplete choice instance in my database. Is there anything existing that could solve this issue? Thanks in advance!Beta Was this translation helpful? Give feedback.
All reactions