Google Apps Script Troubleshooting
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});
};
{
}
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});
};
{
}