How can I affect other column ?

[SHIN WOOCHUL]

If I edit some value and then I change other column value (check box make to checked)
Is that possible to control other column value?

Code: [Select]

      {
                  title: "",                     
                          dataIndx: "check",
                          type: 'checkbox',
                          cbId: 'chk',
                          align : 'center',
                },
                {
                        dataIndx: 'chk',
                        dataType: 'bool',
                        cb: { header: true },
                        hidden: true,
                        editable: function(ui){
                        //Number(list[i].orderQnty) <=(Number(list[i].inQnty)+Number(list[i].deliveryAllQnty))
                        var orderQnty = ui.rowData.orderQnty;
                        var inQnty =   ui.rowData.inQnty;
                        var deliveryAllQnty = ui.rowData.deliveryAllQnty;
                        var result = orderQnty - inQnty - deliveryAllQnty;
                            //to make checkboxes editable selectively.
                        if(result<=0){
                        return false;                       
                        }else{
                        return true;
                        }
                        }
                    },
                { title: "deliveryQnty",/* width : '15%',*/dataIndx: "deliveryQnty",type : 'integer' , 
            editor : {
            attr :'type : number',
            getData : function(ui){
            var value  = ui.$cell.find("input").val();
            if(isNaN(value)){   
                alert("<msg:message code="alert.onylNumber"/>");
                    return 0;
    }
   
                if (value <= 0) {
                alert("<msg:message code="alert.lagerQnty"/>");
                                                        //make check box false unchecked;
                    return 0;
                  }else{
                                                         //make check box true checked;
                  return value;
                  }
            }
            },


[paramvir]

column dependencies can be declared with js formulas or Excel formulas

Example of js formulas:

https://paramquery.com/pro/demos/grid_formula

[SHIN WOOCHUL]

I used   formulas , but it just return value text type and it add next to check box
I wonder is how can I select cell and input check box , also It change check value?
Please, I need help

[paramvir]

I used   formulas , but it just return value text type

formulas can return any data type value i.e, strings, dates, numbers, boolean, etc.

and it add next to check box
I wonder is how can I select cell and input check box , also It change check value?

It's not clear what issue you are facing. Please share a jsfiddle so that I can look into it.

PS: Checkbox example is here: https://paramquery.com/pro/demos/checkbox