[B! Google Apps Script] w-zero3ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

w-zero3 id:w-zero3

Google Apps Scriptã«é–¢ã™ã‚‹w-zero3ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

åˆå¿ƒè€…ãŒGASã§åŒçª“ä¼šã®å‚åŠ å—ä»˜ã‹ã‚‰åç°¿æ›´æ–°ã¾ã§ã‚’è‡ªå‹•åŒ–ã—ãŸè©± - ytmatsuge's log
ã“ã®è¨˜äº‹ã¯Â CAMPHOR- Advent CalendarÂ ã®16æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ytmatsuge ã§ã™ã€‚ æ™®æ®µã¯å…æœ¬æœ¨ã®ä¼šç¤¾ã§æ–°è¦äº‹æ¥ã®ãƒ“ã‚¸ãƒã‚¹ã‚µã‚¤ãƒ‰ã‚’æ‹…å½“ã—ã¦ãŠã‚Šã¾ã™ã€‚ æœ¬æ—¥ã¯ã€éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç§ãŒã€åŒçª“ä¼šå§”å“¡ã®è² æ‹…ã‚’æ¸›ã‚‰ã™ã¹ãã€å‡ºæ¬ ç¢ºèªãƒ»åç°¿æ›´æ–°ã®è‡ªå‹•åŒ–ã«æºã‚ã£ãŸè©±ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ è‡ªå‹•ç¢ºèªãƒ¡ãƒ¼ãƒ«ã®é€ä¿¡ è‡ªå‹•æ›´æ–°åç°¿ã®ä½œæˆæ–¹æ³• ä¸Šè¨˜ã®ã‚ˆã†ãªæŠ€è¡“çš„ãªè©±ã¯ã‚‚ã¡ã‚ã‚“ã§ã™ãŒã€ã€Œæ¯ä¸–ä»£ã§ã‚‚åˆ©ç”¨ã—ã‚„ã™ã„ã‚µãƒ¼ãƒ“ã‚¹ä¼ç”»ãƒ»è¨è¨ˆã€ã€Œæœ€å°é™ã®ã‚³ã‚¹ãƒˆã§å•é¡Œè§£æ±ºã™ã‚‹æ–¹æ³•ã€ãªã©ã€æ¥å‹™ä¸Šã®ç›®çš„ã§å®Ÿéš›ã«åˆ©ç”¨ã•ã‚Œã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã¤ãã‚‹ã«ã‚ãŸã£ã¦ã„ãã¤ã‹ãƒãƒ¼ãƒ‰ãƒ«ãŒã‚ã£ãŸã®ã§ã€å°‘ã—ã§ã‚‚å‚è€ƒã«ã—ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ æ”¹å–„å‰ã®çŠ¶æ³ æ”¹å–„å‰ã®çŠ¶æ³ã§ã¯ã€åŒçª“ä¼šäº‹å‹™å±€ã¨å’æ¥ç”ŸãŒãƒ¡ãƒ¼ãƒ«ã§ã‚„ã‚Šå–ã‚Šã‚’ã—ã€ ãã®æƒ…å ±ã‚’ã‚¨ã‚¯ã‚»ãƒ«ã«è»¢è¨˜ã—ãƒªã‚¹ãƒˆã‚’ä½œæˆã—ã¦ã„ã¾ã—ãŸã€‚å›³ã«ã™ã‚‹ã¨æ¬¡ã®ã‚ˆã†ãªæµã‚Œã«ãªã‚Šã¾ã™ã€‚ ã“ã‚Œã‚’è¦‹ãŸè‹¥è€…ã¯ ã„ã‚„ã€ LINE
w-zero3 2017/12/16
Google

Google Apps Script
ãƒªãƒ³ã‚¯
çŸ¥ã‚‰ãªãã‚ƒæã™ã‚‹Google Apps Scriptã®å¤–éƒ¨JSONãƒ‡ãƒ¼ã‚¿é€£æºè¡“ï¼ã™ã¹ã¦ç„¡æ–™ã§ä½œã‚‹ã€ŒãŠå¤©æ°—Webã‚¢ãƒ—ãƒªã€ã®ä½œã‚Šæ–¹ã‚’å¤§å…¬é–‹ï¼ -
ã©ã†ã‚‚ã€ã¾ã•ã¨ã‚‰ã‚“ï¼ˆ@0310lanï¼‰ã§ã™ã€‚ ã¿ãªã•ã‚“ã¯ã€ã€ŒGoogle Apps Scriptï¼ˆä»¥ä¸‹ã€GASï¼‰ã€ã‚’ä½¿ã£ãŸã“ã¨ãŒã‚ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ æ˜”ã¯ã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®ãƒžã‚¯ãƒçš„ãªä½¿ã„æ–¹ã§ã‚ã£ãŸã‚Šã€Googleã‚µãƒ¼ãƒ“ã‚¹ã‚’é€£æºã™ã‚‹ãŸã‚ã«ä½¿ã†ã“ã¨ãŒå¤šã‹ã£ãŸã‚ˆã†ãªæ°—ãŒã—ã¾ã™ã€‚ ã—ã‹ã—ã€ä»Šã§ã¯GASã‚’å˜ä½“ã§åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã€ç°¡å˜ãªWebã‚¢ãƒ—ãƒªã‚’ä½œã£ã¦å…¬é–‹ã—ãŸã‚Šã€ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã‚’ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ä»£ã‚ã‚Šã«ä½¿ã£ãŸã‚Šãªã©ã€ã‹ãªã‚ŠæŸ”è»Ÿãªåˆ©ç”¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ãã“ã§ä»Šå›žã¯ã€ç°¡å˜ãªã‚µãƒ³ãƒ—ãƒ«äº‹ä¾‹ã¨ã—ã¦ã€Œå¤©æ°—äºˆå ±ã€ã®å¤–éƒ¨JSONãƒ‡ãƒ¼ã‚¿ã‚’GASã§å–å¾—&åŠ å·¥ã—ã€ã‚·ãƒ³ãƒ—ãƒ«ãªã€ŒãŠå¤©æ°—Webã‚¢ãƒ—ãƒªã€ã‚’ä½œã‚‹æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ï¼ GASã¯ã€ç‹¬è‡ªã«æä¾›ã•ã‚Œã¦ã„ã‚‹APIã‚’é™¤ã‘ã°ã€ã”ãæ™®é€šã®JavaScriptãªã®ã§èª°ã§ã‚‚æ‰±ã„ã‚„ã™ã„ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãŒå‡ºæ¥ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ â– Google Apps Scri
w-zero3 2016/10/24
ã‚ã¨ã§èªã‚€

Google Apps Script
ãƒªãƒ³ã‚¯
ã€è¦šæ›¸ã€‘Google Fusion Tables ã« Google Apps Script ã§ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ‰‹é † - é¢¨æŸ³ãƒ¡ãƒ¢
ã²ã¨ã¾ãš Google Fusion Tables ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸãŒã€ä½•ã‚‰ã‹ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ–¹æ³•ã‚’èª¿ã¹ãªã„ã¨â€¦â€¦ã¨ã„ã†ã“ã¨ã§ã€Google Apps Scriptãªã‚‹ã‚‚ã®ï¼ˆå®Ÿã¯ã“ã‚Œã‚‚åˆã‚ã¦ã„ã˜ã‚‹ï¼‰ã§è©¦ã—ã¦ã¿ã‚‹ã€‚ Google ãƒ‰ãƒ©ã‚¤ãƒ–ã« Google Fusion Tables ã®ã‚¢ãƒ—ãƒªã‚’è¿½åŠ ï¼ˆæŽ¥ç¶šï¼‰ï¼ˆåˆå›žã®ã¿ï¼‰ Googleãƒ‰ãƒ©ã‚¤ãƒ–ã®ãƒžã‚¤ãƒ‰ãƒ©ã‚¤ãƒ–ã‹ã‚‰ã€ [æ–°è¦] â†’ ãã®ä»– â†’ ï¼‹ã‚¢ãƒ—ãƒªã‚’è¿½åŠ ã¨ãŸã©ã£ã¦ã€ By Google ã‹ã‚‰ Google Apps Script ã‚’æŽ¢ã—å‡ºã—ã€ æŽ¥ç¶šã™ã‚‹ã€‚ ã“ã®æ‰‹é †ã¯ä¸€åº¦å®Ÿæ–½ã™ã‚‹ã ã‘ã§è‰¯ã„ã€‚ Google Apps Scriptã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã—ã€Fusion Tables ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚ˆã†è¨å®š Googleãƒ‰ãƒ©ã‚¤ãƒ–ã®ãƒžã‚¤ãƒ‰ãƒ©ã‚¤ãƒ–ã‹ã‚‰ã€ [æ–°è¦] â†’ ãã®ä»– â†’ Google Apps Script ã¨é¸æŠžã—ã€ ã€Œç©ºã®ãƒ—ãƒã‚¸
w-zero3 2016/07/12
Fusion Tables

Google

Google Apps Script

Googleãƒ‰ãƒ©ã‚¤ãƒ–
ãƒªãƒ³ã‚¯
å®šæœŸçš„ã«Google Documents/Spreadsheets/Slidesã‚’è‡ªå‹•çš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹æ–¹æ³•(Microsoft Word / Excel / PowerPointå¤‰æ›å¯¾å¿œ) | æœ€é©åŒ–ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°-Thanksmaker
ä½¿ç”¨æ–¹æ³•Google Driveã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¿ç®¡ã—ã€ç®¡ç†ã—ã¦ã„ã‚‹ã“ã¨ã‚’å‰æã«ä¸‹è¨˜ã®è¨å®šæ–¹æ³•ã‚’è¨˜è¼‰ã—ã¾ã—ãŸã€‚ ã“ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®æ¦‚è¦Google Driveã«ä¿å˜ã•ã‚Œã¦ã„ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«(Google Documents, Google Spreadsheets, Google Slides)ã‚’å®šæœŸçš„ã«ãƒ•ã‚¡ã‚¤ãƒ«ãŒMicrosoftå½¢å¼ã«å¤‰æ›ã—ã€.xlsx/.docx/.pptxå½¢å¼ã§æ·»ä»˜ã—ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å®šæœŸçš„ã«è‡ªå‹•ã§ãƒ¡ãƒ¼ãƒ«ã‚’é€ä¿¡ã™ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€‚åãƒ•ã‚©ãƒ«ãƒ€ã«ã‚‚å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ ç‰¹å¾´æ·»ä»˜ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã®å¢—å¤§ã‚’é˜²ããŸã‚ã«ã€å¤‰æ›´ãŒã‚ã£ãŸãƒ•ã‚¡ã‚¤ãƒ«ã®ã¿ã‚’ãƒ¡ãƒ¼ãƒ«ã«æ·»ä»˜ã—ã¦é€ä¿¡ã™ã‚‹ã€‚(ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯24æ™‚é–“ä»¥å†…ã«å¤‰æ›´ãŒã‚ã£ãŸãƒ•ã‚¡ã‚¤ãƒ«)ã€‚å·®åˆ†å–å¾—ã®æ™‚é–“ã®å¤‰æ›´ã¯å¯èƒ½ã€‚ ãƒ•ã‚©ãƒ«ãƒ€ã®è¤‡æ•°éšŽå±¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚‚å¯¾å¿œã€‚ Google Driveã«ãƒã‚°ã‚¤ãƒ³ Google Driveã«ãƒã‚°ã‚¤ãƒ³ã—ã¦ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹æŒ‡å®šã®ãƒ•ã‚©ãƒ«ãƒ€ã«ç§»
w-zero3 2016/07/07
Google Apps

Google Apps Script

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
Fusion TablesÃ—Google Apps Scriptï¼ˆFusion Tablesåˆ©ç”¨ç·¨ï¼‰ - Qiita
ã“ã“ã§ã¯ã€ä¸»ã«Fusion Tablesã«é–¢ã™ã‚‹èª¬æ˜Žã‚’æ›¸ã„ã¦ã„ãã¾ã™ã€‚ â€» åˆ¥é€”Google Apps Scriptã¨é€£æºã•ã›ã¦ã¿ã¾ã™ Fusion Tablesã¨ã¯ ç°¡å˜ã«ã¾ã¨ã‚ã‚‹ã¨ã€GoogleãŒæä¾›ã—ã¦ã„ã‚‹åœ°å›³æƒ…å ±ã¨é€£æºã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹(æ£ç¢ºã«è¨€ã†ã¨ã€"ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹"ã¯ãªãã€ãƒ†ãƒ¼ãƒ–ãƒ«ã§ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢)ã§ã™ã€‚ Googleã®å…¬å¼ã‚µã‚¤ãƒˆã§ã®èª¬æ˜Žã¯ã“ã¡ã‚‰ åœ°å›³æƒ…å ±ã¨é€£æºã§ãã‚‹ç‚¹ãŒç‰¹å¾´ã®1ã¤ãªã®ã§ã™ãŒã€åœ°å›³ã¨é€£æºã›ãšã«ã™ãã«ä½¿ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã‚‚åˆ©ç”¨ã§ãã¾ã™ã€‚ Googleã‹ã‚‰é€£æºå¯èƒ½ã¨ã—ã¦ã„ã‚‹Googleã‚µãƒ¼ãƒ“ã‚¹ã¯ä»¥ä¸‹ã®4ã¤ã§ã™ã€‚ 1.Maps APIï¼ˆåœ°å›³æƒ…å ±ã®åˆ©ç”¨ï¼‰ 2.Chart Tools APIï¼ˆã‚°ãƒ©ãƒ•ã®ä½œæˆï¼‰ 3.Google Drive Web APIsï¼ˆGoogleãƒ‰ãƒ©ã‚¤ãƒ–ã®æ“ä½œï¼‰ 4.Google Apps Script ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼
w-zero3 2016/07/07
Fusion Tables

Google Apps

Google Apps Script

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1