[B! Google Spreadsheet] kimikimi714ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kimikimi714 id:kimikimi714

Google Spreadsheetã«é–¢ã™ã‚‹kimikimi714ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Slack ã®ãƒã‚°ã‚’è‡ªå‹•ã§ Google Spreadsheet ã«ä¿å˜ã™ã‚‹ - è©©ã¨å‰µä½œãƒ»æ€ç´¢ã®ã²ã‚ã°
2020-05-12 22:50 è¿½è¨˜ 2020-05-05 ã‚ˆã‚Šã€Slack ã®ãƒˆãƒ¼ã‚¯ãƒ³ã¯ä½œã‚Œãªããªã£ã¦ã‚‹ã®ã§ã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã®æ–¹æ³•ã§ã¯ã‚¹ãƒˆãƒ¬ãƒ¼ãƒˆã«å®Ÿç¾ã§ããªããªã£ã¦ã„ã¾ã™ã€‚ãƒˆãƒ¼ã‚¯ãƒ³ã®ä»£æ›¿æ–¹æ³•ã«ã¤ã„ã¦ã¯ã‚µãƒãƒ¼ãƒˆã—ã‹ãã‚‹ï¼ˆã¨ã„ã†ã‹çŸ¥ã‚‰ãªã„ï¼‰ã®ã§ã€å„è‡ªãŒã‚“ã°ã‚Šã¾ã—ã‚‡ã†ï¼ 2015-11-13 16:40 è¿½è¨˜ ä»¥ä¸‹ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®åˆ©ç”¨ãŒ Slack ã® TOS ã«è§¦ã‚Œã‚‹ã®ã§ã¯ãªã„ã‹â€¦â€¦ã¨ã„ã†æŒ‡æ‘˜ã‚’ã„ãŸã ãã¾ã—ãŸã€‚ No Other Storing. You may not copy or store any Data or capture or store any information expressed by the Data (such as hashed or transf erred data), except to the extent permitted by this API TO
kimikimi714 2018/10/22
IFTTTã§ã‚¢ãƒ—ãƒªæŽ¢ã—ã¦ã‚‚ãªã‹ã£ãŸãŒã€åˆ©ç”¨ç”¨é€”ã¨ã—ã¦slackãŒè¨±å®¹ã—ã¦ãªã„ã‹ã‚‰ãªã®ã‹ã€‚ã¨ã‚‚ã‚ã‚ŒGASä½¿ãˆã°ã„ã„ã‚“ã ã—ã€ä»Šåº¦ä½¿ã£ã¦ã¿ã‚ˆ

slack

Google

Google Apps Script

Google Spreadsheet
ãƒªãƒ³ã‚¯
Googleãƒ•ã‚©ãƒ¼ãƒ ã§ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆã‚’é›†è¨ˆã™ã‚‹ã¨ã™ã”ã„ãƒ©ã‚¯
Googleãƒ•ã‚©ãƒ¼ãƒ ã¨ã„ã†ã®ã¯ã€Googleãƒ‰ãƒ©ã‚¤ãƒ–ã®ä¸€æ©Ÿèƒ½ã§ã™ã€‚ ã‚ã¨ã§ã‚‚è§¦ã‚Œã¾ã™ãŒã€Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ä¸€æ©Ÿèƒ½ã¨ã—ã¦ã‚‚æ©Ÿèƒ½ã—ã¾ã™ã€‚ã¨ã„ã†ã‹ã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®æ©Ÿèƒ½ã®ä¸€ã¤ã¨ã—ã¦è€ƒãˆã¦ã‚‚è‰¯ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã“ã®ã‚ˆã†ã«ã€æ–°è¦ä½œæˆã®æ™‚ã«ã¯ã€ã€Œãƒ•ã‚©ãƒ¼ãƒ ã€ã¨ã—ã¦å‡ºã¦ãã¾ã™ã€‚ æ©Ÿèƒ½ã¨ã—ã¦ã¯ã€ãƒ•ã‚©ãƒ¼ãƒ ã‚’ä½œæˆã—ã¦å…¬é–‹ã—ã€é›†è¨ˆã¾ã§ã§ãã¦ã—ã¾ã†ã¨ã„ã†ã‚¹ã‚°ãƒ¬ãƒ¢ãƒŽãªã®ã§ã™ã€‚ ã§ã¯ã€å®Ÿéš›ã«ã©ã®ã‚ˆã†ã«ä½œæˆã™ã‚‹ã®ã‹ã€è¦‹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ Googleãƒ‰ãƒ©ã‚¤ãƒ–ã‹ã‚‰æ–°è¦ä½œæˆã‚’ã—ã¾ã™ã€‚ãƒ•ã‚©ãƒ¼ãƒ ã‚’é¸æŠžã™ã‚‹ã¨ã€ã“ã®ã‚ˆã†ãªç”»é¢ã«ãªã‚Šã¾ã™ã€‚ ã‚¿ã‚¤ãƒˆãƒ«ã‚„èª¬æ˜Žãªã©ã‚’å…¥ã‚Œã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ å…¥ã‚Œã‚‹ã“ã¨ãŒã§ãã‚‹ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆãƒ•ã‚©ãƒ¼ãƒ ã¯ã€ã€Œã‚¢ã‚¤ãƒ†ãƒ ã®è¿½åŠ ã€ã‹ã‚‰ã§ãã¾ã™ã€‚ ã“ã®ã‚ˆã†ã«ã‹ãªã‚Šè±Šå¯Œãªæ›¸å¼ãŒæƒã£ã¦ã„ã¾ã™ã€‚ ã‚ã¨ã§ã€å¤‰ãˆãŸã„å ´åˆã¯ã€é¸æŠžã—ãŸå½¢å¼ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨ã„ãã‚‰ã§ã‚‚å¤‰ãˆã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒžã‚¦ã‚¹ã®ãƒ‰ãƒ©ãƒƒã‚°ã§è‡ªç”±ã«è³ªå•ã®é †ç•ªã‚’ä¸¦
kimikimi714 2017/12/23
ã“ã‚“ãªã‚“è¦‹ã¤ã‘ã¡ã‚ƒã£ãŸã‚‰è‡ªåˆ†ã§Q&Aã‚¢ãƒ—ãƒªä½œã‚ã†ã‹ãªã¨æ€ã£ã¦ãŸå¤¢ãŒæ½°ãˆã‚‹ãª

Google Form

Google Spreadsheet

technology
ãƒªãƒ³ã‚¯
Google Apps Scriptã§Googleã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®è¨˜éŒ²ã‚’ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«å‡ºåŠ›ã™ã‚‹
å‰å›žã®ãŠã•ã‚‰ã„ å‰å›žã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã“ã¡ã‚‰ã§ã—ãŸã€‚ const CALENDAR_ID = '**********'; //ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ID function getCalendarEvents() { const calendar = CalendarApp.getCalendarById(CALENDAR_ID); const startTime = new Date('2020/04/01 00:00:00'); const endTime = new Date('2020/05/01 00:00:00'); const events = calendar.getEvents(startTime, endTime); for(const event of events){ console.log(event.getTitle()); } } ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®æµã‚Œã¨ã—ã¦ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã—ãŸã€‚
kimikimi714 2017/11/29
Google Apps Script

Google Spreadsheet

Google Calendar

technology
ãƒªãƒ³ã‚¯
Google Spreadsheetã«æ–°ã—ã„è¡ŒãŒè¿½åŠ ã•ã‚ŒãŸã‚‰Chatworkã«é€šçŸ¥ã™ã‚‹ - Qiita
æ¦‚è¦ ã‚µã‚¤ãƒˆã®ãŠå•ã„åˆã‚ã›æƒ…å ±ã‚’Google Spreadsheetã§ç®¡ç†ã—ã¦ã¾ã™ã€‚(ãŠå•ã„åˆã‚ã›ãŒæ¥ãŸã‚‰ä¸€ç•ªä¸‹ã®è¡Œã«ãŠå•ã„åˆã‚ã›å†…å®¹ãŒè¿½åŠ ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ã‚‹) ã—ã‹ã—äººé–“ã¯äººé–“ãªã®ã§è¦‹é€ƒã—ãŸã‚Šå¿˜ã‚ŒãŸã‚Šã—ã¾ã™ã€‚è¦‹é€ƒã—ãŸã‚Šå¿˜ã‚ŒãŸã‚Šã—ãªã„ã‚ˆã†ã«ã€Chatworkã¨é€£æºã—ã¦é€šçŸ¥ã—ã¦ãã‚Œã‚‹ã‚ˆã†ã«ã—ã¾ã—ãŸã€‚ ä½¿ã†ã‚‚ã® Chatwork API(botç”¨ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆä½œã£ã¦APIèªè¨¼ã—ã¦ãŠã) Google Apps Script ã‚„ã‚Šã‹ãŸ Chatworkã®é€£æº é€£æºã•ã›ãŸã„ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ãƒ„ãƒ¼ãƒ«â†’ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã§ã€ã„ã‚ã„ã‚ã‚„ã£ã¦ã„ãã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ã“ã®å¤§å¤‰ã‚ã‚ŠãŒãŸã„è¨˜äº‹ã‚’å‚è€ƒã«Chatworké€£æºã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’å…¥ã‚Œã¦å–‹ã‚‰ã›ã¾ã—ã‚‡ã†ã€‚ ã‚¨ãƒ‡ã‚£ã‚¿å†…ã®ãƒªã‚½ãƒ¼ã‚¹â†’ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã€Chatworkã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’èªã¿è¾¼ã¾ã›ã¦ã‚ã’ã¾ã™ã€‚ ã‚ã¨ã¯ã“ã‚“ãªæ„Ÿã˜ã«ã—ãŸã‚‰å–‹ã‚‹ã‚“ã˜ã‚ƒãªã„ã§ã—ã‚‡ã†ã‹ã€‚ /* ãƒãƒ£ãƒƒãƒˆãƒ¯
kimikimi714 2017/11/10
Google Apps Script

Google Spreadsheet

technology

Qiita
ãƒªãƒ³ã‚¯
Make IFTTT Date Format play nice with Google Spreadsheets
IFTTTDate.md ##Date and Time =TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) ##Date =DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) ##Time =TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) To Use Simple just place either or both separated by ||| in the Formatted Row Input on IFTTT
kimikimi714 2017/11/06
NOWæœ€å¼·èª¬

ifttt

technology

Google Spreadsheet
ãƒªãƒ³ã‚¯
1