Script to automatically change the active sheet after user completes populating a range of cells

Question

i am looking for solution to merge text fragements in Apps script to automate a process. I have 3 sheets (sheet_1, sheet_2,sheet_3). In each of the sheets i have 10 cells (A1:A10) to be filled by the user. After the 10th cell has been filled, the 2nd sheet (sheet_2) is to be called via the script. the procedure starts in cell A1 and ends in A10, similar to sheet_1.

function myFunction() {
var feature_1 = "sheet_1"
var feature_2 = "sheet_2"
var feature_3 = "sheet_3"
var column = 5
var feature_xx = "feature_"
for (var i = 1; i <=10; i+1) {
var feature = feature_xx.concat(i)
for (var row=1; row <=10; row+1) {
cell = SpreadSheetApp.getActive().getSheetByName(feature_1).getRange(row,column).activate();
// set rule for each cell that is activated
var rule = SpreadSheetApp.newDataValidation()
.requireNumberBetween(1,20)
.setAllowInvalid(false)
.setHelpText("Number must be between 1 and 20")
.build();
cell.setDataValidation(rule);
}}}

Answer 1

For moving from sheet to sheet, this should work:

// Set up variables
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet1 = ss.getSheetByName('Sheet1');
var sheet2 = ss.getSheetByName('Sheet2');

// The onEdit function runs every time there is an edit to the spreadsheet.
function onEdit(e){
  var lastCell = sheet1.getRange("A10").getValue();
  if(lastCell != ""){
    sheet2.activate();
  }
}

For data validation, it might be easier to use the built in data validation panel. (Data > Data Validation)