ã¯ããã«
æè¿ã§ã¯ DX ãšããèšèãããèããŸãããå®éã«èªåãã¡ã®æ¥åã®äžã®ã©ã®éšåãã©ã®ããã«èªååãå¹çåã§ããã®ãã«ã€ããŠããŸãã€ã¡ãŒãžã湧ããªããã©ãããæãã€ããŠããã®ãããããªããšããæ¹ã¯éåžžã«å€ãå°è±¡ã§ãããã ããããã©ã®ãããªéžæè¢ãåããã®ãäžæãªããšãå€ããäœããå§ããã°è¯ããããããªããšããã®ã¯è³ã£ãŠèªç¶ã®ããšã§ãã
ããã§ãã®èšäºã§ã¯ãDXåãæšé²ããäžç°ãšããŠè«æ±æžãçŽåæžãªã©ã®æ¥åäžäœæãå¿ èŠãšãªãæžé¡ãèªåäœæããããã®ã·ã¹ãã ã0ããã®æ°èŠéçºã§ã¯ãªããGoogleã¹ãã¬ããã·ãŒããšãããµãŒãã¹ã掻çšããŠæ§ç¯ããã²ãšã€ã®äºäŸã«ã€ããŠçŽ¹ä»ããèšäºã§ãã
åŒç€Ÿã§ã¯ 0 ããã®æ°èŠéçºããã¯ãããã®ã§ã¯ãªãããŸãã¯ã§ããéãæ¢åã®ãµãŒãã¹ããœãããŠã§ã¢ã掻çšããŠèª²é¡è§£æ±ºã«ææŠãããã®åŸã§å¿ èŠã«å¿ããŠç¬èªã·ã¹ãã ãæ§ç¯ããããšããå§ãããŠããŸãã
æ§ç¯åã«å ±éããŠããç¶æ³
ã·ã¹ãã æ§ç¯åã®ãçžè«ãããã ããæç¹ã§ã¯ä»¥äžã®ãããªç¶æ³ã§ããã
- è«æ±æžæ å ±ãªã©ã®ææžäœæã«äœ¿çšããããŒã¿ã Excel ãã¡ã€ã«ã«ããŒã¿ãå ¥åããŠç®¡çããŠããã
- Excel ãã¡ã€ã«ã®ããŒã¿ã Word ãã¡ã€ã«ã®ãã³ãã¬ãŒããã¡ã€ã«ã«ã³ããŒããŠè«æ±æžãäœæããŠããã
- ãèŠç©ãã«ã€ããŠã¯ Excel ã«ããŒã¿å ¥åãªã©ã¯ããã«ãèŠç©ããäŸé ŒãããéœåºŠãWord ãã¡ã€ã«ã®ãã³ãã¬ãŒããã¡ã€ã«ã«èŠç©ããé ç®ãèšç®ãå ¥åããŠããã
çºçããŠããåé¡
ç²åºŠã¯ãã©ãã©ã§ããã以äžã®ãããªåé¡ãçºçããŠããŸããã
- 瀟å¡æ°ãå¢ããã«ã€ããŠææ°ã®ãã³ãã¬ãŒããã¡ã€ã«ãã©ãã«ããã®ãããããªããªã£ãŠããŸããããããã®ç€Ÿå¡ãç°ãªããã³ãã¬ãŒãã§è«æ±æžãèŠç©æžãäœæããŠããã
- èŠç©ãæžèªäœã¯éè€ããŠããç®æãå€ãã«ãé¢ããããæ¯ååãå 容ãæå ¥åããå¿ èŠãããéå¹ççã§ãã£ãã
- åãå 容ã«ãé¢ãããè«æ±æžã®ããŒã¿ã Excel ãã¡ã€ã«ãšè«æ±æžçšã® Word ã®ãã³ãã¬ãŒããã¡ã€ã«ã«ããããæå ¥åããŠãããããããŒã¿ã®å ¥åæŒãã誀ããçºçããŠããã
åç¯ã®ç¶æ³ãšäžèšã®ãããªåé¡ç¹ãèžãŸããŠããŸãäžçªæ©ãå°ãã§ãæ¹åã§ããéžæè¢ãšããŠãGoogle ã¹ãã¬ããã·ãŒããš Google Apps Script ã掻çšããã·ã¹ãã ãæ§ç¯ããŸããã
Google ã¹ãã¬ããã·ãŒããš Google Apps Script ã®æŽ»çšããã·ã¹ãã
Google 瀟ãæäŸããŠãã Google ã¹ãã¬ããã·ãŒãããã³ Google Drive ãš Google Apps Script ã掻çšããã·ã¹ãã ãæ§ç¯ããŸããã
Google ã¹ãã¬ããã·ãŒãã¯ãèŠãç®ã䜿ãæ¹ã¯åºæ¬çã« Excel ãšåããã®ã§ããGoogle Apps Script 㯠Excel ã®ãã¯ããšåçã®ãã®ãGoogle Drive ã¯ãªã³ã©ã€ã³äžã®ãã©ã«ããšèããŠããã ããã°ãšæããŸãã
æ§ç¯ããã·ã¹ãã ã§ã¯ãExcel ã«å ¥åããŠããå 容ããã®ãŸãŸ Google ã¹ãã¬ããã·ãŒãã§å ¥åã§ããããã«ããŸãã以äžã Google ã¹ãã¬ããã·ãŒãã®ãµã³ãã«ç»é¢ã§ãããèŠãŠåããéã Excel ãšåãããã«èŠããŸããïŒä»¥äžã®ç»åå ã®ããŒã¿ã¯å šãŠãããŒããŒã¿ã§ããïŒ
ãããŠä»¥äžã®ããã«è«æ±æžäœæçšã®ã¡ãã¥ãŒãè¿œå ããå¿ èŠãªæã«ã¯ãªãã¯ããããšã§è«æ±æžãçæã§ããããã«ããŸãããGoogle ã¹ãã¬ããã·ãŒãã§ã¯ä»¥äžã®ããã«ä»»æã®ã¡ãã¥ãŒãè¿œå 衚瀺ã§ããããã䜿çšãããŠãŒã¶ãŒåŽãæ¯èŒçæµææãªã䜿ãå§ããããšãã§ããŸãã
ã¡ãã¥ãŒããè«æ±æžçæãå®è¡ãããšã以äžã®ããã«æå®ãã Google Drive ã®äžã«è«æ±æžã® PDF ãã¡ã€ã«ãçæãããããã«ãªããŸãã
ã¡ãªãã
Google ã¹ãã¬ããã·ãŒãã掻çšããã·ã¹ãã ã«ã¯ä»¥äžã®ãããªã¡ãªããããããŸãã
- æ¡ä»¶ããåãã°äœ¿ããããã«ãªããŸã§ããšã«ããæ©ããæ©ã觊ã£ãŠè©ŠããŠã¿ãããšãã§ããã
- ç¹å¥ãªãœãããŠã§ã¢ãã€ã³ã¹ããŒã«ããå¿ èŠããªãããã瀟å PC ãžã®ã€ã³ã¹ããŒã«ãªã©ãäžèŠã
- Excel ãšæäœæãåºæ¬çã«åããããæµææãå°ãªã䜿ãå§ããããšãã§ããã
- é©åã«éçšããã°ãŠãŒã¶ãŒæ¯ã®æš©é管çãã§ããã
- èªåããã¯ã¢ãããåæç·šéæ©èœãæšæºã§ä»ããŠããã
ãã ããGoogle ã¹ãã¬ããã·ãŒããš Google Apps Script ã掻çšããã·ã¹ãã ã«ã¯ä»¥äžã®ãããªãã¡ãªããããããŸãã
ãã¡ãªãã
以äžã¯å¿ ããã Google ã¹ãã¬ããã·ãŒãã«éã£ããã¡ãªããã ãã§ã¯ãããŸããããGoogle ã¹ãã¬ããã·ãŒããš Google Apps Script ã掻çšããã·ã¹ãã ãæ§ç¯ããå Žåã«èæ ®ãã¹ãç¹ã«ãªããŸãã
- Google Apps Script ã¯åŠçæéãæ倧 6 åéã«å¶éãããŠãããããåŠçæéãé·ãå Žåã¯å¥ã®æ¹æ³ãæ€èšããå¿ èŠãããã
- Google ã¹ãã¬ããã·ãŒãã®èª€ã£ãæš©éèšå®ã«ãã£ãŠ Google ã¹ãã¬ããã·ãŒãã®æ å ±ãå€éšããé²èŠ§å¯èœãªç¶æ ã«ãªãå¯èœæ§ãããã
- è«æ±æžãèŠç©æžãªã©ã®ææžçææ©èœã ãã§ãªããéå»ã®ããŒã¿ã®åæãéèšãä»ã®ã·ã¹ãã ã®å¯ãªé£æºãå¿ èŠã«ãªããšãGoogle ã¹ãã¬ããã·ãŒããš Google Apps Script ã ãã§ã¯å¯Ÿå¿ã§ããªããªãå¯èœæ§ãããã
- æäœéã®äœ¿ãæ¹ãéçšæ¹æ³ãæ€èšããŠæ £ããå¿ èŠãããã
- Google ã¹ãã¬ããã·ãŒãã«é害ãçºçããŠããå Žåã¯ã·ã¹ãã ãå©çšã§ããªããªãå¯èœæ§ãããã
äžèšã®ãããªãã¡ãªãããã©ããããåé¡ã«ãªã£ãŠãããã«ãã£ãŠãç¬èªã®ç€Ÿå ã·ã¹ãã ãïŒããæ°èŠéçºããæ¹ãè¯ããããããã¯ä»ã®ãªãŒãã³ãœãŒã¹ãœãããŠã§ã¢ã掻çšããæ¹ãè¯ãããªã©ãæ€èšããå¿ èŠããããŸãã
çºå±ç³»ã«ã€ããŠ
åè¿°ããã·ã¹ãã ã¯ããã«ä»¥äžã®ãããªæ©èœãè¿œå ããããšã§ããã䟿å©ã«ãªããŸãã
- Web ãµã€ãã®ãã©ãŒã ãšé£æºããŠãäŸãã°ãèŠç©ãå 容ãèªå㧠Google ã¹ãã¬ããã·ãŒãã«ä¿åãèŠç©æžã®èªåçæãè¡ãã
- è«æ±æžã®çæãšåæã«ã¡ãŒã«ã®äžæžããèªåäœæããããã¯èªåéä¿¡ããã
- LINE ãšé£æºã㊠LINE ãžã®ã¡ãã»ãŒãžéä¿¡ãè¡ãã
è²»çšãšæéã«ã€ããŠ
åŒç€Ÿã§ã¯ãGoogle ã¹ãã¬ããã·ãŒããš Google Apps Script ã掻çšããã·ã¹ãã ã®æ§ç¯ãæäœä»¥äžã®è²»çšãšæéã§å¯Ÿå¿å¯èœã§ãã
- å¿ èŠæé: 1 é±éã
- æ§ç¯è²»çš: 30 äžåã
ãŸãšã
Google ã¹ãã¬ããã·ãŒããš Google Apps Script ã¯ãDX åã®æåã®äžæ©ãšããŠãšãŠãæå¹ãªããŒã«ã§ãããŸã Google ã¹ãã¬ããã·ãŒããä»ã®æ¢åããŒã«ã®çµã¿åããã«ãã£ãŠæ¥åå¹çåãæ€èšãéçšãããã®äžã§èŠããŠãã課é¡ã«å¿ããŠç¬èªã·ã¹ãã ãæ§ç¯ãããšããæ¹æ³ããDX åãé²ããäžã§ã®æãå¹ççãªæ¹æ³ã®ïŒã€ã ãšèããŠããŸãã
æ¬èšäºã®å
容ã«é¢ããããDX åã«ã€ããŠãæ€èšäžã®æ¹ããèå³ãããå Žåã¯ããã²äžåºŠãçžè«ãã ããã
ãåãåãã