The following (untested) script is designed to be installed as an installable onEdit script.
It will detect whether:
1 - a checkbox is marked as true, and
2 - the sheet is the form response sheet, and
3 - the checkbox is in Column F
If all of those conditions are met, then an email will be sent.
function wa14285401(e) {
// this script is installed as an installable onEdit trigger
/*
if the checkbox is ticked, send this email
Email subject= [Approved] Form
Email message= contents below
Timestamp: 01/06/2020 + times
Machine/Equiment require: PU1602
Plant to require: RF
Team to fix: Ele
Form no: F01
*/
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheetname = "May.2020";
var sheet = ss.getSheetByName(sheetname);
// the checkboxes are in column F
var eCol=6;
// get the key event obvjects
var erange = e.range;
var eRow = erange.rowStart;
var eCol = erange.columnStart;
var eSheet = erange.getSheet().getName();
var eVal = e.value;
// Logger.log("DEBUG: The edited sheet is "+eSheet);
// Logger.log("DEBUG: The edited row is "+eRow);
// Logger.log("DEBUG: The edited Column is "+eCol);
// Logger.log("DEBUG: The edited_value = "+eVal)
// Logger.log(JSON.stringify(e)); DEBUG
// apply logic to detect if check box is ticked.
if (eSheet == sheetname && eCol== eCol && eVal == "TRUE" ){
// the stars are in alignedment, send the email
// Logger.log("DEBUG: send the email");
// get the data column A to column E
var data = sheet.getRange(eRow, 1, 1, 7).getValues();
// Logger.log("DEBUG: the data range is "+sheet.getRange(eRow, 1, 1, 5).getA1Notation())
// get the email address
var emailaddress= sheet.getRange("H2").getValue();
Logger.log("the email is "+emailaddress);
// get the message information
var timestamp = data[0][0];
var machine = data[0][1];
var planttorequire = data[0][2];
var teamtofix = data[0][3];
var formnum = data[0][4];
var emailSubject = "[Approved] Form";
var emailMessage= "Timestamp: "+timestamp+"\n"+
"Machine/Equiment require: "+machine+"\n"+
"Plant to require: "+planttorequire+"\n"+
"Team to fix: "+teamtofix+"\n"+
"Form no: "+formnum;
// Logger.log("DEBUG: the message is:"+emailMessage);
MailApp.sendEmail(emailaddress, emailSubject, emailMessage);
}else{
// something doesn't match
// Logger.log("DEBUG: do not send the email");
}
}