This repository is trying the CaAT repotistory.
Bob's next week's schedule is: Bob wants to know the scheduled assigned time next week. However, Bob wants to exclude the time of morning meeting, lunch time, and concentration time.
When this scripts(src/index.ts main function) is executed, the following result is obtained.
Event | Assign Time(h) | Reason |
---|---|---|
Morning MTG | 0 | Target the cut time |
Lunch | 0 | Target the cut time |
Marketing MTG | 0 | Event status is non-attendance |
Tech MTG | 0 | Bob is morning break in 27 day |
SEO MTG | 0 | Bob is all holiday in 31 day |
Team Planning MTG | 0 | Bob is all holiday in 31 day |
Concentration | 0 | Event is ignore |
DepOps MTG | 0.5 | None |
※ 5 hours working per day. (2 hours is morning, 3 hours is afternoon)
Set the script properties.
property name | value |
---|---|
GROUP_ID | Google Calendar ID for getting the holiday) |
SPREAD_SHEET_ID | target spreadsheet id |
TEMPLATE_SHEET_NAME | sheet name for template |
MEMBER_${name} | To match the name in the Group Google Calendar title. ※ name is member's Google Calendar ID (exclude "@...") |