Saturday, 22 December 2018

Get date for email event

The following Google Apps Script code is designed to collect a date from a spreadsheet then appropriately format it so it can be used to later form an event invite.

Once the date has been collected from the sheet a new date variable is created, to which I then add 16 hours to for a start-time of 4pm ('setHours'). It is then necessary to format the date appropriately ('formatDate') so it has the correct timezone and layout for later feeding into the email event. This process is repeated for an end-time of 4:30pm. A menu item is created on-open to easily run the function.

Get Date for Email Event.xlsx

No comments:

Post a Comment