Using findcell to search for empty cells

Discontinued products Uncategorized discussions
#1

Hello,



Im trying to do a verification on the grid before send it using FORM integration. There is a way to use findcell into some columns to verify is some cells are empty (string or numeric)?



Thank you!

#2

Sure, you can use next syntax
    var res=grid.findCell("",index);
    for (var a=o; a<res.length; a++)
       alert("empty cell at row "+res[a][0]);

where index - index of column in question

#3


I tried your code. The problem is , that code give me all the cells on the column. That not search for empty cells, instead, give all cells on the column. Please, try the code and give me a solution, Thank you!

#4

Sorry for inconvenience, the previous sample really was not correct ( because findCell searchs for occurrences and not for exact match )

You can use next approach

function check () {
    mygrid.forEachRow(function(id){
        if (mygrid.cells(id,1).getValue()==“”)
            alert(“cell at row “+id+” is empty”);
    })
}

1208530013.zip (89.8 KB)

#5

Thank you for your support!