[Discuss] gs menu item to run script

[John Boland]

can you elaborate and elucidate?

tia
On Jul 22, 2015 12:34 PM, "Eric Chadbourne" <eric.chadbourne at icloud.com>
wrote:

> I got it working.  Silly error on my part.
>
> Happy client, happy Eric.
>
> Eric Chadbourne
> Nonprofit-CRM.org
>
> > On Jul 22, 2015, at 12:18 PM, Eric Chadbourne <
> eric.chadbourne at icloud.com> wrote:
> >
> > Hi All,
> >
> > Anybody play around with google scripts?
> >
> > I have a client who wants to be able to click a button on a google
> spreadsheet and have some custom functions kick off, which includes sending
> an email.
> >
> > I whipped up a script (I don't really know javascript but the syntax
> isn't hard) and everything works.  But the user has to go to Tools =>
> Script Editor => foo.gs.  I would rather I could add a custom menu item
> and when they click this it kicks off my function.  This currently does not
> work and gives no error.
> >
> > From what I understand a custom menu item has to use a "trigger"
> onOpen() and triggers can't use functions that require authorization such
> as sending an email.
> >
> > My question is there anyway to get this to work the way the client
> wants?  The onOpen() is used to created the menu button, but the menu item
> calls my custom function.
> >
> > Thanks for any tips,
> >
> > Eric Chadbourne
> > Nonprofit-CRM.org
> >
>
> _______________________________________________
> Discuss mailing list
> Discuss at blu.org
> http://lists.blu.org/mailman/listinfo/discuss
>