Using ScriptDB Query in onEdit() function in Google Spreadsheet Apps Script

Question

So

I'm getting this error

Oops You do not have permission to call query (line 7)

When I try to query a ScriptDB database in an onEdit() function within Google Spreadsheet Apps script. Below is the code I use to get the repeatable error:

function onEdit(){
  //tell me event has happened
  Browser.msgBox("onEdit() Fired")
  //get ScriptDB reference
  var db = ScriptDb.getMyDb();
  //perform any query
  var results = db.query({})
}

Replace onEdit() with notonEdit() and it works as expected when triggered manually.

function notonEdit(){
  //tell me event has happened
  Browser.msgBox("notonEdit() Fired")
  //get ScriptDB reference
  var db = ScriptDb.getMyDb();
  //perform any query
  var results = db.query({})
}

Is there some sort of permission I am not correctly setting or are ScriptDB queries not allowed to function in event functions by design? Is anybody else seeing this problem?

Tom

user1525598 user1525598 · Accepted Answer · 2012-07-22T22:31:17

There are two ways to attach a script to the onEdit trigger: (1) choose the name onEdit for your function or (2) in the Script Editor, go to Resources>Current Script's Triggers and add notonEdit/From spreadsheet/On edit. (2) should be ok for you. See the guide for the difference between (1) and (2).

Using ScriptDB Query in onEdit() function in Google Spreadsheet Apps Script

2 Answers