To create a support ticket, start a search

Modifying the value entered in a grid - Grid JS onEditCell


Follow instructions Products Grid: Adding a field from ps_product_lang table to create a field 'shipping info'.


We would like to modify the value in field 'shipping info' to truncate the data if it goes over 100 characters, and then send this value to the server to get registered in the database.



From the Advanced Properties panel on the right handside:

- select the menu Grid JS onEditCell and enter:

// onEditCell(stage,rId,cInd,nValue,oValue)
// rId is the row ID
// cInd is the column INDEX
// nValue is the new value
// oValue is the old value

if (nValue != oValue) {
    idxDeliveryInfo = cat_grid.getColIndexById('infos_livraison');
    if (cInd == idxDeliveryInfo) {
        cat_grid.cells(rId, idxDeliveryInfo).setValue(cat_grid.cells(rId, idxDeliveryInfo).getValue().substr(0, 100));


You will need to reset Store Commander to apply the new modifications.