Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!
  • Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.


    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

parameter not working

hissam78

New Coder
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


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();

}}
 

New Threads

Latest posts

Buy us a coffee!

Back
Top Bottom