UET Calendar

UET Calendar is a Google Sheet file with Apps Script program for making UET's school-schedule on Google Calendar. Video demo: https://youtu.be/vb0erngKnVU

Installation

Make a copy of this Google Sheet file.

Usage

Update 14/10/2022: End Date -> End Week

Update 17/12/2022: Auto select classes by StudentID

Info Sheet:

• Change B1 to your calendar ID (ex: [email protected]) or leave it blank (create new calendar)
• Change B2 to the start date of the school year (format Date time)
• Leave B3 as blank (auto fill with start date + 15*7 days)

UET Sheet:

• Fill "Đăng ký" column with any value (ex: 1, a, ...)

• Click "Code" then "Make Calendar" to export your calendar to Google Calendar

* If it's the first time, Google will require permission to run, click Continue and Allow, click "Make Calendar" again to run

• Wait until the script is finnished then check your Google Calendar

• Other features:
  • "Add week number": add titles "Tuần 1, 2, 3, ..." to your calendar
  • "Delete Calendar": CAUTION: this will delete all of the data in your selected calendar
  • "Clear Sheet": clear selection in the "Đăng ký" column
• You can also add/remove subjects by making changes to "Đăng ký" column, click "Make Calendar" to update Google Calendar
• You can add new subjects, do sorting, filtering, . . . on the table, just make sure to reserve the correct form

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

License

MIT