Google Calendar event automation

[Spencer Vick]

Hi all,

My boss had me create a Calendar where I use events to show what times I am available so she knows when I am able to be scheduled. She asks me to keep this updated day by day for last minute bookings. I am unable to take on any bookings within 24 hours. I would like to create a script that automatically deletes my availability event when it occurs within the next 24 hours.

Any help is appreciated. TIA!

[olivercre...@gmail.com]

Hello,

Perhaps you can use the Apps Script Calendar Service to write a function that deletes your availability event when it occurs within the next 24 hours. You can make that function run automatically by using a time-driven trigger. 

Here are some links that can help you get started: 

• Calendar Service overview page: https://developers.google.com/apps-script/reference/calendar
• A bit of background on time-driven triggers: https://developers.google.com/apps-script/guides/triggers/installable#time-driven_triggers
• Instructions on how to create a time-driven trigger: https://developers.google.com/apps-script/guides/triggers/installable#manage_triggers_manually
  • When you get to Step 4, set the "Select Event Source" option to "Time-driven" to make a time-driven trigger. You can configure the other options based on how often you need the function to run.

Best,

Oliver 

[Brian Meehan]

I think you could use appointment booking slots. Make it a recurring appointment that fills your overall "office hours" window when you'd be amenable to accepting visitors. Google Calendar will automatically block out any appointments that conflict with existing appointments, and that's updated in real-time, as long as you create the appointment slots on your primary calendar.

Set your default appt length, and also set the buffer time and max/min time before to ensure you have a reasonable heads-up for new appointments.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/c94a11d9-5253-4e1f-8a78-e76089babd63n%40googlegroups.com.

--

	Brian Meehan 明益友 Director of Learning Technology 資訊部主任 School: 886-7-586-3320 Email: bme...@kas.tw

---

Kaohsiung American School | +886-7-5863300 |  http://kas.tw

No.889 Cueihua Rd. Zuoying Dist., Kaohsiung City, Taiwan 81354

This email and any included attachments are confidential and intended solely for the addressee.

If you are not the intended recipient or have received this message in error:

1) please alert the sender and delete this message and any attachments;

2) you are hereby notified that any use or storage of this message or its attachments is strictly prohibited.