Skip to content

silverbirder/SampleCaAT

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SampleCaAT

This repository is trying the CaAT repotistory.

Smaple Results

Bob's next week's schedule is: sampleCaAT 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. sampleCaAT_spreatsheet

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)

Prepare

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 "@...")

About

This repository is trying the CaAT repotistory

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors