Back to Discover
🚀 Script storage
Script storage description placeholder
System Message
This is just a method to store scripts .... not for prompting
Prompt
function createNextQAdWeekSheet() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
var highestWeekNumber = 0;
// Find the sheet with the highest "QAd Week X" number
for (var i = 0; i < sheets.length; i++) {
var sheetName = sheets[i].getName();
var match = sheetName.match(/^QAd Week (\d+)$/);
if (match) {
var weekNumber = parseInt(match[1], 10);
if (weekNumber > highestWeekNumber) {
highestWeekNumber = weekNumber;
}
}
}
Logger.Log("Hello I am new");
// Determine the new sheet name
var newSheetName = "QAd Week " + (highestWeekNumber + 1);
// Create the new sheet
var newSheet = ss.insertSheet(newSheetName);
// Check if the sheet has more than 10 rows, then delete the extra rows
var defaultRowCount = newSheet.getMaxRows();
if (defaultRowCount > 10) {
newSheet.deleteRows(11, defaultRowCount - 10);
}
Logger.log("Created new sheet with 10 rows: " + newSheetName);
}