Google Apps Scriptããã³ãã®HTML Serviceã§äœæããååé¡ã®è²žåºç³è«ããã³ç®¡çãããçºã®ãŠã§ãã¢ããªã±ãŒã·ã§ã³ã§ãã瀟å ã§éçšãããäžã§å¿ èŠãªæ©èœãæŠãã«ããŒããŠããŸãã
éåžžãããããã¡ãªã¹ãã¬ããã·ãŒãäžã§ã®ç®¡çããããã«ããã©ãŒã äžã§å®çµããããäœæãããŠããŸãïŒã¹ãã¬ããã·ãŒãã¯ããã°ã©ã çšã®ã»ããã£ã³ã°ãããŒã¿ç®¡çã®ã®ããã¯ã®ããã®ã·ãŒããªã®ã§ãäžæã«è§ŠããšæŽåæ§ã倱ãããã®ã§ãåºæ¬ã¯ç®¡çãã©ãŒã åŽã§ç®¡çããããã«ããŠãã ããïŒã
äžè¬ç€Ÿå¡åãã®ç³è«ãã©ãŒã ãšã管çè åŽã®ç®¡çãã©ãŒã ã®ïŒã€ãè£ åããŠããŸãããã ããçŸè¡ãã®ãã©ãŒã ã¯é¢è¥¿ãšé¢æ±ã®ïŒã€ã®é éæ ç¹ã«ã ã察å¿ããŠããã®ã§ãããã«é éæ ç¹ãå¢ããããå Žåã«ã¯ã«ã¹ã¿ãã€ãºãå¿ èŠã§ãããã以å€ã«ã€ããŠã¯ãã¹ãã¬ããã·ãŒãäžã®èšå®å€ãã»ããã¢ããããã ãã§åäœããŸãã
ç®æ¬¡
ãã®ããã°ã©ã ã®æ§æãã¡ã€ã«
ããã°ã©ã æ¬äœãšãã³ãã¬ãŒã
- åå貞åºäºçŽãã©ãŒã - ããã°ã©ã æ¬äœïŒãã©ãŒã 2åãšå ±éèšå®çšã®1åã®èš3åã®ãããžã§ã¯ãã§æ§æïŒ
- åå貞åºç³èŸŒã¿ãã³ãã¬ãŒã - å°å·çšã»PDFçæçšã®ãã³ãã¬ãŒããã¡ã€ã«ã§ããååä»ãç¯å²ãèšå®ãããŠããŸãã
- é¢æ±ãã¡ã€ã« - é¢æ±æ ç¹çšã®ããŒã¿ç®¡ççšã¹ãã¬ããã·ãŒãã§ãã
- é¢è¥¿ãã¡ã€ã« - é¢è¥¿æ ç¹çšã®ããŒã¿ç®¡ççšã¹ãã¬ããã·ãŒãã§ãã
ããã4ã€ã§æ¬ããã°ã©ã ã¯æ§æãããŠããŸããã³ããŒããŠã䜿ããã ããã
ããã°ã©ã å ã§å©çšããŠãåçš®ã©ã€ãã©ãª
- jQueryã©ã€ãã©ãªããã³jQuery UIã©ã€ãã©ãª - Google CDNãå©çš
- CSS Package for editor add-ons - äžéšã®ãã¿ã³é¡ã®ãã¶ã€ã³çšCSS
- Timeline.js - äºçŽç¶æ³ãã¹ã¯ããŒã©ãã«ãªã¬ã³ããã£ãŒã圢åŒã§è¡šç€ºããã¿ã€ã ã©ã€ã³ã©ã€ãã©ãª
- w2ui - jQueryãã©ã°ã€ã³ãšããŠåäœããdatagridã©ã€ãã©ãª
- Visualization API - Google補ã®ããŒã¿ãã°ã©ãåããçºã®é«æ©èœã©ã€ãã©ãª
ãã®ä»çŽ°ããªCSSãå€éšåŒã³åºããŠå©çšããŠããŸããåã©ã€ãã©ãªã¯ãã®ãµãŒãäžã«é 眮ããŠãããã®ãçŸåšã¯å©çšããŠããã®ã§ãæ¬çªã§å¯åãèããã®ã§ããã°ãäžèšã©ã€ãã©ãªé¡ãhttpsã®å©çšã§ããWebãµãŒãäžã«é 眮ããŠãããã°ã©ã å ã§åç §ããŠãã©ã€ãã©ãªã®URLãæžãçŽããŠäœ¿ãäºããªã¹ã¹ã¡ããŸãã
ã»ããã¢ãã
ãããžã§ã¯ãäœæ
Cloud Consoleã®èšå®
æ¬ããã°ã©ã ã¯Picker APIãå©çšããŠããçºãGoogle Cloud Consoleã«ãŠPicker APIãè¿œå ããäœæ¥ãå¿ èŠã§ãããã®ãããåå貞åºãã©ãŒã åŽãããžã§ã¯ãã«ã¯ãCloud Platformãããžã§ã¯ããšçŽä»ãäœæ¥ãå¿ èŠã§ãã以äžã®æé ã§èšå®ããŸãããã
Picker APIãè¿œå
APIãæå¹ã«ãã
åé ã§äœæãããããžã§ã¯ãå ã«ãŠãPicker APIã®è¿œå ãå¿ èŠã§ãããã®åŸã®ã»ããã¢ããã§äœ¿çšãããã¡ã€ã«ãšãã©ã«ãã®æå®ã«ãŠå©çšããããã§ãã以äžã®æé ã§API Keyãå ¥æããŸãã
èªèšŒæ å ±ãäœã
ããã°ã©ã ã®èšå®
ã©ã€ãã©ãªã®èšå®
æ¬ããã°ã©ã ã¯2ã€ã®ãã©ãŒã ã1ã€ã®èšå®å€ãå ±æãããçºã«ã3ã€ç®ã®ãããžã§ã¯ããšããŠå ±éåãããåå管çã©ã€ãã©ãªããšãããããžã§ã¯ããæã£ãŠããŸããèšå®å€ã¯ãã®3ã€ç®ã®ãããžã§ã¯ãã®ã¹ã¯ãªããããããã£ã«æžã蟌ãŸããŸãã以äžã®æé ã§ãã®ãããžã§ã¯ããã©ã€ãã©ãªåããŠãç³è«ãã©ãŒã åŽããã³ç®¡çãã©ãŒã åŽã«ã©ã€ãã©ãªãšããŠãèå¥åã¯ãsetmanãã§è¿œå ãå¿ èŠã§ãã
ã©ã€ãã©ãªåãšè¿œå ã®æé ã¯ãã¡ãã®ããŒãžãåç §ããŠãã ããã
å³ïŒ3ã€ã®ãããžã§ã¯ãã§æ§æãããŠããŸã
ãµã€ãããŒèšå®
ãµã€ãããŒèšå®ã«ã¯ããã°ã©ã ã§äœ¿çšããåçš®èšå®ãå«ãŸããŠããŸããå©çšåã«ã»ããã¢ãããããŸãããããŸããã»ããã¢ãããè¡ãªãããã«ã¯ãäžåºŠã¹ã¯ãªãããšãã£ã¿ã«å ¥ãããonOpenãå®è¡ãããŠæ¿èªäœæ¥ãæžãŸããŠããã§ãªããšã»ããã§ããªãã®ã§ãã泚æãã ããã
ã¡ãã¥ãŒãããã»ããã£ã³ã°ãâã管çèšå®ãã§å ¥ããŸãã
äž»ãªèšå®ã¯
- ãã®ãµã€ãããŒã§å©çšããPickerçšã®API Keyã»ããé ç®ïŒãããäžçªæåã«ã»ããã¢ããããŸãããïŒ
- 管çè éç¥ã¢ãã¬ã¹ïŒç³è«æã«ã¡ãŒã«ãé£ã°ãå ã®ã¡ã¢ãïŒ
- é¢æ±ãã¡ã€ã«ããã³é¢è¥¿ãã¡ã€ã«ã®æå®çšèšå®
- ååç³èŸŒã¿ãã³ãã¬ãŒãæå®
- ãã¡ã€ã«ã®ä¿åå Žæãã©ã«ãã®æå® - ãã©ã«ãå ã«æœèšãªã¹ãæ¯ã«æ°ãã«ãã©ã«ããäœãããŸã
- PDFã®ä¿åå Žæãã©ã«ãã®æå®
ãšãªã£ãŠããŸãã
ã·ãŒãäžã®èšå®
ã·ãŒãäžã§ã»ããã¢ããããäœæ¥ãšããŠã¯ä»¥äžã®ïŒç¹ã
- ããã°ã©ã æ¬äœïŒåå貞åºäºçŽãã©ãŒã ïŒã®äºçŽè ãªã¹ãã«å©çšè ã®ã¡ã¢ããšããã©ã«ãé éæ ç¹ã®èšå®
- åããããã°ã©ã æ¬äœã®èšå®ã·ãŒãã«ç»é²æ¯åºã»æœèšåãè¿œèšããŸãã
- é¢æ±ãã¡ã€ã«ããã³é¢è¥¿ãã¡ã€ã«ã®è²žåºè³æã·ãŒãã«ååé¡ã®ç»é²ãããŠãããŸããIDã¯å¿ ãé£çªã§ç»é²ããããšã
åºæ¬ååé¡ã¯ã¹ãã¬ããã·ãŒãã«è¿œèšããã ãã§ç®¡çãå¯èœã§ãã
ãŸããããªãããããŒã«ãã«ã¯ã管çæ©èœãšããŠä»¥äžã®æ©èœãåãã£ãŠããŸãã
- ããªã¬ãŒèšçœ® - èšçœ®ãããšååæžã¿ã®æ©æããŒã¿ãèªåã§éå»ãã°åŽãžããŒã¿ã移åãããŸãã
- åšåº«ãã§ãã«ãŒ - æå®ããæ©æã®çŸåšã®åšåº«ç¶æ³ã確èªãããã€ã¢ãã°ã§ãã
- ãã¡ã€ã«åºå - 幎床æŽæ°ã®ææã«ã ãå®è¡ããçŸåšãŸã§ã«å®äºããŠã貞åºããŒã¿ããã¡ã€ã«ãšããŠåãåºããŸããåãåºãåŸã¯çŸåšç¶è¡äžã®ããŒã¿ã®ã¿ãæ®ããŸãã
ãŠã§ãã¢ããªã±ãŒã·ã§ã³
æ¬ãããžã§ã¯ãã¯ããŠã§ãã¢ããªã±ãŒã·ã§ã³ãšããŠåäœããŸããå®éã«å©çšããå Žåã«ã¯ããŠã§ãã¢ããªã±ãŒã·ã§ã³ãšããŠå ¬éããäœæ¥ãå¿ èŠã«ãªããŸãã以äžã®æé ã§å ¬éããäžè¬ç€Ÿå¡åãã«ã¯ç³è«ãã©ãŒã åŽã®URLãã管çè ã¯ç®¡çãã©ãŒã åŽURLãæž¡ãããã«ããŸãããã
ã³ã¡ã³ãã¢ãŠã解é€
ä»åã®ãããã¯ãã¯ããµã³ãã«çšã«ïŒç®æã®é¢æ°ã§ã³ã¡ã³ãã¢ãŠããããŠããç®æããããŸããåå貞åºãã©ãŒã ãããžã§ã¯ãã«æŒãããindex.htmlãã®294è¡ç®ã«ãããrequeryé¢æ°ãå ã§ããããã¯äºçŽè ã·ãŒãã«ã¡ã¢ãã®ç»é²ã®ãªãè ã«ã¯å©çšã§ããªãããããã¯ãæããéšåã§ãã
çŸåšã¯ã³ã¡ã³ãã¢ãŠãããŠãããããããã¯è§£é€ã®ç¶æ ã§ããå®éçšæã«ã¯å¿ ãã³ã¡ã³ãã¢ãŠã解é€ããŸãããã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
function requery(data){ //è¿ã£ãŠããå€ãnodataã®å Žåãã®å Žã§åæ¢ã //æ¬çªæã¯ä»¥äžã®ã³ã¡ã³ãã¢ãŠãè¡ã¯ãã¹ãŠãã³ã¡ã³ãã¢ãŠãã解é€ããããš //if(data == "nodata"){ var msg = "<b><font color='red'>çŸåšã®ã¢ã«ãŠã³ãã§ã¯ç³èŸŒã¯åºæ¥ãŸãã</font></b>"; //document.getElementById("kurukuru").innerHTML = msg; //}else{ //ã»ã¬ã¯ãé
ç®ãå€æŽãã document.getElementById("area51").value = data; //æœèšåäžèŠ§ãååŸããŠããããããŠã³ã¡ãã¥ãŒãäœã google.script.run.withSuccessHandler(selmake).hospselect(); //ååäžèŠ§ãååŸããŠå€æ°ã«æ ŒçŽãã google.script.run.withSuccessHandler(blist).bihinman(data); //} } |
ãã©ãŒã ã®äœ¿ãæ¹
åå貞åºãã©ãŒã
ç³è«ãã©ãŒã ã¯äžè¬ç€Ÿå¡ã䜿ãã¡ã€ã³ã®ãã©ãŒã ã§ããçŸåšã®è²žåºç¶æ³ãã¹ã¯ããŒã©ãã«ãªã¿ã€ã ã©ã€ã³ã§éãããŸããé¢æ±ã»é¢è¥¿ã§åããæ©æã¯ç°ãªãã®ã§ãæ©æåäœã§ç³è«ãäž¡æ¹ã§ãå¯èœã§ãããŸããæ®ãã®æ©ææ°ããã¡ããšç®¡çããŠããã®ã§ãç³è«æã«æ®ã0ã®å Žåãç³è«ãã§ããŸããã
ã¿ã€ã ã©ã€ã³ã¯èµ€ãä»®äºçŽãç·ã確å®ããŠãç¶æ ã瀺ããã¯ãªãã¯ãããšè©³çŽ°ã®æ å ±ãåºãŠããŸãããŸããã¿ã€ã ã©ã€ã³ã¯åžžã«çŸåšæå»ãäžå¿ã«æ¥ãããã«ãªã£ãŠããŸããã¿ã€ã ã©ã€ã³ã§ã®æ··éå ·åã確èªããªãããç³è«ãè¡ãªãããã«ããŸãããã
äºçŽã¯å·Šäžã®ãã¬ã³ã¿ã«äºçŽããã¯ãªãã¯ããããšã§ã¹ã¯ã·ã§ã®ãããªãã€ã¢ãã°ãåºãŠããŸãã䜿ãæ¹ã¯
- æœèšãšæéå ¥åã§ãç³è«è ã®ååãé»è©±çªå·ã貞åºéå§æ¥ã»çŽå ¥åžææ¥ã貞åºçµäºæ¥ã»è¿åŽäºå®æ¥ãå ¥ããŸãããã®æã5æ¥éã®ãããã¡ãèªåã§åãããã«ããŠããã®ã§ã貞åºéå§æ¥ > çŽå ¥åžææ¥ã貞åºçµäºæ¥ > è¿åŽäºå®æ¥ãšããŠæ¥ä»ãå ¥ããå¿ èŠããããŸãïŒãã®ãããã¡ã¯ç§»åãå®éçšãŸã§ã®äºåæ¥æ°ãšããŠåã£ãŠããŸãïŒ
- ååã®ç»é²ã§ã¯éžæããé éæ ç¹æ¯ã®è²žåºæ©æäžèŠ§ãåºãŠããã®ã§ãéžæããŸãã
- ãŸããå°æ°ãšçšéãèšå ¥ããŸããè€æ°é ç®ãŸãšããŠç³è«ãå¯èœã§ãã
- æåŸã«äºçŽãéä¿¡ãã¿ã³ãã¯ãªãã¯ãããšã管çè ã«ç³è«ãéãããŸãããã®æ®µéã§ã¯ä»®äºçŽã®æ®µéã§ããç³è«è ããã³ç®¡çè ã«ã¡ãŒã«éç¥ãšPDFãã¡ã€ã«ãéä¿¡ãããŸãã
- 管çè ãæ¿èªãããšã確å®ãšãªããŸãã
1.ã®æéãçãããã®ã§ãã泚æãã ãããèªåã§äœã£ãŠãããŠããééããŸãã»ã»ã»ã»ããããä»æ§ã§èŠæãããããã«ã»ã»ã»
å³ïŒã¡ãã£ãšçããããããããã§ã
åå貞åºç®¡çãã©ãŒã
管çãã©ãŒã ã¯ç³è«ãæ¥ãå Žåãè¿åŽããããå Žåã®ïŒåã«åããŠå©çšããŸãã
- ç³è«ãæ¥ãå Žå - 察象ã®ç³è«ãéããŠç¢ºå®ãããïŒåŽäžããããéžã³ãŸããç³è«è ã«éç¥ãæ¥ãŸãã確å®ããªããšä»ã®æ¹ã®ç³è«ã«åœ±é¿ãã§ãã®ã§ãéããã«ç³è«ããŸãããïŒæ©æã®æ®æ°ã¯ãã®æç¹ã§ç¢ºä¿ãããŠãç¶æ ã§ãïŒ
- è¿åŽãããå Žå - ãã¿ããã«å¯Ÿè±¡ã®ç³è«ããååæžã¿ãã«å€æŽããŸããããååæžã¿ã«ããªããšãæ©æã®æ®æ°ã¯å埩ããŸããã
ãã®ïŒã€ã ãã§ãããŸãããµãæ©èœãšããŠãã«ã¬ã³ããŒãã£ãŒãã§ã®ç³è«ã®æ··ã¿å ·åãæ¥å¥ã¯ãã¹éèšãã©ãŒã ã䜿ããããã«ãªã£ãŠããŸãããŸããé¢è¥¿ã»é¢æ±ã®ããããå¥ããŠããã®ã§ãæ¿èªäœæ¥ã§å¿ããªãã§ãã ããã
å³ïŒç®¡çãã©ãŒã ã¯ïŒæ®µéã§å©çšããããšã«ãªããŸãã
æ¹èšå±¥æŽ
2020/01/15 - Version 2.0
-
- Google Pickerã®ä»æ§å€æŽã«å¯Ÿå¿ããŸãã