Custom value and update value in javascript

[lesonunique]

Hello,

I'm interested in your custom renderer but I just have two questions:

Is it possible to allow the user to enter a custom value (not present in the data)?

And, how can I update the values of a cell? setDataAtCell(row, col, value, source) no longer works with the custom renderer Chosen editor.

Thank you in advance. Cordially.

Vincent LEVEQUE

[mydea]

No, because this is a select box, it is not possible to add custom values. You could possibly do something like this manually and call this.$textarea.trigger("chosen:updated"); to trigger a rerender of the chosen field, but I am not sure how to do this in a nice way.

I would accept a PR adding setDataAtCell support - that would certainly be nice to have, I simply do not have the time to do it right now.

[lesonunique]

I will try to create a function like setDataAtCell for Chosen.

Do you know in which direction am I looking? At what point are added element?

Thank you

[mehkar]

My solution: there is no need to chosen.trigger:

function ChosenSelect(instance, td, row, col, prop, value, cellProperties) {
    var selectedId;
    var optionsList = cellProperties.chosenOptions.data;

//if exist get initial value -------------------
    if(saved_filter[prop])
        value=saved_filter[prop];
//---------------------------------------------

    var values = (value + "").split(",");
    var value = [];
    for (var index = 0; index < optionsList.length; index++) {
        if (values.indexOf(optionsList[index].id + "") > -1) {
            selectedId = optionsList[index].id;
            value.push(optionsList[index].label);
        }
    }
    value = value.join(", ");

    Handsontable.TextCell.renderer.apply(this, arguments);
}

[Rolok]

mydea, thanks again for having made this. I've been using it for a while now -- including using both id and value in one case. I recently had a request to allow adding values that didn't already exist. I've got something that mostly works... I modified a section of the handsontable-chosen-editor file. I'm sure you'll recognize where, from the first line of the code here.

In handsontable I pass no_results_text: 'Press Enter to add new entry:' for this column. I also put together a list of distinct values in all the columns when I first load the page, and that's the data that gets passed in.

Any/all feedback appreciated.

if(e.keyCode === Handsontable.helper.KEY_CODES.ENTER /*|| e.keyCode === Handsontable.helper.KEY_CODES.BACKSPACE*/) {
    if($(this).val()) {
        var enteredValue = $(self.TEXTAREA_PARENT).find("input").val();
        e.preventDefault(); 
        e.stopPropagation();                            
        var newValueObject = [];
        newValueObject = JSON.parse('{"id":"' + enteredValue + '","label":"' + enteredValue + '"}');                        
        var add = 1;
        var entryLength = 0;
        for ( i = 0; i < allRejectsObject.length; i++ ){
            // check to see if the new value is contained in an existing list.                          
            entryLength = enteredValue.length;
            if (entryLength <= JSON.stringify(allRejectsObject[i].id).length){
            // the id of the allRejectsObject includes double quotes, so check for 1 rather than 0 if looking for start.
                if (JSON.stringify(allRejectsObject[i].id).toLowerCase().indexOf(enteredValue.toLowerCase()) !== -1 ){
                    add = 0;
                    e.preventDefault();
                }
            }
        }
        if (add == 1) {
            allRejectsObject.push(newValueObject);
            var el = null;
            el = $("<option />");
            el.attr("value", enteredValue);
            el.html(enteredValue);
            el.attr("selected", true);
            self.$textarea.append(el);
            self.close();
            self.finishEditing();
        }       
    } else {
        e.preventDefault();
        e.stopPropagation();
        self.close();
        self.finishEditing();
    }
}

[mydea]

I'm sorry, but I'm currently not actively adding new features to this project. I'm willing to merge PRs though.