BLU Discuss list archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Discuss] gs menu item to run script
- Subject: [Discuss] gs menu item to run script
- From: eric.chadbourne at icloud.com (Eric Chadbourne)
- Date: Wed, 22 Jul 2015 12:33:30 -0400
- In-reply-to: <CDA2139F-9360-49FA-BFA3-FF9F1C590711@icloud.com>
- References: <CDA2139F-9360-49FA-BFA3-FF9F1C590711@icloud.com>
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 >
- Follow-Ups:
- [Discuss] gs menu item to run script
- From: jj.boland at gmail.com (John Boland)
- [Discuss] gs menu item to run script
- References:
- [Discuss] gs menu item to run script
- From: eric.chadbourne at icloud.com (Eric Chadbourne)
- [Discuss] gs menu item to run script
- Prev by Date: [Discuss] gs menu item to run script
- Next by Date: [Discuss] gs menu item to run script
- Previous by thread: [Discuss] gs menu item to run script
- Next by thread: [Discuss] gs menu item to run script
- Index(es):