Notes

function onEdit(e) {
// Check if the edit was on the checkbox column in the 'Portal' sheet
var range = e.range;
var sheet = range.getSheet();
var ui = SpreadsheetApp.getUi();

if (sheet.getName() === 'Portal' && range.getColumn() === 4 && range.getRow() > 1 && e.value === "TRUE") {
var receivedValue = sheet.getRange(range.getRow(), 3).getValue();

// Check if the received value is not empty
if (receivedValue) {
var materialName = sheet.getRange(range.getRow(), 1).getValue();
var targetSheet = e.source.getSheetByName(materialName);

if (targetSheet) {
// Append the new row in the target sheet
var dateTime = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), 'M/d/yyyy h:mm:ss a');
targetSheet.appendRow([dateTime, "INCREASED", receivedValue]);

// Reset the checkbox and the received value
sheet.getRange(range.getRow(), 3).setValue('');
range.setValue("FALSE");

// Show a success message
ui.alert('Success', 'The operation was successfully completed for ' + materialName, ui.ButtonSet.OK);
} else {
ui.alert('Error', 'Sheet with the name "' + materialName + '" does not exist.', ui.ButtonSet.OK);
}
} else {
// Uncheck the checkbox and alert the user if the received value is empty
range.setValue("FALSE");
ui.alert('Error', 'The Received value cannot be empty.', ui.ButtonSet.OK);
}
}
}