Trying to Run two functions and two different emails in google scripts

Question

I'm trying to have my sheet trigger an email alert when the last row on certain column matches an if statement after a google form feeds the sheet. it worked the first time but when i try to do a second condition it only acomplishes the second if. so separated the ifs work, but not combined.

can you guys help? here is the function:

function sendEmails() {
  
  var ss  = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Observaciones Diarias IMPRG");
  var lr  = ss.getLastRow();
  
  var currentTemp = ss.getRange(lr, 6).getValue();
  var currentkidName = ss.getRange(lr, 3).getValue();
  var currentTexture = ss.getRange(lr, 15).getValue();
  
  if(currentTemp >39) {
  
  MailApp.sendEmail("xxx25@gmail.com","Temperature>39°Alert", currentkidName + " had atemperature of " + currentTemp + "° " +" which is extremely high, please check")
  }
  
  else if (currentTexture = 1){
    MailApp.sendEmail("xxx@gmail.com","Texture Alert", currentkidName + " had a  " + " liquid Evacuation. which indicates an issue, please check")
  }
}

Answer 1

currentTexture = 1 this is asigning a 1 to currentTexture. To do a comparison use

currentTexture == 1

or

currentTexture === 1

Related

• Google Script checking that the data within one column on one sheet is the same as another column in another sheet
• How do I find the cell with a certain background color, and set background of different cell in relation to it?
• How to set a variable based on other variables
• I'm trying to make an id searcher which does a thing when you input the right id. However, the if statement always runs. Why is this?