saegl5 / jiayou_add_events

Batch create calendar events on only certain letter days that spell out words of encouragement.
Other
0 stars 1 forks source link

Add 加油 ("jiā yóu") Events

Google Web app for creating recurring events on only certain letter days (e.g., on only "J Day's"). Modify as needed, and back up your calendars before you run the app. Without an app script, one would need to add these events manually.

Visual Example

screenshot of calendar form
Form for creating additional "JIA YOU" events. (Calendar name is hidden.)

screenshot of calendar
Additional events on only "J Day's" were created.

Prerequisites

  1. Access to Google Apps Script
  2. 加油 ("jiā yóu") calendar must already exist. If it doesn't, consult the Web app for creating the calendar.

Getting Started

  1. Go to Google Apps Script, and create a new project.
  2. Copy and paste the script into the editor, and save the file.
  3. Run the script to acquire authorization.
  4. Create an HTML file, and name it "Index."
  5. Copy and paste the markup text into the editor, and save the file.
  6. Deploy the project as a Web app, and open the assigned URL.
  7. Select your calendar name, and choose letter days on which you want to add events. (Must name the calendar differently from the owner name, otherwise the app will not add events.)
  8. Modify the events' title, guests, location, and description. (If you input a URL for the description, text to display will be "Agenda.")
  9. Modify the events' start time and end time. (If left blank, events will be added as all-day events.)
  10. Confine the date range by inputting a start date and end date. (If left blank, events will be added to all chosen letter days, starting from today and ending one year from today.)
  11. Optionally perform a dry run to test the Web app before running it in production. Consult logs for output.
  12. Press submit. (Requires another authorization. Note also that creating recurring events is subject to a use limit.)

Next Steps


Made with ♥ in Visual Studio Code


A special thank you to James Armstrong for adding recurring events, the calendar name dropdown menu, letter day checkboxes, etc.