onSelectionChange - new trigger type available soon?

[Kos]

Documentation:

https://developers.google.com/apps-script/guides/triggers#onselectionchangee

The onSelectionChange(e) trigger runs automatically when a user changes the selection in a spreadsheet.

Have someone tested it successfully?

This sample trigger code is not firing (V8):

function onSelectionChange(e)
{
  console.log(e);
}

Event is also not available from "Add Trigger" dialog yet:

[Alan Wells]

It's a simple trigger, so it will never be available to install.  Meaning that when you open the dialog box to add a new trigger, it's never going to be listed, unless they also make it available as an installable trigger.

I haven't tried it.  Interesting find.

[Kos]

Yeah, that's what I thought.

[Scott Marquardt]

Yeah, I can't get it to work either. 

Sure will be handy once it's as operable in the field as it is in the documentation.  ;-)

- S

[Kos]

As per https://stackoverflow.com/a/61409149/555121:

> onSelectionChange is a recently rolled out feature.

Hopefully someone can confirm it's working for their script soon.

[scott.m...@menta.com]

I trust everyone is already playing with this, since it's working now?

- S

[Alan Wells]

Everybody whose anybody.

Anybody whose not nobody.

Anyone whose in it for the fun.

And even those who just, want to "get it done."

[Kos]

Don't forget currently onSelectionChange is a simple trigger:  https://stackoverflow.com/questions/62647068/onselectionchange-google-app-script-doesnt-work-at-all  

So it don't work with functions that need authorization :(

[Scott Marquardt]

Yeah, that's sad for one particular application I had in mind. We have a sidebar whose content needs to vary depending on the active column. It would be nice to have it just automagically change -- but unfortunately a sidebar display needs authorization.    :-(      So I literally have to have a "refresh" button on the sidebar itself, that the user clicks after changing columns. That's truly a "so close -- and yet so far" frustration. 

Argh. 

- S

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/9de1e469-8d1d-41e8-9b29-0988880dc5d5n%40googlegroups.com.