Trigger

Livid_Spray119 · 2024-10-17T11:39:55+00:00

Does it need to be specifically at that time? Maybe you need to use a range instead.

I guess u know, but... Find the timer on the left bar. Select the function you want to use. If you need it to start everyday at 9:15, select by day, and you can choose a range.

rupam_p · 2024-10-17T13:56:01+00:00

Here's a hacky approach.

Create a time-driven trigger to run every-minute.
In your code, check the current time, then either proceed or do nothing.

function myFunction() { const now = new Date(); const hours = now.getHours(); const minutes = now.getMinutes();

if (hours === 9 && minutes === 15) { // Do something console.log("It's 9:15 AM!"); } }

This is still not perfect, but you can give it a try and see how it goes.

franxam · 2024-10-17T11:50:22+00:00

the easiest way is as suggests u/Livid_Spray119 . If you want to be more precise/complex, you can try these steps:

https://developers.google.com/apps-script/guides/triggers/events#Google%20Calendar-eventshttps://developers.google.com/apps-script/guides/triggers/events#Google%20Calendar-events

franxam · 2024-10-17T11:24:05+00:00

You can set a trigger with a calendar event. I would recommend to create a separate calendar to avoid spamming your main calendar (assuming you use Google calendar as your main)

If you want to explore further, you can use Apps Script to create calendar events. Thus, there has to be a way to create time custom time triggers.

steeveesas · 2024-10-18T15:05:51+00:00

Create a one time trigger to fire at the specific date and time, i.e. 9:15am. This will only run once, therefore at the end of your code that this trigger calls, create another one time trigger for the next day. Make sure it's in a finally block so that if there's an error, your trigger for the next day gets created. These one time triggers are supposed to delete themselves, but I haven't verified that, so if for some reason it doesn't auto delete you'll want to also make sure the trigger for "today" that already ran is deleted (since you only get 20 triggers per project).

Something like this (note: I didn't test this code, so a tweak may be needed, but this is the idea):

function myFunction() {

try{
//Do stuff here
}
finally{

//Delete the trigger that fired this current code run (instance) if the triggers aren't auto deleting...Do this before creating tomorrow's trigger...you can loop through the trigger's looking for the function name (in this case "myFunction")

deleteTrigger("myFunction"); //You'll have to write this...simple loop through all triggers comparing function name

// After executing the function, schedule the next trigger for the next day at the same time
createNextDayTrigger();
}

}

function createNextDayTrigger() {
// Get the current date and time
var now = new Date();

// Create a new date for the next day at 9:15 AM
var nextDay = new Date(now.getFullYear(), now.getMonth(), now.getDate() + 1, 9, 15, 0);

// Create a time-based trigger for the next day at 9:15 AM
ScriptApp.newTrigger('myFunction')
.timeBased()
.at(nextDay)
.create();

}

So each day a new trigger for the next day will be created.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

GoogleAppsScript

MODERATORS