How do I check if the data in column 6 of my Spreadsheet A exists in the column 1 of my Spreadsheet B?

I want to check if the newly inserted values in column 6 match the records in another google sheet, and I want to reject the user input if it does not match. What is the issue(s) of my code below?

function onnameEdit(e) {var range = e.range;var sheetName = range.getSheet().getName();var column = range.getColumn();var row = range.getRow();var inputValue = e.value;

if (sheetName == 'Join Queue [FOR ADVISEES]' && column == 6) {var sName = inputValue;var db = SpreadsheetApp.openById('1jdEUJK2uw71YAn_AeK3uEQK77oOtGCVOI12TJHWN0QE').getSheetByName('Login');var snameExists = false;

var recordsData = db.getRange("B:B").getValues(); // Assuming the names are in column B (column 2)
for (var i = 0; i < recordsData.length; i++) {
  if (recordsData[i][0].toString().toLowerCase() === sName.toString().toLowerCase()) {
    snameExists = true;
    break;
  }
}

if (!snameExists) {
  SpreadsheetApp.getUi().alert("The entered name does not exist in the records. Please register first, or make sure you're entering the correct name.");
  range.clearContent();
} else {
  var dateCell = range.offset(0, 3); // Assuming the date will be written 3 columns to the right of the edited cell
  if (dateCell.getValue() === "") {
    dateCell.setValue(new Date()); // Set current date and time
  }
}

}}

Additionaly, I also want to ensure that a datecell will be added if the user input is accepted00