å æ¥GTUG Girls è¨ç«ã®ãã¥ã¼ã¹ãDeveloper Relations Japan Blogããã¢ãã¦ã³ã¹ããã¾ãããä»æ¥ã¯ãã®ç¬¬ä¸åmeetupã¨ãããã¨ã§Google Apps Script(ç¥ãã¦GAS)ã®ãã³ãºãªã³ãå®æ½ãããç§ã¯ãã¥ã¼ã¿ã¼ã¨ãã¦åå ãã¾ããã å®æ½ããåã¯ãGoogle Apps Scriptã¨ããé¡æããã¤ãã¼ããã ããGTUGç³»ã®ã¤ãã³ãã¯å¿åè ã®ã¹ãã«ã¬ãã«ãã¾ã£ããæ³å®ã§ããªãã¨ããç¹ã§ããµãã¼ãã®äººå¡ä¸è¶³ãå¿é ã§ããã ãããå®éã«ã¯JavaScriptã®çµé¨è ã®æ¹ã«ã¯å¤§ãã¦é£ãããªãã£ãããã§ãããå ·åã«ãè¿ãã«åº§ã£ã¦ããåå è å士ã§ãµãã¼ãããããã¨ãããæé«ã®å½¢ãã§ãããã£ã¦é²ãã§ããããã§ããããã¨ãã¾ããã å人çã«ã¯å¥³åãªã³ãªã¼ã®ãã³ãºãªã³ã¯äºåç®ã®åå ã«ãªãã®ã§ãããä»åã以åã®å¥³åããã«ã½ã³ã®æã¨åæ§ãã¿ããªçå£ã§ãããããªãã
"ãã©ãããã©ã¼ã â ãã¦ã£ãããã£ã¢ã§èª¿ã¹ã¦ã¿ã㨠ãã©ãããã©ã¼ã ï¼Platformï¼ã¨ã¯ãã³ã³ãã¥ã¼ã¿ã«ããã¦ã主ã«ããªãã¬ã¼ãã£ã³ã°ã·ã¹ãã ï¼OSï¼ããã¼ãã¦ã§ã¢ã¨ãã£ãåºç¤é¨åãæãã ä¸è¬çãªã³ã³ãã¥ã¼ã¿ã¼ããã°ã©ã ï¼ã¢ããªã±ã¼ã·ã§ã³ã½ããã¦ã§ã¢ï¼ã¯ãããããã®OSã«ä¾åããWindowsãMac OS XãLinuxãªã©ã®å°ç¨ã®ããã°ã©ã ã¨ãã¦åãã¦ãããç¹å®ã®ãã¼ãã¦ã§ã¢ã§ããåããªãããã°ã©ã ããããä¾ãã°ãPowerPC ããã»ããµä¸ã® Linux ã§ã¯ãPowerPC ããã»ããµä¸ã®Mac OS X ç¨ã Pentium ããã»ããµä¸ã® Linux ç¨ã® Adobe Reader7.0 ã¯åä½ããªãã éä¾åã¨ã¯ããããã®OSããã¼ãã¦ã§ã¢ã«ä¾åããã«åãããã°ã©ã ã®ãã¨ãä¾ãã°ãJavaã¯ãã©ãããã©ã¼ã éä¾åã売ãã«ãã¦ãããä»ã®ãã©ãããã©ã¼ã ã®ä¸ã«ã¢ããã¿ã¨ã
å é± Google Apps Script åå¼·ä¼ #3ã«è¡ã£ã¦ãã¾ããã大é å»ã§ï¼ï¼åãããããåå ãã¾ããã§ãããã partake.in ã¨ãããã親ç¦ä¼ã§æ°ã«ãªã£ã¦ããã¨ãã¡ããã¡ããã話ã§ãã¦ããã£ãã§ããGWTãããããã£ã¨ãã¨èªããã¨ãæããã¾ããããããã¨ããããã¾ãã ãã¦ãåå¼·ä¼ã«åå ããã®ã¨ã¯ç´æ¥é¢ä¿ãããããã§ã¯ãªãã®ã§ãããä»åããããã¦è¨äºã«ããã®ã¯ãååæ¸è©ããã¢ãªã¨ã«äºä¸ããã®æ¬ã«ãã¨ãããããã¦ããããã«ãGoogle Apps Scriptã¯ãã¤ã¯S(P)aaS Scriptingç°å¢ã®å¤§æ¬å½ï¼ããããããããã¾ãå°ãªãã¨ã大穴ï¼ã§ã¯ãªããã¨ããäºæ³ã«ãã£ã¦ãã§ã¯ä»ç¾å¨ä¸ã®ä¸ã§åã馳ãã¦ããã ããã¨ããã®Force.comã«ã¤ãã¦ã¯ããããªãã®ããã¨ããæ³èµ·ãå¾ãããã§ãã ãã®è¨äºãèªã¾ããæ¹ã®ä¸ã«ã¯ãForce.comã£ã¦ä½ããã¨ããæ¹ãå¤ãã§ããã
ã2014/12/26ï¼è¿½è¨ã ãã®è¨äºã¯Googleã®ä»æ§å¤æ´ãªã©ã§å 容ãå¤ããªã£ã¦ãããããææ°ã®æ å ±ã§æ¸ãæãã¾ããã ãªã³ã¯å ã®è¨äºãåç §ãã¦ãã ããã Googleãã©ã¤ãã®ãã©ã¼ã æ©è½ããGoogle Apps Scriptã使ã£ã¦ã¡ã¼ã«èªåè¿ä¿¡2014å¹´ç [C!] Googleããã¥ã¡ã³ãã§ç°¡åã«WEBãã©ã¼ã ãä½æã§ããæ©è½ãããã®ã§ãããã¢ã³ã±ã¼ãããåãåãããã©ã¼ã ãªã©ãããã«ä½ããã®ã§å人ã§ãä»äºã§ãå¤æ§ãã¦ãã人ãå¤ãã®ã§ã¯ãªãã§ããããããã®ãã©ã¼ã æ©è½ããã©ã¼ã ããã®éä¿¡å 容ã¯ããã¥ã¡ã³ãã®ã¹ãã¬ããã·ã¼ãï¼Excelã©ã¤ã¯ãªè¡¨ï¼ã«ã¾ã¨ã¾ãã®ã§ãããå ±æãã¦ããã°è¤æ°äººã§ã管çãããã¨ãã§ãã¾ãããã ãåé¡ãããã¨ããã°éä¿¡å 容ã«ãã£ã¦ã¯ããã«è¿ä¿¡ãããã®ã«ã¡ã¼ã«éç¥æ©è½ãã¤ãã¦ããªããã§ããï¼ãã©ã¼ã æ©è½ãã§ããåæã«ã¯ã¡ãã¥ã¼ã«ãã£ãæ°ãããã®ã§ããâ¦ï¼
Google Apps Scriptã®æ¦è¦ Google Apps Script 㯠Google products ãå¶å¾¡ããæ°ããªæ®µéãã¦ã¼ã¶ã¼ã«æä¾ãã¾ãã èªä½ã® JavaScript ããã°ã©ã ãç¨ã㦠Google Spreadsheets ãã¯ãããä»ã® Google products ã«ã¢ã¯ã»ã¹ãå¶å¾¡ãããã«ã¯å ±æãå¯è½ã«ãã¾ãã ä»ã¾ã§ã®ãã©ã¦ã¶ãã¼ã¹ã® JavaScript ããã°ã©ã ã¨ã¯ç°ãªããã¹ã¯ãªãããå¶å¾¡ãã Google products ã«ã¢ã¯ã»ã¹ã§ããããã« Google ã®ãµã¼ãã¼ä¸ã§èªä½ã®ã¹ã¯ãªãããå®è¡ãããã®ã§ãã åç §ãã¼ã¸(Goolge) ã¦ã¼ã¶ã¼ã¬ã¤ã/æ¦è¦ Getting Started/Google Apps Scriptãã¯ãããã Writing Scripts/ã¹ã¯ãªãããæ¸ã Common Tasks/ä¸è¬çãªã¿ã¹ã¯ã®ããã°ã©
ä»æµè¡ã®ãµã¼ãã¼ãµã¤ãJSã¨ããã¨ï¼ 10人ä¸9人以ä¸ãnode.jsã¨ããä»æ¥ãã®é ã§ããããããéããã§ããããï¼node.jsåãã§ããããã¹ã´ã¤ã¹ã´ã¤ãã´ã¤ã¹ã¼ã§ããã§ãå®éä½ã«ä½¿ãã¾ãããï¼ã¾ãé¢ç½ãã§ãããã ã§ã話ã¯å¤ãã£ã¦GASã§ããGASã¨ã¯ãGoogle Apps Scriptã®ç¥ã§Google Docsã®ã¹ãã¬ããã·ã¼ãã®æ©è½ã®ä¸ã¤ã§ããã¹ãã¬ããã·ã¼ãã«æå±ããå½¢ã§ä¿åããã¾ããå®è¡ã¯Googleã®ãµã¼ãã¼ä¸ã§è¡ããçµæãè¿ãã¾ãããGASã®ç¹å¾´ã®ä¸ã¤ã§ãGoogleå å¤ã®ã®æ§ã ãªãµã¼ãã¹ã®ãã¼ã¿ã«ã¢ã¯ã»ã¹ãããã¨ãåºæ¥ã¾ãã ã«ã¬ã³ãã¼ ã³ã³ã¿ã¯ã ã¡ã¼ã«ï¼éä¿¡ã®ã¿ï¼ ãµã¤ã ããã Docs UrlFetch xml Jdbc ãªã©ãªã©ã§ããåå以ä¸ã®ãµã¼ãã¹ã¯ç¡æã¢ã«ã¦ã³ãã§å©ç¨å¯è½ã§ãã ä»æ¥ã®ããã£GASåå¼·ä¼ã§ãUi Servicesãããã£ãã®ã§ç´¹ä»ã
@atusi ãã主å¬ã®Google Apps Scriptåå¼·ä¼#2 ã«åå ãã¾ããã 第ä¸åã®æã¨ã¯éããååãããã®äººããGoogle Apps Scriptã触ã£ããã¨ãããï¼ãã¨ããç¶æ ã§ããã¯ãªã§ããæ¥æ¬ã§ãããªã«GASã触ã£ã¦ãã人ããããªãã¦â¦ã çºè¡¨è³æãªã© @webos_goodiesãããAWSã®ROUTE53ã¨Spreadsheetã®é£æºã¢ããªã®ç´¹ä»ãã@atusiãããGASã®æ¦è¦ã®èª¬æãããã¾ããã @webos_goodiesãã - GASã§ã¢ããªä½ã£ã¦ã¿ã@atusiãã - Google Apps Script #2 ãã«ã½ã³ ä»åã¯ããã«ã½ã³ä¸»ä½ã ã£ãã®ã§ãèªåãä½ãä½ããã¨ä½æ¥ãã¾ããããé¡ã¯ãä¼ç¤¾ã®å¤æ ã·ã¼ãã®å ¥åãè£å©ãããã¼ã«ãã§ããç§ã¯å¤æ ã·ã¼ããææ«ã«ã¾ã¨ãã¦è¨å ¥ãããã¼ããªã¿ã¤ãã§ãæ¯æå ¥åãé¢åã§ããããã§ãä¸è¨ã®æ©è½ãæã£ãã¹ã¯ãªãã
ã°ã¼ã°ã«ã¯ãGoogle Appsã®ããã°ã©ãã³ã°è¨èªãGoogle Apps Scriptãã«ããã©ãã°ï¼ããããã§ã¦ã¼ã¶ã¼ã¤ã³ã¿ã¼ãã§ã¤ã¹ãèªç±ã«æ§ç¯ã§ãããGUI Builderãæ©è½ã追å ããã¨ãGoogle I/O 2011ã®ã»ãã·ã§ã³ãDeveloping Apps, Add Ins and More with Google Apps Scriptãã§æããã«ãã¾ããã GUI Builderã¯ç¡æã§Googleããã¥ã¡ã³ããå©ç¨ãã¦ããã¦ã¼ã¶ã¼ã§ãå©ç¨å¯è½ã«ãªã£ã¦ãã¾ããGoogleããã¥ã¡ã³ãããä»»æã®ã¹ãã¬ããã·ã¼ããéããï¼»ãã¼ã«ï¼½ã¡ãã¥ã¼ããï¼»ã¹ã¯ãªããã¨ãã£ã¿ï¼½ãé¸æãèµ·åããã¹ã¯ãªããã¨ãã£ã¿ã®ï¼»ãã¡ã¤ã«ï¼½ã¡ãã¥ã¼ã®ï¼»ã¦ã¼ã¶ã¼ã¤ã³ã¿ã¼ãã§ã¤ã¹ãæ§ç¯â¦ããé¸æããã¨ãGUI Builderãèµ·åãã¾ãã å·¦å´ã®ãªãã¸ã§ã¯ãä¸è¦§ããããã¿ã³ãã©ãã«ãããã¹ãããã¯ã¹ã
ã¯ããã« Google Apps Scriptã§ã¯ãGoogleããã¥ã¡ã³ãã®ã¿ãªããGoogleã³ã³ã¿ã¯ããGoogleã«ã¬ã³ãã¼ãªã©å¤ãã®ãµã¼ãã¹ã«ã¢ã¯ã»ã¹ãããã¨ãã§ãã¾ããããããGoogleã¹ãã¬ããã·ã¼ãããå©ç¨ãã¦ã¿ã¾ãããã 対象èªè Webçãªãã£ã¹ã¢ããªã±ã¼ã·ã§ã³ã®å°å ¥ãèãã¦ããæ¹ã Googleããã¥ã¡ã³ãã¾ãã¯Google Appsãæ¢ã«ä½¿ã£ã¦ãã人ã å種ã®Webãµã¼ãã¹ã®èªååãèãã¦ãã人ã ã¹ã¯ãªãããé¢æ°ã¨ãã¦ä½¿ã ååãGoogle Apps Scriptã®åºæ¬æä½ã¨ãã¹ãã¬ããã·ã¼ãã®åºæ¬çãªæ±ãã«ã¤ãã¦èª¬æããã¾ãããä»åã¯ãã¹ã¯ãªããã®å©ç¨ã«ã¤ãã¦ããã«æ·±ãèãã¦ã¿ã¾ããããã¾ãã¯ããã¹ã¯ãªãããé¢æ°ã¨ãã¦ã»ã«ã«è¨å®ãããã¨ãããã¨ããã§ãã Google Apps Scriptã¯ãé¢æ°ã¨ãã¦ã¹ã¯ãªãããå®ç¾©ãã¾ããããã®é¢æ°ã¯ãGoogleã¹ã
ã¯ããã« ãGoogle Apps Scriptãã¯ãGoogleããã¥ã¡ã³ãã®ã¹ãã¬ããã·ã¼ãã«æè¼ããã¦ããã¹ã¯ãªããæ©è½ã§ããããã¯çºè¡¨å½åãGoogle Appsã®ææçï¼ãã¬ãã¢çï¼ã®ã¿ã§å©ç¨å¯è½ã§ãã£ãããããç¡åçã®ã¦ã¼ã¶ã¼ã¯ä½¿ããªããã¨æã£ã¦ãã人ãå¤ãã®ã§ã¯ãªãã§ãããããããç¾å¨ã§ã¯ãç¡æã§å©ç¨ã§ããGoogleããã¥ã¡ã³ãã§ãã¹ã¯ãªããã使ããããã«ãªã£ã¦ãã¾ãããããå©ç¨ããGoogleããã¥ã¡ã³ãã®ã¹ãã¬ããã·ã¼ããæä½ãããã¨ãã§ãã¾ããããã°ãExcelãªã©ã®ããã¯ããã¨åãæ©è½ãæä¾ãã¦ãããã®ã§ãã æè¿ã§ã¯ãã¯ã©ã¦ãã»ã¢ããªã±ã¼ã·ã§ã³ã¨ãã¦ãªãã£ã¹ã½ãããæä¾ãããããã«ãªã£ã¦ãã¾ãããGoogleã®ãGoogleããã¥ã¡ã³ããã ãã§ãªãããã¤ã¯ãã½ããããMicrosoft Office Web Appsããå ¬éãããªã©ãæ¬æ ¼çã«Webã¸ã®ç§»è¡ãé²ãã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}