You could use the API to quiry the cell and then send a server side email based on the returned value. Just run the script via cron. Sorry I don't have a working code for this but pulling the values is not that complicated. Basically Auth to the sheet key and ask for the value of the cell.
You could do this with App Engine as mentioned but I am just starting to play with that so can't be much help. It is a pain that the new Sheets Scripts don't have a cron feature. It was one of the first things I looked for that and auto run on change. On Mon, Sep 14, 2009 at 11:43 AM, Bill H. <bhaye...@gmail.com> wrote: > > I believe the following is true. > You cannot (automatically) do what you ask about. > Script functions called from a cell cannot invoke > services (classes) like MailApp or even Browser. > You have to manually run them from the script editor > or from a custom menu cmd you can create. > > There are only two automated solutions I can think of: > > An easy, but weak, solution is to have a 'watcher' cell > which, when your target cell hits a particular value, > change the watcher cell background to red > (via the Format/Change colors with rules... menu cmd) > and display the text 'run SendWarning menu cmd' > (which you would create as a custom menu cmd). > > A hard way is to create a Google App Engine app that uses > the cron service to run periodically and send Email when > your taget cell hits a given value. > I have not used this service, but it's described here: > http://code.google.com/appengine/docs/python/config/cron.html > > I wish Google would note limitations like this more clearly > than the following statement on the Scripts Docs page: > "These custom functions may only modify the value of the local cell. > Any use of API methods that interact with Google products will result > in an error." > > Bill Hayes > > > > > > > > On Sep 13, 8:49 pm, thstart <thst...@gmail.com> wrote: > > >when a cell in a cell range is equal to predetermined value > > > > Probably I need to clarify - I want this value to be watched > > and automatically executed when the condition is true. > > > > On Sep 13, 8:44 pm, thstart <thst...@gmail.com> wrote: > > > > > I am with Premier Edition. Yes, I am a programmer. > > > Still if you read my initial question I doubt it is possible > > > that is why I asked. James if you want to help just post a working > > > script, I can read the documentation myself. > > > > > On Sep 12, 11:51 am, "Bill H." <bhaye...@gmail.com> wrote: > > > > > > To those interested in using Scripts, > > > > it appears you can only access this feature in > > > > Google Apps Premier Edition account ($50 per year). > > > > It's not available in my plain Google acct or even > > > > in my Apps Std Edition acct. > > > > However I don't see this specifically stated in any of > > > > Google's online or YouTube tutorials. > > > > > > Regards > > > > Bill Hayes > > > > > > On Sep 11, 2:00 pm, James Ferreira <nmago...@gmail.com> wrote: > > > > > > > This could be done via API but from your other questions I am > guessing you > > > > > are not a programmer. Google has a great new addition to > Spreadsheets called > > > > > Scripts. It will do what you are asking. > > > > > > > For sending the email for change in a cell look at: > http://www.google.com/google-d-s/scripts/scripts.html > > > > > > > There is a video here: > http://www.youtube.com/watch?v=7ux-IexZFec&eurl=http%3A%2F%2Fgoogleap... > > > > > That shows exactly what you want to do. > > > > > > > On Fri, Sep 11, 2009 at 12:09 PM, thstart <thst...@gmail.com> > wrote: > > > > > > > > How to do the following: > > > > > > > > send email notification to hard coded email address when > > > > > > a cell in a cell range is equal to predetermined value - a string > > > > > > value? > > > > > > I want the email to contain this string value in the subject and > > > > > > the body. > > > > > > > -- > > > > > James Ferreira > > > > > Chief Information Officer > > > > > Office of the New Mexico Attorney General > > > > > 505.231.2487 > > > > > jferre...@nmag.gov > > > > > > > -- James Ferreira Chief Information Officer Office of the New Mexico Attorney General 505.231.2487 jferre...@nmag.gov --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com To unsubscribe from this group, send email to google-docs-data-apis+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---
