IssueTracker

would be useful!

much needed

I need to monitor active sheet because I have different side bar for every sheet. What I'm doing now is running a JavaScript from the client side every 1s (second) to call google.script.run.monitorTabChange();. This function reads current active sheet's name and compares it with a sheet name that had been saved in a PropertyService during the last call of google.script.run.monitorTabChange();.
The spreadsheet with this script helps me with creating Purchase Orders. It pulls data from Salesforce and Quickbooks and generates a PO. So for every PO for every customer I am duplicating the spreadsheet and of course the script. The problem that I am facing is running out of quota. I have generated tons of POs already and each of them runs (even if the spreadsheet is not opened - I tested it) the 'monitorTabChange' function, which calls PropertyService. I have 100 000 quota for PropertyService calls. And I'm running out of it pretty quickly now.
The trigger 'OnSheetChange' would then save me (probably many others too) from this issue. At the same time it would saved Google tons of execution overhead (that could be significant if lots of people use the solution I do to track the sheet change).
Thanks!

will really appreciate this feature :)

I'd like an onSwitchSheets event trigger with the following information available:
The sheet I'm switching from, active cell I'm switching from, active row I'm switching from, active col I'm switching from etc.
The sheet I'm switching to with ability to:
- land in a specific cell
- modify the contents of a cell or range of cells in the switch to sheet
- initiate a re-calculate in the target sheet after changes have been made.

Even better... onPreSwitch, onSwitch, onPostSwitch

Excessive code is required to implement the functionality I'm chasing without these hooks.

Any news from Google team?
i Would like to re-hide hidden sheets when user leaves it

Hey Google,
   This feature is highly in need for us. Can you please respond?

This trigger would also be useful for the code I'm working on.

very mandatory

Needed!

would be greatly apreciated

I need something like this too

Yes please - I have a goto last row but it only runs on open; would be great to run on every tab/sheet change

Come on... I was happy to see the way Google implemented apps vs MS vba and decided to convert several off my office documents to google sheets, but there is no way this is going to happen without support for this "onSheetChange" feature. It really makes me wonder how many  other basic features are missing in sheets. It only took 10 min. of investigation to put sheets on hold....

I have a sidebar that shows filters for the active sheet - when you change the sheet I need to reconfigure my sidebar.

At the moment I use a mouse-over event on my sidebar AND a timer function to constantly monitor the current sheet.

It would be so much better if there were a trigger on sheet change.

Thanks

Really need this feature and it seems like something that would be very simple to implement.  Knowing the current sheet is crucial for lots of operations and constantly checking that it hasn't changed seems very wasteful.

Need this, too

One and a half year, no update yet...

Oh come on Google folks!  Surely you can incorporate this!  Soooooooooo many people want this and really need it!

up

+

+

Please Google team - this would be very helpful!!

+

+

Hello?  Can't believe this hasn't been added yet.

Is this getting added ? Google team are you guys listening?

I really need this trigger. Please add. Is anyone responding to this request?

There is at least 1 workaround posted about that I know of if anyone is desperate. It's a bit pffft though based on a timer from memory. I'm not that desperate ...

I haven't actually tried them & I know some voters here may even be the contributors but in case anyone is frazzled for a workaround & hasn't come across them, even if a bit hacky >>
https://stackoverflow.com/questions/38160116/trigger-when-user-switches-between-sheets
https://webapps.stackexchange.com/questions/91812/how-can-i-trigger-a-function-when-switching-sheets-within-a-spreadsheet

+

need it also

+

+

Needed

On change sheet would be very useful

Really needed.

Needed. I want to reset something as soon as a particular sheet is viewed.

Come on Google, this has been around for years ... would give greater control of the user experience if changing sheets causes an action.

This will be a great feature. thanks

YESSSSS THIS !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Thanks for your input @gr...@velvet-dps.tech. However, if I would do as you suggest and create that dictionary in CacheService or Properties is it possible to fire a trigger when this dictionary is changed such that my desired function would run immediately e.g. make active cell matching the last one cell in the last row of the active sheet after a user in the gsheet changes the tab?

I would like it too!

This would be useful for addon script to be able to detect which sheet is active and adjust content in the addon based on the current sheet.

I need this feature as well! It was available in Excel Macros and I'm converting scripts to Google sheets

Waiting!!

Solved:
https://tanaikech.github.io/2020/05/18/change-tab-detection-on-google-spreadsheet-using-onselectionchange-event-trigger-with-google-apps-script/

Thanks for the tutorial on how to use onSelectionChange!

However there is one thing that does not work for me. I would like to activate a specific cell when switching tabs. For some reason the function SpreadsheetApp.setActiveRange(activeRange) does not work within onSelectionChange(e). Interestingly, the functionality of SpreadsheetApp.setActiveRange(activeRange) does work when used within onOpen(e). Any idea on why that is the case?

please google, add this trigger for us

Here is my work-around for onSheetChange:


function saveActiveSheet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var actsheet = ss.getActiveSheet();
  // The onSelectionChange() function executes in a separate thread
  // which does not use any script global variables, so use the
  // PropertiesService to maintain the user global state.
  var userProperties = PropertiesService.getUserProperties();
  userProperties.setProperty('ACTIVE_SHEET', actsheet.getSheetName());
}

function onSheetChange(e) {
  // Do anything needed after a new sheet/tab selection

}

function onSelectionChange(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  // Get current sheet name and compare to previously saved sheet
  var currentactsheet = ss.getActiveSheet();
  var currentactsheetname = currentactsheet.getSheetName();
  var userProperties = PropertiesService.getUserProperties();
  var actsheetname = userProperties.getProperty('ACTIVE_SHEET');
 
  if (currentactsheetname !== actsheetname) {   // New sheet selected
    saveActiveSheet();
    onSheetChange(e);   // Call custom sheet change trigger
  }
  // Do anything needed when a different range is selected on the same sheet
  else {
    var range = e.range;

  }
}

function onOpen(e) {
  saveActiveSheet();
}

agreed this would be very helpful.

Much needed, Google please update

Ditto! (would be a very helpful trigger.)

Agreed!

Very much needed functionality.

I could definitely do with this please.

Would like this trigger as well... It is needed!

Same here, onSelectionChange doesn't always work. So, i need this trigger

I need this

agreed this would be very helpful.

+1

Very much needed.

Very much needed. I don't know why this trigger doesn't exist yet.

I hope google sheets will come up with this.

Looking for this feature for my implementation as well.
Want to refresh the add on sidebar when the sheet tab changes.
Since OnSelectionChange is simple trigger, it doesn't allow running showSidebar function.

+1

Please implement this asap, this is very much needed, especially for product development.