Thursday, June 20, 2013

Google Spreadsheet Script to go to Next Sheet

Google Spreadsheet Script to go to Next Sheet


(by Aaron Tawil)

So I am trying to create a click-through by assigning a script to a 'next' button that allows the user to click on the button and it will move them from the current sheet to the next sheet.

I get this error when I click the button: Cannot find method (class)(class)setActiveSheet(number)

this is my code:

function nextMonth(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet()
  var id = sheet.getSheetId();
  if(id == 11){
    id = 0;
    id += 1;


Now, have a look at the following script:

function switchToNextSheet()
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var id = ss.getSheetId();
  var sheets =  ss.getSheets();
  var ids =[];
  var currentid = 0;
  for( var i=0;i<sheets.length;i++)
    ids[i] = sheets[i].getSheetId();
    if( id == ids[i] )
      currentid = i;
  var nextid = 0;
  if( currentid == sheets.length-1 )
    nextid = ids[0];
    nextid = currentid+1;

When you run the above function, you will move to the next sheet of your current active sheet.

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: 

No comments:

Post a Comment