ã¯ããã«ãæšæ¶
ã¯ãããŸããŠïŒã¿ã«ãã·ããªã¢ããšç³ããŸãã
ç§ã¯ãæ¥æ¬ã®ãåããã®äŸ¡å€ãäžããããããã·ã§ã³ãšããŠãäž»ã«ãã³ããã°ã©ããŒåãã®ããã°ã©ãã³ã°åŠç¿ããµããŒããã掻åãããŠãããŸãã
æé100äžPVã»ã©ã芧ããã ããŠããããã°ããã€ãé£ã«ITã®ãä»äºãã®éå¶ã100åã»ã©ãåå ããã ããŠããã³ãã¥ããã£ããã³ããã°ã©ããŒã®ããã®ã¹ãã«ã¢ããç 究äŒããäŒæ¥åãã®ç ä¿®ãéçºã«å ããŠãããã€ãã®æžç±ãäžæ¢ããŠãããŸãã
ä»åã¯ããã®æžç±ã®ãã¡ã®äžã€ã詳解! GoogleAppsScriptå®å šå ¥éãã«ã€ããŠã®ãããžã§ã¯ãã§ãããã²ã芧ããã ããã°å¹žãã§ãïŒ
ãã®ãããžã§ã¯ãã§å®çŸãããããš
1. ã詳解! GoogleAppsScriptå®å
šå
¥éãã®ã第2çãã®æ©æåºçãå®çŸããããšïŒ
2. ãããžã§ã¯ããéããŠãã³ããã°ã©ããŒã®ããã°ã©ãã³ã°åŠç¿ãåèãããïŒ
â ãŸããGoogle Apps Scriptãšã¯ïŒ
Google Apps Scriptã¯GoogleãæäŸããããã°ã©ãã³ã°èšèªã§ããç¥ããŠGASïŒã¬ã¹ïŒãšããããŸãã
ã¹ãã¬ããã·ãŒããGmailãGoogleã«ã¬ã³ããŒãšãã£ãGoogleãµãŒãã¹ãã¯ããããŸããŸãªãµãŒãã¹ãæäœããããšãåŸæãªããšããã身ã«ã€ããããšã§ãªãã£ã¹ã¯ãŒã«ãŒã«ãšã£ãŠã®å€§ããªæŠåšãšãªããŸãã
ãã®äž»ãªçšéãå ¥éã®ããŒãã«ã®äœãããããã³ããã°ã©ããŒãåŠã³ãããã®ãç¹åŸŽã§ãä»ãããžã泚ç®ããã€ã€ããããã°ã©ãã³ã°èšèªã§ãã
åè: è¶ åå¿è ãžGoogleAppsScriptãå§ããã¡ãªãããããã§ãããšèª¬æããŸã
â æžç±ã詳解! GoogleAppsScriptå®å šå ¥éã ãšã¯ïŒ
2017幎12æã«åºçãããGASã®æ¬æ Œå ¥éæžã§ããåºçåœåãããããžã奜è©ãããã ããŠãããŸããŠã5åã®å¢å·ãšãªããŸãããçºå£²ãã2幎çµã£ãçŸåšã§ããé 調ã«æšç§»ããŠãããŸãã
GASã®æžç±ã¯ç§ã®ç¥ãéãæ°åãããªããåå¿è åãã«JavaScriptã®åºç€ããæ²èŒããŠããã®ã¯æ¬æžã ããšããèªèã§ããïŒGASã¯ã人æ°ã®èšèªãJavaScriptããããŒã¹ãšããããã°ã©ãã³ã°èšèªã§ããããGASã®äººæ°ãæ¯ããŠããäžã€ã®èŠå ã§ããïŒ
ããããã£ãŠãæ¬æžã¯ãã³ããã°ã©ããŒãåå¿è ãå«ããŠåºãæ¯æãããŠãããã®ãšæããŸãã
åè: æžç±ã詳解ïŒGoogle Apps Scriptå®å šå ¥éãçºå£²ã«ã€ããŠã®ãç¥ãã
â ãªããã第ïŒçããæ¥ãå¿ èŠãããã®ïŒ
å»ã2æã«GASã§ãšãŠã倧ããªã¢ããããŒãããããŸãããå ·äœçã«ã¯ãV8ã©ã³ã¿ã€ã ããšããJavaScriptãšã³ãžã³ããµããŒããããŸãããããã«ãããGASã§ã¯ãšãŠãããããã®ãæ°ããã¢ãã³ãªæ§æã䜿ããããã«ãªããŸããã
ã¢ããããŒãèªäœã¯ãšãŠãè¯ãããšãªã®ã§ãããå°ãåé¡ããããŸãã
å®éã®GASã¯ãã§ã«V8ã©ã³ã¿ã€ã ã§åããŠããã«ãé¢ããããæ¬æžãå«ããŠãçŽãWebäžã«ããGASã®æ å ±ã¯ã¢ããããŒãåã®å€ãæ§æã«ãããã®ã§ãããšããåé¡ã§ãã
ãããããããããåŠã³å§ããååŠè ã¯æ°ããæ§æã®ã¿ãåŠã¹ã°è¯ãã®ã§ãããäœãç¥ããã«ãããšå€ãæ§æãåŠç¿ããŠããŸãããšã«ãªããŸããåŠã³ã¯ãããã¿ã€ãã³ã°çã«äžå¹žãªããšã«ãªã£ãŠããŸãã®ã§ãã
ã§ããããåŒããã°ããã€ãé£ã«ITã®ãä»äºãã§ã¯ã人æ°ã®èšäºããé çªã«ãæ°ããæ§æã䜿çšãããã®ã«ãªã©ã€ããé²ããŠãããŸãã
äžæ¹ã§ãæžåºã«äžŠãã§ããæ¬æžã«ã€ããŠãæ©æ¥ã«æ°ããæ§æã䜿çšãããã®ã«ã¢ããããŒãããªããã°ãªããªããšãã責任ãç§ã«ã¯ãããŸãã
åè: GASã®ãV8ã©ã³ã¿ã€ã ãã¢ããããŒããåããŠç§ãããã¹ãããšãªã¹ã
â åºçã®å·çãšããäœæ¥ã«ã€ããŠ
ããŠãæžç±ã®å·çã«ã¯ç¹æ®ãªåŽé¢ããããŸããå·çäœæ¥ãšããŠã¯ãæ°ã¶æããå Žåã«ãã£ãŠã¯ïŒå¹Žä»¥äžãããããšããããŸãããäžæ¹ã§ãã®å ±é ¬ã¯åºçããªãããªããšåŸãããŸããã
ãããã£ãŠãå·çæéäžã®èè ã¯ã足å ã®ç掻費ã¯å¥ã®æ¹æ³ã§çšŒããªãããå·çãé²ãããšããã®ãåºæ¬ã§ãã
ç§ã®å Žåã¯ãäž»ã«ååäžãæžç±ã®å·çã«ãååŸã足å ã®ç掻費ãåŸãããã®ãä»äºãšåããŠãå·ç掻åãšåçã®ãã©ã³ã¹ããšã£ãŠããŸãã
â 第ïŒçã®å·çäœæ¥æé確ä¿ã®ããã«âŠïŒ
ããããç§çãªäºæ ã§æçž®ã§ããããã§ã«åå€ããããŸã§ä»æžã®å·çäœæ¥ã§ã¹ã±ãžã¥ãŒã«ãåãŸã£ãŠãããååäžã®æéããæ¬æžã®æ¹çäœæ¥ã«å ãŠãããšãã§ããªãã®ã§ãã
æ¬æžã®æ¹çäœæ¥éå§ãåå€ãšããŠãå·çäœæ¥ãæ°ã¶æãšèŠèŸŒããšãæ ¡æ£ãçµãŠå¹Žå ã«åºçã§ãããã©ãããšããã¹ã±ãžã¥ãŒã«ãšèªèããŠããŸãã
ããšãã£ãŠãç¡çã«ååŸã䜿ããšãã£ãã·ã¥ãå°œããŠæ»ãã§ããŸããŸãã
âŠããã§ãèããŸããã
æ¬æžãäºåã«è³Œå ¥ããã ããããæ¯æŽãããã ãããšã§ãå·çå¯èœãªæéã確ä¿ã§ããŸããïŒ
ãã®ãããªçµç·¯ãããæ¬ãããžã§ã¯ããç«ã¡äžããŸããã
第ïŒçã®æ§ææ¡ã«ã€ããŠ
以äž3ã€ã®æ¹éã§ç¬¬ïŒçã®å·çäœæ¥ãé²ããäºå®ã§ãã
1. V8ã©ã³ã¿ã€ã 察å¿
å€ãã®æ°ããæ§æãè¿œå ããããããæ§æã®è§£èª¬ãå·®ãæ¿ãããŸãã¯è¿œå ããŸããã»ãŒãã¹ãŠã®ãœãŒã¹ã³ãŒããæ°ããªæ§æã«ãããã®ã«å·®ãæ¿ããŸãã
2. ä»ã®GASã®ã¢ããããŒãã«å¯Ÿå¿
第1ççºå£²ä»¥éã®ä»ã®ã¢ããããŒããåæ ããŸããäŸãã°ããã¹ã©ã€ãããApps Scriptããã·ã¥ããŒããããã¯ãããªã©ã§ãããŸããå€ãã®ãµãŒãã¹ã§UIãå€æŽã«ãªã£ãŠãããããã»ãšãã©ã®ãã£ããã£ç»åãå·®ãæ¿ããŸãã
3. ãã®ä»ã®è¿œå
第1çã«ã¯æ²èŒããªãã£ããã®ã®ãèªè ããã®èŠæãå€ãã£ããã®ãšããŠããã©ãŒã ããªã©ãè¿œå ããŸãã
çŸæç¹ã®æ§ææ¡
01ç« Google Apps Scriptã®åºç€ç¥è
02ç« ã¹ã¯ãªãããšãã£ã¿
03ç« Apps Scriptããã·ã¥ããŒãïŒâ
è¿œå ïŒ
04ç« åºæ¬æ§æïŒâ
倧å¹
å€æŽïŒ
05ç« å¶åŸ¡æ§æïŒâ
äžéšè¿œå ïŒ
06ç« é¢æ°ïŒâ
倧å¹
å€æŽïŒ
07ç« ãªããžã§ã¯ãã®ä»çµã¿ïŒâ
倧å¹
å€æŽïŒ
08ç« JavaScriptã®çµã¿èŸŒã¿ãªããžã§ã¯ãïŒâ
äžéšè¿œå ïŒ
09ç« ã¹ãã¬ããã·ãŒã
10ç« GmailïŒâ
äžéšè¿œå ïŒ
11ç« ãã©ã€ã
12ç« ã«ã¬ã³ããŒ
13ç« ããã¥ã¡ã³ã
14ç« ã¹ã©ã€ãïŒâ
è¿œå ïŒ
15ç« ãã©ãŒã ïŒâ
è¿œå ïŒ
16ç« ç¿»èš³
17ç« BaseãµãŒãã¹ïŒâ
äžéšè¿œå ïŒ
18ç« ã€ãã³ããšããªã¬ãŒïŒâ
äžéšè¿œå ïŒ
19ç« ãŠãŒã¶ãŒã€ã³ã¿ãŒãã§ãŒã¹
20ç« ãã¡ã€ã«ãšããŒã¿ã®æäœ
21ç« UtilitiesãµãŒãã¹ïŒâ
äžéšè¿œå ïŒ
22ç« å€éšãµã€ããžã®ã¢ã¯ã»ã¹
23ç« ããããã£ãµãŒãã¹
24ç« ã©ã€ãã©ãª
å šé¢çã«å€æŽãå·®ãæ¿ããå ¥ããŸãããç« å šäœãè¿œå ãããâ è¿œå ããç« ã«äžéšãè¿œå ãããâ äžéšè¿œå ããç« ãå€§å¹ å€æŽãããâ å€§å¹ å€æŽããšããŠããŸãã
第1çããã®äž»ãªå€æŽç¹
- ãœãŒã¹ã³ãŒãããã£ããã£ç»åãå
šé¢çã«å·®ãæ¿ã
- æ°æ§æãžã®å¯Ÿå¿ïŒlet/const/ãã³ãã¬ãŒãæåå/for..of/ããã©ã«ãåŒæ°/ã¢ããŒé¢æ°/classïŒ
- çµã¿èŸŒã¿ãªããžã§ã¯ãã®ã¡ãœãããè¿œå ïŒincludesã¡ãœãã/flatã¡ãœãããªã©ïŒ
- ãµãŒãã¹ãã¯ã©ã¹ã®è¿œå ïŒFormãµãŒãã¹/SlideãµãŒãã¹/GmailDraftã¯ã©ã¹/consoleã¯ã©ã¹/Sessionã¯ã©ã¹/Userã¯ã©ã¹/ScriptãµãŒãã¹ãªã©ïŒ
- Apps Scriptããã·ã¥ããŒãããã¯ãã«ã€ããŠã®è§£èª¬ãè¿œå
è³éã®äœ¿ãé
ç®æšãéæããæç¹ä»¥éãéããæ¯æŽéã®å ¥éé¡ïŒæ¯æŽéã®ãã¡ææ°æ17%+çšãé€ãããŸãïŒããæžç±è³Œå ¥ïŒ2800å+çšïŒãšéä»ïŒã¯ãªãã¯ãã¹ã188åïŒã«ãããå䟡ãåŒããéé¡ã«ã€ããŠã5500åã1æéãšæç®ããŠããã®äœæ¥æéãåªå 確ä¿ããŠæ¬æžç¬¬ïŒçã®å·çäœæ¥ãé²ããŸãã
ãäŸãã°ã以äžã®ãããªã·ãã¥ã¬ãŒã·ã§ã³ã«ãªããŸãã
- å
¥éé¡300000åãæžç±è³Œå
¥30åâïŒ300000-91440)/5500=37.9æé
- å
¥éé¡1000000åãæžç±è³Œå
¥100åâïŒ1000000-304800)/5500=126.4æé
å·çäœæ¥ãã©ãã ãè¡ã£ãããã©ãã ãé²ãã ããªã©ã®ãããã«ã€ããŠã¯ãæ¬ãããžã§ã¯ãããŒãžã®ã»ããããã°ããã€ãé£ã«ITã®ãä»äºãããGoogleã«ã¬ã³ããŒãªã©ã§ãç¥ããããäºå®ã§ãã
å®æœã¹ã±ãžã¥ãŒã«
3æ: ãããžã§ã¯ãã¹ã¿ãŒã
4/7ç«~5/14æš: ãããžã§ã¯ãåéæé
ç®æšéææç¹: 第2çäœæ¥éå§ãâ»ä»¥éã®ã¹ã±ãžã¥ãŒã«ã¯æ¯æŽé¡ã«ãããŸãã®ã§ãé 次ãäŒãããŠãŸãããŸãã
æåŸã«
Google Apps ScriptãæŠåšã«ããããšã§ãçããã®ãä»äºã®äŸ¡å€ãåçã«åäžãããããšãã§ããŸãããããã¢ãã³ãªæ§æã§å®çŸã§ããããã«ãªã£ããšããã®ã¯ãGoogleããã®ãã¡ã€ã³ãã¬ãŒã§ãã
æ¬æžã®æ¹èšçããã¡æ©ããå±ãããããšã§ãæ¥æ¬ã®çããã«ãã®çŽ æŽãããæŠåšããã¡æ©ãæã«ããŠãã ããããæäŒããã§ãããã®ãšæã£ãŠãããŸãã
æ¥æ¬ã®ãåããã®äŸ¡å€ãäžããããã«ãæ¬æžãã圹ã«ç«ãŠãã°å¹žãã§ãã
â»æ¬ãããžã§ã¯ãã¯All-or-Nothingæ¹åŒã§å®æœããŸããç®æšéé¡ã«æºããªãå Žåãèšç»ã®å®è¡åã³ãªã¿ãŒã³ã®ãå±ãã¯ããããŸããã
ææ°ã®æŽ»åå ±å
ãã£ãšèŠã- ãææ°ã®ãGoogle Apps Scriptå®å šå ¥éãããã¡æ©ãäžã«å±ãããïŒããããžã§ã¯ããªãŒããŒã®ã¿ã«ãã·ããªã¢ãã§ãã ãã®7/6ã«ã詳解ïŒGoogle Apps Scriptå®å šå ¥é [第3ç]ããçºå£²ãããŸããïŒ[第3ç] 㯠[第2ç] ã§ã¯å ¥ã蟌ãããšãã§ããªãã£ã Google Apps Scriptã®æ°IDEã®æäŸéå§ãGoogle Workspaceã®ããã©ã³ãã«å¯Ÿå¿ããææ°çã§ããåºç瀟ããã®ã¹ããŒãã£ãã€çŽ æŽãããå€æã§ã7ã¶æãšããçæé㧠[第3ç] ããå±ãã§ããŸãããããããæ¬ãããžã§ã¯ãã§ãæ¯æŽããŠããã ããçããŸãããã³ [第2ç] ããã§ã«ãè³Œå ¥ããã ããçããŸã«ã¯ãäžéœåããããããŠããŸã圢ã«ãªããŸããããã§ã[第3ç] ã§å€§ããå€æŽã®ãã£ãããŒãã§ãã2ç« ã20ç« ã23ç« ã«ã€ããŠãææ°çã®PDFãç¡æã§é åžããããŸãã以äžããããŠã³ããŒãå¯èœã§ãã®ã§ããã²ã掻çšãã ããã詳解! Google Apps Scriptå®å šå ¥é 第2çãšç¬¬3çã®å·®åPDFããããã®ãã³ããã°ã©ããŒãGASããã¹ã¿ãŒããŠä»äºã®äŸ¡å€ãããããäžããŠããã ããã°ããããã§ããæåŸã«ãæ¬ãããžã§ã¯ãããã³ãGASæ¬ãã«ã€ããŠããæ¯æŽã»ã声æŽã»ãååãããã ããçããŸã«ãããäžåºŠæè¬ããäŒãããããŸãã ãã£ãšèŠã
ã詳解ïŒGoogle Apps Scriptå®å šå ¥é [第3ç]ãã®åºçäŒç»ãå§åããŸãã
2021/01/25 15:55ãææ°ã®ãGoogle Apps Scriptå®å šå ¥éãããã¡æ©ãäžã«å±ãããïŒããããžã§ã¯ããªãŒããŒã®ã¿ã«ãã·ããªã¢ãã§ãã æšå¹Ž11/30ã« [第2ç] ãçºå£²ãããŸãããããã®åºŠããã®æ¹èšçãšã㊠[第3ç] ã®äŒç»ãã¹ã¿ãŒãããããšããå ±åããããŸãã以åããç¥ããããããŸãããšãããGoogle Apps Scriptã®æ°IDEã®æäŸéå§ã«ãããæ¬æž [第2ç] ã¯ãã®ãŸãŸã§ã¯èªã¿é²ããããšãã§ããªãããŒããåºãŠããŠããŸããŸãããããããã©ããŒããããã«ãããã°ããã€ãé£ã«ITã«ã®ãä»äºãã«ãŠã圱é¿ãããããŒããšãã®è£å®ãããèšäºã«ã€ããŠã·ãªãŒãºã§ãéãããããŸãããhttps://tonari-it.com/google-apps-script-perfect-guide-book-2/#toc6ããããã¯ããã§ããã ãå€ãã®GASå ¥éè ã®çããŸã«å¯ŸããŠãã¹ã ãŒãºã«åŠç¿ããã ããããšããé¡ããããããŸãããã®ç¹ãåºç瀟ããŸãšçžè«ãéããŠããçµæããã®ãã³ã[第3ç] å¶äœã«ã€ããŠãæ©æã®æ±ºæãããã ãããšãã§ããŸããã[第3ç] ã«ã€ããŠã¯ãä»é±ããäœæ¥ãéå§ãã5æ以éã®çºå£²ãç®æããŠé²ããŠãŸãããŸããããããæ¬ãããžã§ã¯ãã§ãæ¯æŽããŠããã ããçããŸãããã³ [第2ç] ããã§ã«ãè³Œå ¥ããã ããçããŸã«ã¯ãäžéœåããããããŠããŸã圢ã«ãªããŸããããã§ã埮åã§ã¯ããã®ã§ããã以äžïŒç¹ã«ãŠãè£å¡«ãšãããŠããã ããã°ãšèããŠãããŸããã»å€§å¹ ã«æžãçŽããç« ïŒ2, 20, 23ç« ãäºå®ïŒã®PDFé åžã»ãããžã§ã¯ãã«ãŠ [第2ç] è³Œå ¥ã®ãæ¯æŽãããã ããçããŸã®ãã¡30åããŸã« [第3ç] ããã¬ãŒã³ã詳ããã¯ãå ·äœçãªã¹ã±ãžã¥ãŒã«ã決ãŸã次第ããã¡ãã®æŽ»åå ±åã«ãŠãäŒãããããŸããã©ãããç¶å ±ã«ã€ããŠãåŸ ã¡ããã ããã°å¹žãã§ãããããããé¡ãããããŸãã ãã£ãšèŠã- ãææ°ã®ãGoogle Apps Scriptå®å šå ¥éãããã¡æ©ãäžã«å±ãããïŒããããžã§ã¯ããªãŒããŒã®ã¿ã«ãã·ããªã¢ãã§ãã åŒãç¶ãæ¬æžã«ã€ããŠã¯æžåºããã³ãªã³ã©ã€ã³ã§å¥œèª¿ã«æšç§»ããŠãããŸããã¿ãªããŸã®ããååãšãæ¯æŽãæ¹ããŸããŠæè¬ããããŸããããŠã以äžã®å ±åã§ãäŒãããŠãããŸãéããGoogle Apps Scriptã®æ°IDEãé 次æäŸãããŠãããŸããhttps://camp-fire.jp/projects/249472/activities/226590#main圱é¿ãããããŒãã«ã€ããŠã®èª¿æ»ããã³ããã°ããã€ãé£ã«ITã®ãä»äºãã§ã®ãã©ããŒèšäºã«ã€ããŠå·çãå®äºããããŸããã®ã§ããå ±åããããŸãããŸããå·çåœæã¯æããã«ãããŠããªãã£ããGoogle Workspaceãžã®ãã©ã³å€æŽã«ããå¶éãšå²ãåœãŠã®å€æŽã«ã€ããŠãèšäºãè¿œå ããããŸãããããããã以äžãªã³ã¯å ãã該åœèšäºãã芧ããã ããŸãã®ã§ã確èªãã ãããŸããhttps://tonari-it.com/google-apps-script-perfect-guide-book-2/#toc6äžæž¬ã®äºæ ãšã¯ãããçããŸã«ã¯ãé¢åããããããããŸããã©ãããåŒãç¶ãæ¬æžãã掻çšãããã ããã°å¹žãã§ãã ãã£ãšèŠã
ã³ã¡ã³ã
ãã£ãšèŠã