Programmatic create timebased trigger for spreadsheet

Question

I'm not able to find this in the documentation, but is it possible to programmatically create time based trigger for another spreadsheet?

Dealing with the exact same thing. Did you find a solution for this? — Akshay Raje
– Akshay Raje, Commented Dec 24, 2015 at 15:12

AdamL · Accepted Answer · 2012-08-07 09:51:32Z

1

Yes it is:

https://developers.google.com/apps-script/managing_triggers_programmatically

answered Aug 7, 2012 at 9:51

AdamL

24.8k7 gold badges73 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

louis Over a year ago

Sorry I didn't make my question clear, I mean create a timebased trigger for another spreadsheet. I want something like the event trigger, you can use this .forSpreadsheet(spreadsheet), is it possible?

AdamL Over a year ago

As a time-based trigger is triggered by, well, time, as opposed to a spreadsheet event, I'm not sure it would make sense to have a forSpreadsheet() method. Of course, the function to which you are applying the time-based trigger can operate on a specific spreadsheet... is this what you mean?

louis Over a year ago

Yes. I created a template spreadsheet which has the custom function and a time-based trigger calling this custom function. But when I make a copy of this template, I lost the trigger, so I'm trying to create the trigger again and attach it to the new spreadsheet.

Anton Over a year ago

Have you found a solution?

Akshay Raje Over a year ago

Dealing with the exact same thing. @louis did you find a solution for this?

Collectives™ on Stack Overflow

Programmatic create timebased trigger for spreadsheet

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related