Google Apps Script Troubleshooting

Job ID: 39269573

Budget: $10 – $30 USD

I'm experiencing script errors in my Google Sheets and need assistance troubleshooting them. The scripting language in use is Google Apps Script.

Ideal Skills:
- Proficient in Google Apps Script
- Strong troubleshooting skills
- Familiarity with Google Sheets

Code with errors is:
function onEdit(e) {
ridempties(e);
ohsheets(e);
// Add more function calls here
}


function ridempties (e) {
var sheet = SpreadsheetApp.getActiveSheet();

var lastRow = sheet.getLastRow();



for (var i = lastRow; i > 1; i--) {

if (sheet.getRange(i, 1).getValue() === "") {

sheet.deleteRow(i);

}
function ohsheets (e) {
const src = e.source.getActiveSheet();
const r = e.range;
if (r.columnStart != 2 || r.rowStart == 1 || e.value == src.getName()) return;
const dest = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(e.value);
src.getRange(r.rowStart,1,1,2).moveTo(dest.getRange(dest.getLastRow()+1,1,1,2));
src.deleteRow(r.rowStart);
}
}
}
function sortjale() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('L5:L94').activate()
.sort({column: 12, ascending: true});
};
{

}
Related categories: PHP JavaScript Excel Google App Engine Google Chrome