ãã€ãŠé»åæ²ç€ºæ¿ãšèšãã°ãNiftyãã©ãŒã©ã ãæ巚倧æ²ç€ºæ¿ãYahooæ²ç€ºæ¿ãªã©æ å ±äº€æã®ã¡ãžã£ãŒãªå ŽæãšããŠæŽ»èºããŠããŸãããçŸåšã¯æ å ±äº€æãšãããããã¯ãäžæ¹çãªçºä¿¡ã身å ã§ã®ããåããšãªãTwitterãSNSãäž»æµã§ãããããã§ãæ²ç€ºæ¿ã«ã¯äžå®ã®éèŠããããŸãã
ãããããã€ãŠã®æ²ç€ºæ¿ã·ã¹ãã ã¯ããªãŒã®çŽ æãå€ããšã¯ããããµãŒããŒãå¿ èŠã§ããäžæ¹ã§ã¬ã³ã¿ã«æ²ç€ºæ¿ããããŸãããèªãã«ã¹ã¿ãã€ãºãåºæ¥ãªããã¢ã«ãŠã³ãç»é²ãå¿ èŠãªã©åå«ãªé¢ããããŸããæ²ç€ºæ¿ã¹ã¯ãªãããçŸåšã§ã¯ããã¡ãžã£ãŒã§ã¯ãªãPerlã§äœãããŠããããã¡ãžã£ãŒãªããã¡ãã£ãšé¢åãªPHPã ã£ãããšæ°æ¥œã§ã¯ãããŸããã
ããã§ä»åãGoogle Driveäžã®Googleã¹ãã¬ããã·ãŒãã§éçšã®åºæ¥ããGoogle Apps Scriptã§äœæããæ²ç€ºæ¿ã·ã¹ãã ãäœã£ãŠã¿ãŸãããã¹ã¯ãªãããæžããæ¹ã§ããã°ç°¡åã«æ¹é ãå¯èœã§ããïŒRSSé ä¿¡ããŠã¿ãããSlackã«éç¥ããŠã¿ãããã¹ã¿ãŒæ©èœãã€ããã¿ãããæ軜ã«ã¯ã©ãŠãäžã§æ©èœå¢åŒ·ãã瀟å ã§å¯èœãªã®ã¯è¯ãã§ããïŒã
â»2020/7/1 - Google Pickerã®ä»æ§ãå€ãã£ãŠããã®ãšãã°å¯ŸççšãšããŠPickerã®ã³ãŒããä¿®æ£ããŸããã
å³ïŒw2gridãšjqueryã§äœæããŠããŸãã
é åžç©äžèŠ§
èšçœ®æ¹æ³
ä»åã®Google Apps Scriptã®ã¢ããªã¯éåžžã«åçŽãªä»çµã¿ã§åäœããŠããŸãã以äžã®èšçœ®æé ã§èšçœ®ããŸãããããŸãã¯äºåæºåãã
ãã ããã®ãããžã§ã¯ãã®ç§»åãAPIã®è¿œå ãé¢åãªäººã¯ãããšããã¹ãã¬ããã·ãŒãã®æå®ãšãã©ã«ãIDã®çŽæ¥æå®ãã¿ã³ãæŒãã°ãçŽæ¥IDãå ¥ããããšãå¯èœã«ããŸããããã¡ãã®å Žåã¯ããããžã§ã¯ãã®ç§»åãPicker APIã®ååŸã¯äžèŠã§ãã
ãããžã§ã¯ãã移å
APIã®è¿œå
- ãã¡ãã®ãµã€ãã®äºåæºåã®ããã«ããŸãã¯Google Pickerã®APIããŒãååŸããŠãã ããã
- APIããŒãååŸããããGASBBSã¡ã€ã³ã¹ã¯ãªãããã¡ã€ã«ãéã
- ã¹ã¯ãªãããšãã£ã¿ãéãããPicker.htmlããPicker2.htmlãã®ïŒã€ãéã
- ããã«Picker APIã®APIããŒãèšè¿°ããã®éšåã«APIããŒãå ¥åããã
- å®äºããããã¹ã¬ãããã¡ã€ã«ãä¿åãããã©ã«ããäœæããŠããã
å³ïŒPickerã䜿ã£ãŠããã©ã«ããã¹ãã¬ããã·ãŒããéžæããŸã
ã¹ãã¬ããã·ãŒããšä¿åå ãã©ã«ãã®èšå®
- GASBBSã¡ã€ã³ã¹ã¯ãªãããã¡ã€ã«ãéã
- ã¡ãã¥ãŒãããå ±éèšå®ãâã管çè çšèšå®ããéã
- ãµã€ãããŒãéãã®ã§ãä¿åå ãã©ã«ãã®èšå®ãããŸãã¯ãã¹ã¬ããä¿åå ãã©ã«ããæå®ããŸãã
- 䜿çšãããã³ãã¬ãŒãã®éžæãããæ²ç€ºæ¿ã¹ã¬ããçšãã³ãã¬ãŒããã¡ã€ã«ãéžæããŸãã
- ç¹å®ã®ãŠãŒã¶ã«ã ãå©çšãããå Žåã«ã¯ããŠãŒã¶ãªã¹ãã®äœ¿çšã®ã¹ã€ããããªã³ã«ããŸãã
- 5.ã§ãªã³ã«ããå Žåã«ã¯ããŠãŒã¶ãªã¹ãã·ãŒãã«ã¡ã¢ããšæå±åãå ¥ããŠäžããŸãã
- ãã®èšå®ã§ãããè€æ°ã®Googleã¢ã«ãŠã³ãã«ãã°ã€ã³ããç¶æ ã ãšå€±æããããšãããã®ã§ãäžæŠå šéšãã°ã¢ãŠãããŠè©²åœã®ã¢ã«ãŠã³ãã®ã¿ã§äœæ¥ãè¡ã£ãŠãã ããã
çŽæ¥IDæå®ãã¿ã³ã®å Žåã¯çŽæ¥IDãæå®ãã¿ã³ãæŒããŠããã¡ã€ã«ããã©ã«ãã®IDãå ¥ããŠãããã°åæ§ã®ããšãå¯èœã§ãã
å³ïŒã¹ã¬ããã¯ïŒæã®ã¹ãã¬ããã·ãŒããšããŠä¿åãããŸãã
ãŠã§ãã¢ããªã±ãŒã·ã§ã³ãšããŠå ¬é
ãããŸã§æºåãå®äºãããããããããŠã§ãã¢ããªã±ãŒã·ã§ã³ãšããŠå ¬éããã ãã§ããå ¬éã®ä»æ¹ã¯ä»¥äžã®æé ã
䜿ãæ¹
GASBBSã¡ã€ã³ã¹ã¯ãªããã®ã¹ãã¬ããã·ãŒãã¯ã¹ã¬ããäžèŠ§ã管çããŠããŸããã¹ã¬ããåããã®ã¹ã¬ãããå ¥ã£ãŠãã¹ã¬ããã¹ãã¬ããã·ãŒãã«ãã¡ã€ã«ã®IDãªã©ãæ ŒçŽãããŠãããŸãã
æ°ããã¹ã¬ããã®äœæ
ãªã«ã¯ãšãããããŸãã¯ã¹ã¬ãããäœæããªããšæ²ç€ºæ¿ã¯ã¹ã¿ãŒãã§ããŸãããæ°èŠã¹ã¬ãããã¯ãªãã¯ããŠãã¹ã¬ãããç«ãŠãŸãã以äžã®æé ã§ã¹ã¬ãããç«ãŠãŠãã ããã
- æ°èŠã¹ã¬ãããã¯ãªãã¯åã«ã¹ã¬ãããã£ã«ã¿ã«ãŠãã¹ã¬ãããç«ãŠããå Žæã«å€æŽããŠãããŸããå šéžæã®å Žåãã¹ã¬ããã®ãžã£ã³ã«ã¯èªåçã«ãéè«ããå²ãåœãŠãããŸãã
- æ°èŠã¹ã¬ãããã¯ãªãã¯ãããšãã€ã¢ãã°ãåºãŠããŸããã³ããã³ã«ã¯åºå®ãã³ãã«åãã¹ã¬ããã¿ã€ãã«ã¯ã¹ã¬ãããã£ã«ã¿ã®ãžã£ã³ã«ã«åããããé©åœãªã¹ã¬ã®ååããããŠæ¬æãå ¥åãæ¬æã«URLãèšè¿°ãããšãèªåçã«ãã€ããŒãªã³ã¯ãèšå®ãããããã«ãªã£ãŠããŸãã
- æ°èŠäœæãã¿ã³ãã¯ãªãã¯ããã°ããåŸ ã¡ãŸãã
- ã¹ã¬ããäžèŠ§ã«ã¹ã¬ãããã£ã«ã¿ã§éžãã ãžã£ã³ã«ã§ãã¹ã¬ãäœæãããŸãããã®æããã³ãã¬ãŒããå ã«æå®ã®ãã©ã«ãå ã«ã¹ã¬ããçšã®ã¹ãã¬ããã·ãŒããäœæãããã¬ã¹ããããšããã«æžã蟌ã¿ããªãããããã«ãªããŸãããŸããGASBBSã®ç®¡çã·ãŒãã«ã¯ãã®ã·ãŒãã®IDçãè¿œèšãããŸãã
- äœæãç¡äºã«å®äºãããšããæ°èŠäœæããŸããããšããã¡ãã»ãŒãžã衚瀺ãããŠå®äºã§ãã
å³ïŒãã€ã¢ãã°ã«èšå ¥ããŠæ°èŠäœæãæŒãã ã
ã¹ã¬ãããéããŠã¬ã¹ããã
次ã«ãã¹ã¬ããäžèŠ§ããã¹ã¬ãéããŠã¿ãŸããããå ¥åãããURLã«ã¯èªåã§ãã€ããŒãªã³ã¯ãèšå®ããæ°ãŠã£ã³ããŠã§éãããã«èªåã§åŠçããããŸãããŸããã¢ã³ã«ãŒïŒ>>ããå§ãŸãæ°åïŒãå ¥åãããšããã®ã¬ã¹ã«ãžã£ã³ãããããã«ãªããŸãã
å³äžã®ãæ°ã¬ã¹ããã¯ãªãã¯ããå Žåã«ã¯ã空ã®ãã€ã¢ãã°ãéãããã¬ã¹ãäœãããšãã§ããŸããããããã®ã¬ã¹ã®å³äžã®ãã¬ã¹ãããããã¯ãªãã¯ããå Žåã«ã¯ãæ¬æãåŒçšãã圢ã§ãã€ã¢ãã°ãéãããã¬ã¹ãäœãããšãã§ããŸãã
- æ°ã¬ã¹ãã¯ãªãã¯ãã
- ãã€ã¢ãã°ãåºãããã³ããã³ãšæ¬æãå ¥åãããURLã«ã€ããŠã¯èªåã§ãã€ããŒãªã³ã¯ãèšå®ãããŸãã
- ã¬ã¹ãéä¿¡ãã¯ãªãã¯ã§ã¬ã¹ãæžã蟌ãŸããŸããã³ããã³ããªãå Žåã«ã¯ãæšæºã§åç¡ãããã«ãªããŸãã
- ã¹ã¬ããã®ã¹ãã¬ããã·ãŒãã«ãã¬ã¹ããã¡ããšæžã蟌ãŸããŸãã®ã§ãä»ã®æ¹ã¯ããŠã§ãããŒãžããªããŒãããã°ææ°ã¬ã¹ãååŸå¯èœã§ãã
- ã¡ãã¥ãŒãã¯ãªãã¯ãããšã¹ã¬ããäžèŠ§ã«æ»ããŸãã
å³ïŒã¬ã¹ãããã§åŒçšãå¯èœã§ãã
Thanksãã¿ã³
Thanksãã¿ã³ã¯ãããããæ©èœãšåãã§ãããã ãä»åã®ã¹ã¯ãªããã§ã¯ç¹ã«ã¯ãªãã¯å¶éæããŠããŸããã®ã§ãäœåã§ã誰ã§ãThanksãéãããšãã§ããŸããã¯ãªãã¯ããããšã§ãThanksãïŒå¢ããŸããã¹ãã¬ããã·ãŒãäžã§ããã®æ°ã¯ç¢ºèªã§ããã®ã§ãã ããäžçªç§°è³ãããŠããããéèšããããšãç°¡åã§ãã
瀟å SNSçãªThanksã«ãŒãã®ç°¡ææ©èœã¿ãããªãã®ã§ãã
é¢é£ãªã³ã¯
- ON/OFFã¹ã€ãããCSSã®ã¿ã§å®è£
- w2ui - JavaScript UI
- ããŒãžå ã¹ã¯ããŒã«ãã¢ã³ã«ãŒã®ããã«âidâãæå®ããã ãã§ãã
- JavaScriptã§HTMLã¿ã°ãåé€ããæ£èŠè¡šçŸ
- javascript æååããURLãæœåºãAã¿ã°ã匵ãé¢æ°ã
- jQueryãšcssã§äœããããã¿ãŒæåã§æ¢ãŸããããããžæ»ããã¿ã³ãã®å¶äœæé
- HTML, CSSã§ã®ã«ãŒããã¶ã€ã³ãµã³ãã« 4çš®
- GoogleAppsScriptã§æ²ç€ºæ¿äœã£ãŠã¿ãïŒDeprecateïŒ
- ãµãã©ã€ããªãã£ã¹ãGoogle Apps Scriptã«ããååŒå 管çã®ãµã³ãã«ããã°ã©ã ãæäŸ
- ãµãã©ã€ããªãã£ã¹ç€Ÿå Q&Aã·ã¹ãã ãµã³ãã«