Google Spreadsheet Update method with more than 1 var data search

Question

I have Android apps that can save data database in a Google spreadsheet, and the data table looks like this:

And I have script update like this :

//Update
   if (e.parameter.func == "Update") {

    var sku = e.parameter.SKU;
    var exp = e.parameter.EXPIRED;
    var loc = e.parameter.LOCATION;
    var stat = e.parameter.STATUS;
    
    var lr= sh.getLastRow();
    for(var i=1;i<=lr;i++){
      var data_sku = sh.getRange(i, 1).getValue();
      if(data_sku==sku){
        sh.getRange(i, 2).setValue(exp);
        sh.getRange(i, 3).setValue(loc);
        sh.getRange(i, 4).setValue(stat);
        return ContentService.createTextOutput("Successfully Updated").setMimeType(ContentService.MimeType.TEXT);
        
      } 
    }
  }

But if I want to change the status of row 3 in the application, the only thing that changes is the first row:

I think I should give 3 parameter variables besides sku, but I don't know where to put them.

When I put code like this, its throws an error. Maybe anyone can help me?

//Update
   if (e.parameter.func == "Update") {

    var sku = e.parameter.SKU;
    var exp = e.parameter.EXPIRED;
    var loc = e.parameter.LOCATION;
    var stat = e.parameter.STATUS;
    
    var lr= sh.getLastRow();
    for(var i=1;i<=lr;i++){
      var data_sku = sh.getRange(i, 1).getValue();
      var data_exp = sh.getRange(i, 2).getValue();
      var data_loc = sh.getRange(i, 3).getValue();
      if(data_sku==sku and data_exp==exp and data_loc==loc){
        sh.getRange(i, 2).setValue(exp);
        sh.getRange(i, 3).setValue(loc);
        sh.getRange(i, 4).setValue(stat);
        return ContentService.createTextOutput("Successfully Updated").setMimeType(ContentService.MimeType.TEXT);
        
      } 
    }
  }

the error message after update confirmation click is "script is complete, but returns nothing" — Teguh Sampurna, Jul 16 '21 at 13:48
https://stackoverflow.com/questions/16089041/how-can-i-test-a-trigger-function-in-gas — Yuri Khristich, Jul 18 '21 at 08:28

score 1 · Answer 1 · answered Jul 16 '21 at 13:18

1

Try to change:

if(data_sku==sku and data_exp==exp and data_loc==loc){

with:

if(data_sku==sku && data_exp==exp && data_loc==loc){

answered Jul 16 '21 at 13:18

Yuri Khristich

13,448
2
8
23

thanks for your answer..but stil said script is complete, but returns nothing,it shown in my apps – Teguh Sampurna Jul 16 '21 at 13:50

score 1 · Answer 2 · answered Jul 16 '21 at 13:58

//Update
   if (e.parameter.func == "Update") {

    var sku = e.parameter.SKU;
    var exp = e.parameter.EXPIRED;
    var loc = e.parameter.LOCATION;
    var stat = e.parameter.STATUS;
    
    var lr= sh.getLastRow();
    for(var i=2;i<=lr;i++){
      var data_sku = sh.getRange(i, 1).getValue();
      var data_exp = sh.getRange(i, 2).getValue();
      var data_loc = sh.getRange(i, 3).getValue();
      if(data_sku==sku && data_exp==exp && data_loc==loc){
        sh.getRange(i, 2).setValue(exp);
        sh.getRange(i, 3).setValue(loc);
        sh.getRange(i, 4).setValue(stat);
        return ContentService.createTextOutput("Successfully Updated");
      } 
    }
  }

Google Spreadsheet Update method with more than 1 var data search

2 Answers2