So my code suppose to make me a tracking sheet of edits on the main sheet but when its gets the email it gives an empty email unless its my main email then its works for some reason here is the main function. and my friend from his pc it didnt even got "" the script didnt run so irdk the problems. btw i am new to this so dont make fun of me please.
function onEdit(e) { // Check if the event object is defined if (!e || !e.source) { // If the event object is not defined or does not have 'source' property, exit the function return; } var ss = e.source; // Get the active spreadsheet var trackingSheetUrl = "https://docs.google.com/spreadsheets/d/1VR1wc5xGtAB6dYmQCf9ChphwfHoOYI-7qKEjJEs42Lo/edit#gid=1175584031"; // Put the URL of your tracking sheet here var trackingSpreadsheet = SpreadsheetApp.openByUrl(trackingSheetUrl); var trackingSheet = trackingSpreadsheet.getSheets()[1]; // Assuming the tracking sheet is the first sheet var user = Session.getActiveUser().getEmail(); // Get the email of the user who made the change if (user == ""){ user = "error"; } var userLocation = searchDataColumnWithUser(trackingSheetUrl, user); if (userLocation) { // User found, increment the value var currentValue = userLocation.getValue(); userLocation.setValue(currentValue + 1); } else { // User not found, create new row var lastUserRow = trackingSheet.getLastRow(); var newUserRow = lastUserRow + 1; trackingSheet.getRange(newUserRow, 1).setValue(user); // Set username trackingSheet.getRange(newUserRow, 2).setValue(1); // Set initial value as 1 trackingSheet.getRange(newUserRow, 2).setValue(1); // Set initial value as 1 } } I suppose to get the email and update the sheet.
