Custom Functions with add-ons?

Answer According to Eric Koleda in [Code.gs – date_add_and_subtract]( https://github.com/google/google-apps-script-samples/blob/master/date_add_and_subtract/Code.gs) to make available the custom fuctions in an add-on it’s required to include at least one add-on menu, but this is not working at this time on testing mode. NOTE: The originally referred page was removed but the Date add and substract add-on sample code … Read more

You do not have permission to call openById

I thought that I would throw in a similar issue that I had which brought me to this question, where I received the error You don’t have permission to call by openById. In my case I was trying to call functions from translate.gs which I copied from this example: https://developers.google.com/apps-script/quickstart/docs Note that at the top … Read more

Detect user inserting row or column in a google spreadsheet and reacting in a script

Google added an “On Change” event that detects row/column insertion/deletion along with other types of changes, the types for which you can see here under the allowed values for changeType. Following are the instructions from here detailing how to add a trigger to your project, so that you may have your function called when the … Read more