Dear Respectful Experts,
Following is the Code having parameters c1,r1 and w1, c1 and r1 working fine to filter the result but w1 is not working and not filtering the result, somebody can help me.. Thanks
}}
Following is the Code having parameters c1,r1 and w1, c1 and r1 working fine to filter the result but w1 is not working and not filtering the result, somebody can help me.. Thanks
Code:
function doPost(e){
Logger.log(JSON.stringify(e));
if(e.parameter.Submit == 'Get Result'){
var cls = e.parameter.cl;
var roll = e.parameter.rl;
var v2 = e.parameter.w1 ;
var ss = SpreadsheetApp.openById('1lc0Evtb22F84UbS2w8Iulwg8S8LppNtewiYwHO2MzfA');
var ws = ss.getSheetByName(cls)
var lr = ws.getLastRow();
for(var i = 1;i <= lr;i++){
var val = ws.getRange(i, 1).getValue();
if(val == roll ||val == v2) {
var v1 = ws.getRange(i, 2).getValue();
var v2 = ws.getRange(i, 3).getValue();
var v3 = ws.getRange(i, 4).getValue();
var v4 = ws.getRange(i, 5).getValue();
var v5 = ws.getRange(i, 6).getValue();
var v6 = ws.getRange(i, 7).getValue();
var v7 = ws.getRange(i, 8).getValue();
var v8 = ws.getRange(i, 9).getValue();
var v9 = ws.getRange(i, 10).getValue();
}}