æ°ããGoogle Formãæ¥åã«æŽ»çšãã - ãã®â
G Suiteã«åœåããæèŒãããŠããã¢ããªã®ïŒã€ã«ã¢ã³ã±ãŒããæ å ±åéçšã®ã¢ããªãšããŠãGoogle FormãããããŸããMicrosoft365ã«ãMicrosoft Formsãšãããã®ããããŸãããé©ãã»ã©äœæ©èœã§ããæ°ããGoogle Formã¯æ§Google Formãããå°ãã ãé²åããŠããŠããã³ããã°ã©ãã³ã°ã§ããããšäœ¿ããããã«ãªã£ãŠããŸãã
ä»åã¯ãã®Google Formã®æŽ»çšæ³ãã®â ãšããŠãGoogle Apps Scriptãªãã§æ¢åã®Formã®æ©èœã®ã¿ã§åºæ¥ãäºããããäºãã«ã¹ã¿ãã€ãºãããŠã¿ãããšæããŸãã
ç®æ¬¡
- 1 ä»å䜿çšãããã¡ã€ã«
- 2 äºåæºå
- 3 ãã©ãŒã ãäœæãã
- 4 ãã©ãŒã é£æºãµãŒãã¹
- 5 ãã©ãŒã ã®è²Œä»ãã»éä¿¡
- 6 ãã©ãŒã ããŒã¿ã®åæ
- 7 é¢é£ãªã³ã¯
ä»å䜿çšãããã¡ã€ã«
- 飲ã¿äŒã®ã¢ã³ã±ãŒããã©ãŒã
- æ¡ä»¶åå²ã§è³ªåå 容ãå€ãããã©ãŒã Â
- ãã£ãããããçšãåãåãããã©ãŒã
Google Formã ãã¯ä»ã®ãã¡ã€ã«é¡ãšç°ãªããã¡ãã¥ãŒããã§ã¯ãªããå³äžã®ãïžããã¯ãªãã¯ããŠãããã³ããŒãäœæããäºãåºæ¥ãŸãã
äºåæºå
ãã©ãŒã ã«è³ªåãäœã蟌ãåã«ãŸããè²ã ãšèšå®ãå¿ èŠã§ãããã®èšå®ã¯ãã€ã§ãå¯èœã§ãããæåã«è¡ãããã«ããã»ããè¯ãã§ãããïŒå¿ãã¡ããã®ã§ïŒãèšå®ã¯å³äžã«ããâæ¯è»ã¢ã€ã³ã³ãã¯ãªãã¯ãããšå¯èœã«ãªããŸãã
å³ïŒãã©ãŒã ã®èšå®ã¯ãšã£ãŠãéèŠã§ã
å šè¬èšå®
ãããäžçªéèŠãªé ç®ã«ãªããŸãã
- ã¡ãŒã«ã¢ãã¬ã¹ãåé - èªåçã«ãã°ã€ã³ããŠãGoogleã¢ã«ãŠã³ãã®ã¡ãŒã«ã¢ãã¬ã¹ãååŸããŸãã誰ãåçããã®ãç¹å®ãå¯èœã«ãªããŸããå¿åã®ãŸãŸã«ãããããå Žåã«ã¯ããªãã§ãäœããªãã®å Žåãåçè ã«åçãèªåå¿çã§éãããšãåºæ¥ãŸããã
- åçã®ã³ããŒãéä¿¡ - åçå 容ãèªåçã«ã¡ãŒã«ã§åçè ã«éä¿¡ããŸãã
- åçãïŒåã«å¶é - äœåºŠããã©ãŒã ã«ã¢ã¯ã»ã¹ããŠåçã§ããªãããçºã®é ç®ã§ãã
- éä¿¡åŸã«ç·šé - éä¿¡å 容ãåŸã§ä¿®æ£åºæ¥ãããã«ããå Žåã«ã¯ããã§ãã¯ãå ¥ããŸãã
- æŠèŠã°ã©ããšããã¹ãã®åçã衚瀺 - åçåŸã«çŸæç¹ã§ã®æŠèŠã®ã°ã©ããšåçå 容ããåçè ã«ãèŠããå Žåã«ã¯ãã§ãã¯ãå ¥ããŸãã
ãã¬ãŒã³ããŒã·ã§ã³èšå®
ããã¯Formã®èŠãç®ã®èšå®ãè¡ããŸãã
- é²è¡ç¶æ³ããŒã衚瀺 - ããããçŸåšã©ãããããŸã§åçãé²ãããïŒã®é²æããŒã衚瀺ããŠãããŸãã
- 質åã®é åºã䞊ã³æ¿ãã - ããã¯é垞䜿ããŸããããã¹ããªã©ã§ã·ã£ããã«ããå Žåã«ã¯ãã§ãã¯ããŸãã
- å¥ã®åçãéä¿¡ããããã®ãªã³ã¯ã衚瀺 - åçåŸã«ããäžååçãããäºãåºæ¥ãæã«ãªã³ã¯ã衚瀺ããŠãããŸãã
- 確èªã¡ãã»ãŒãž - 質åçµäºãéä¿¡åŸã«è¡šç€ºãããã¡ãã»ãŒãžãèšè¿°ããŸãã
ãã¹ãèšå®
ãã®é ç®ã¯äžè¬äŒæ¥ã§ã¯äœ¿ãæ©äŒã¯ãªãã§ãããããªãã®ãŸãŸã§ãªãã±ãŒã§ãããã®èšå®ã¯Google Formããã¹ãã¢ããªãšããŠäœ¿ãå Žåã«äœ¿ãèšå®ã§ãç¹æ°ã®èªåéèšã§ãã£ãããæ瞟ãåçè ã«è¡šç€ºããèšå®ã§ããä»åã¯äœ¿çšããŸããã®ã§ãçç¥ããŸãã
ãã©ãŒã å ¬éæã®æ³šæç¹
ã€ãæè¿ãçºçããäºæ¡ãªã®ã§ãããå€éšã«å ¬éããŠãGoogleãã©ãŒã ãããã©ãŒã æçš¿å 容ãä»ã®ãŠãŒã¶ã«æ å ±æŒæŽ©ãããšããããšãé »ç¹ã«èµ·ããŠããŸããããäœãåå ã§èµ·ããŠãã®ãïŒãšãã£ãã
Googleãã©ãŒã ã®è¡šç€ºèšå®ã«æŒããŠãçµæã®æŠèŠã衚瀺ãããã®ãã§ãã¯ããªã³ã«ãªã£ãŠãã
ãšãããã®ã§ããããã©ã«ãã§ã¯ãªãã«ãªã£ãŠãããã®ã§ãã管çã³ã³ãœãŒã«äžã§ããã©ãŒã ã¯ç¹ã«ãã®èšå®ãå¶åŸ¡ããé ç®ããªããŠãŒã¶ãµã€ãã§ãã€ã§ããªã³ãªãåºæ¥ãŠããŸããããã¹ã€ããã²ãšã€ã§ç°¡åã«æ å ±æŒæŽ©ããŸããæçš¿ããå 容ã¯åçã«åžžã«èç©ããããŸãã¹ãã¬ããã·ãŒãã«æžã蟌ã¿ããããããã§ãããã¹ãã¬ããã·ãŒãã¯éå ¬éã§ããã©ãŒã äžãããã®æ®ã£ãŠãåçãä»è ãé²èŠ§åºæ¥ãŠããŸãã®ã§ãã
ãã£ãŠãå€éšå ¬éããå Žåã«ã¯
- çµæã®æŠèŠã衚瀺ããã®ãã§ãã¯ã¯çµ¶å¯Ÿã«ãªãã«ããŠããïŒãã©ãŒã ç·šéç»é¢ã®èšå®ã¿ãâ衚瀺èšå®âçµæã®æŠèŠã衚瀺ããã®ãã§ãã¯ããªãã«ïŒ
- ã¹ãã¬ããã·ãŒããžã®èªåæžã蟌ã¿ã¯ãªã³ã§ãè¯ãã§ãããã¹ãã¬ããã·ãŒããå€éšå ¬éã¯çµ¶å¯Ÿããªã
- ãŸããäžãäžã«åããŠã¹ãã¬ããã·ãŒããžãªã³ã¯ã¯ãªãã®ãŸãŸãGoogle Apps Scriptã«ãŠã¹ãã¬ããã·ãŒãã·ãŒãã«Forméä¿¡æããªã¬ãŒã§æžã蟌ã¿ããããåŸïŒé åã«ããŠappendRowã§è¯ãïŒããFormApp.openById("xxxxx").deleteAllResponses();ããå ¥ããŠåçå 容ãå šã¯ãªã¢ãããšãã§ã€ã«ã»ãŒãã«ãªããŸããappendRowã§æžã蟌ãŸããŠãã®ã§æä»å¶åŸ¡ã¯å¿ èŠãªãã§ãã
- å€éšå ¬éããŠã¯ãªããªãå éšåãã ãã®ãã©ãŒã ã®å Žåã¯ãïŒãã¡ã€ã³åïŒãšä¿¡é Œã§ããçµç¹ã®ãŠãŒã¶ãŒã«éå®ããã®ãã§ãã¯ããªã³ã«ããŠããå¿ èŠããããŸãããã®ç¶æ ã§ãªããã°URLãç¥ã£ãŠãã ãã§èª°ã§ãã¢ã¯ã»ã¹å¯èœã«ãªã£ãŠããŸããŸãã
管çè çã«ç¹å®ã®äººã«ã ãèš±å¯ãäžãããªãã°ãçµç¹éšéãäœæããŠç¹å®ã®ã¢ã«ãŠã³ããããã«æå±ãããŠããªã³ãªãã誰ã§ããã©ãŒã ãäœããã¿ãããªç¶æ³ã«ããªãã»ããè¯ãã§ãããããªãã°æ ã·ã¹ãç£æ»ããããã®ã§ç£æ»æžã¿ã®ãã®ã ãå ¬éãããšãã£ãå éšæé ã«ãããšå°è¯ãã®ã§ããããããã管çã³ã³ãœãŒã«ãããã®æ©èœã®ãªã³ãªããå¶åŸ¡ã§ããããGoogleãè£ åãã¹ãå 容ã ãšæããŸãã
å³ïŒãã®èšå®ããªã³ã«ããŠã¯ãªããªã
å³ïŒç¹å®ã¢ã«ãŠã³ãã ãèš±å¯ãã
å³ïŒå éšã ãå ¬éæã¯ããããªã³ã«ããŠãã
ãã©ãŒã ãäœæãã
質åããŒããäœã£ãŠãã
質åçšã®ãã¶ã€ã³ããŒãã¯å šéšã§15åãæ®éã®ããã¹ããã¿ã€ãã«çšã®é ç®ãããããããŠã³é ç®ããã§ãã¯ããã¯ã¹é¡ãåç»ã®è²Œä»ãããã¡ã€ã«ã¢ããããŒãç»é¢ãªã©çµæ§æãããå å®ããŠããŸããã»ã¯ã·ã§ã³ã¯æ¬¡ã®ãæ¡ä»¶åå²ãã§äœ¿ãç¹æ®ãªããŒãã§ãã質åããå 容ã«å¿ããŠããããã®ããŒããç¶ã足ããŠè¡ããŸãã暪ã«ã€ããŠã瞊ã®ããŒã«ããã¯ã¹ã®âãã¯ãªãã¯ããŠé 眮ããŠãããŸãã
æäžåŒãªãã©ãžãªãã¿ã³ããè€æ°éžæå¯ãªãã°ãã§ãã¯ããã¯ã¹ããäžèŠ§éžæãªãã°ãã«ããŠã³ãšãã£ãå ·åã«éžã³ãããããã®é ç®ãå å®ãããŠãããŸãããŸããæ°ããGoogle Formããã¯éžæåŒïŒã°ãªããïŒãšãããã®ãå¢ããŠããŠãæ¬äŒŒçã«ç°¡æãªè€æ°ããŒã¿ãéä¿¡åºæ¥ãããã«ãªããŸããã
ãã§ãã¯ããã¯ã¹ãã©ãžãªãã¿ã³ã§ã¯åè£ã«ãªããã®ããŠãŒã¶ã«è¿œå ãããããã®ä»ããšããé ç®ããããŸããä»ãããå Žåã«ã¯ãããè¿œå ããŠããããšå 容ãããå å®ããŸããïŒé£²ã¿äŒã®è¡ãå ã§ãããä»ãããšåæŸãã€ããªããªãå¯èœæ§ãæãïŒããŸããèšè¿°åŒããã¹ãããã¯ã¹ã§ã¯ãå ¥åå€ã®ç°¡åãªæ€èšŒãåºæ¥ãããã«ãªã£ãŠãããããŒãã®å³äžãïžãã®äžã®ãåçãæ€èšŒãããã§ãã¯ãããšäœ¿ããããã«ãªããŸããå¿ é é ç®ã«ãããå Žåã«ã¯ãå¿ é ã®ã¹ã€ãããONã«ããŸãããã
å³ïŒå¿ èŠã«ããŠååãªããŒãã¯æã£ãŠãŸãã
å³ïŒåçå 容ã®æ€èšŒãã€ããŠã¿ãïŒã¡ãŒã«ã¢ãã¬ã¹ïŒ
æ¡ä»¶åå²ãäœã£ãŠã¿ã
Google Formã¯åã®åçç¶æ³ã«å¿ããŠæ¡ä»¶åå²ã§è³ªåãäœãããšãåºæ¥ãŸããäŸãã°æ è¡ã¢ã³ã±ãŒãã§å±±ã®ãã©ã³ãšæµ·ã®ãã©ã³ã§è¡ãå ãå€ãããå Žåã«ã¯ãã®æ©èœã䜿ããŸããæ¡ä»¶åå²ã®ãã©ãŒã ã®ãµã³ãã«ãã芧äžãããããã¯å°ã äœãã®ãé£ããã§ãã以äžã®æé ã§äœã£ãŠãããŸããå®éã®ãã¢ã¯ãã¡ãããã
- ãŸãæ¡ä»¶åå²ã®å ã«ãªã質åãæ®éã«äœããæ¡ä»¶åå²ã¯ã©ãžãªãã¿ã³ã§è¡ããããåçã¯ãã¡ããå¿ é ãšããã
- ç¶ããŠãã»ã¯ã·ã§ã³ãè¿œå ãäŸãã°å±±ã®å Žåã®æ è¡è¡ãå ã®è³ªåãäœãïŒã»ã¯ã·ã§ã³ïŒãšããïŒ
- ç¶ããŠãã»ã¯ã·ã§ã³ãè¿œå ãäŸãã°æµ·ã®å Žåã®æ è¡è¡ãå ã®è³ªåãäœãïŒã»ã¯ã·ã§ã³ïŒãšããïŒ
- ãããŠæåŸã«2.ãš3.ã®ãããããå床åæµããçºã®ææã®è³ªåã»ã¯ã·ã§ã³ãäœãïŒã»ã¯ã·ã§ã³ïŒãšããïŒ
- 1.ã®åã©ãžãªãã¿ã³ã«æŒããŠãã©ãžãªãã¿ã³å³åŽã®ãã«ããŠã³ã§ãããããã»ã¯ã·ã§ã³ïŒãã»ã¯ã·ã§ã³ïŒã«ç§»åããããèšå®ããã
- 2.ããã³3.ã®ã»ã¯ã·ã§ã³ã®äžã«ãããã«ããŠã³ãããåçåŸã®ç§»åå ã»ã¯ã·ã§ã³ãïŒã«ããã
- å®éã«å±±ãéžãã å Žåãšæµ·ãéžãã å Žåãšã§ãã©ãŒã ã®è³ªåå 容ãæ¡ä»¶åå²ããŸãã
ããŸãããšäœãã°ããªãè€éãªæ¡ä»¶åå²ãããã€ãçšæããŠããã詳现ãªãã©ãŒã ãäœã蟌ãããšãå¯èœã«ãªããŸããã
å³ïŒïŒåç®ã®è³ªåã§æ¡ä»¶åå²ããã
å³ïŒåå²å 質åã®åçåŸç§»åå ã¯ã»ã¯ã·ã§ã³4ã«åæµããã
ãã¶ã€ã³ãã«ã¹ã¿ãã€ãº
æ®éã«ã«ã¹ã¿ãã€ãº
æ®éã«ã«ã¹ã¿ãã€ãºãšãã£ãŠããGoogle Formã¯æãã倧ããã«ã¹ã¿ãã€ãºãåºæ¥ãŸãããæ°ããGoogle Formã«ãªã£ãŠããã¯æŽã«ãã®ã«ã¹ã¿ãã€ãºã®äœå°ããªããªããåäœã®ãã©ãŒã ãšããŠè¡šç€ºããåã«ã¯è¯ãã®ã§ãããã¡ãŒã«éä¿¡ãå€éšè²Œä»ãæã«ã¯åšãã®ãã¶ã€ã³ãšãããããŸãããçŸåšã«ã¹ã¿ãã€ãºåºæ¥ãã®ã¯è²ãšå šäœã®ããŒãïŒäž»ã«ããããŒã®ç»åïŒãå€æŽåºæ¥ãã ãã§ãã
- ç·šéç»é¢å³äžã®ðšãã¬ããã®ã¢ã€ã³ã³ãã¯ãªãã¯
- è²ãäœçš®é¡ãåºå®ã§éžã¹ãã»ã»ã»
- å³äžã®åçã¢ã€ã³ã³ãã¯ãªãã¯ãããšããŒããéžã¹ã
- èªåã®å¥œã¿ã®ããŒããéžãã§éžæãã¿ã³ãæŒããšåæ ãäžã«ã¯ã¢ãã¡ãŒã·ã§ã³GIFãšãªã£ãŠããã®ãããã
- èªåã§ç»åãã¢ããããŒãããããå¯èœ
å³ïŒãããããªãã¶ã€ã³ã¯å€ã
éæ¹é ããŠã¿ã
ãã®éæ¹é ã¯ãHTMLãèªåã§ã¡ããã£ãšæžãã人ã§ãªããšåºæ¥ãŸããããŸããGoogle Chromeã«ä»å±ã®ããããããŒããŒã«ã䜿ããªããšäœãããã«å¿ èŠãªæ å ±ãæã«å ¥ããäºãã§ããŸããã®ã§ã泚æãå¿ èŠã§ããä»åã¯WordPressã®åºå®ããŒãžã«è²Œãä»ããŠã¿ãããšæããŸããåãé¢åèãã®ã§ãå ¥åé ç®ã¯ïŒã€ã ãã«ããŠãããŸãã
WordPressã®åºå®ããŒãžã§äœæ¥
ãŸãã¯WordPressã«ãŠåºå®ããŒãžãäžåè¿œå ãããã®äžã«Formã§èšè¿°ããŸãããã®æã質åãå¿ é ã®ãã®ãšãããå Žåã«ã¯ãinputã«requiredå±æ§ãè¿œå ããŠãããšè¯ãã§ãããã®ãããã¯çŽ°ããªHTML5ã®ã«ã¹ã¿ãã€ãºæ¹æ³ãåç §ãããšè¯ãã§ããã
1 2 3 4 5 6 7 8 9 |
<form action="ããã«éä¿¡å
æ
å ±"> <label for="text">ãåå</label> <input id="text" name="name1" required="" type="text" placeholder="ããªãã®ååãããŠãã ããã" /> <label for="email">ã¡ãŒã«ã¢ãã¬ã¹</label> <input id="email" title="ã¡ãŒã«ã¢ãã¬ã¹ã¯ãaaa@example.com ã®ãããªåœ¢åŒã§èšå
¥ããŠãã ããã" name="name2" pattern=".+@.+..+" required="" type="email" placeholder="example@mail.co.jp" /> <label for="msg">ãåãåããå
容</label> <textarea id="msg" name="name3" required="" placeholder="ãæ°è»œã«ãåãåãããã ããã"></textarea> <button name="button" type="submit" value="éä¿¡">ã¢ã³ã±ãŒããéä¿¡</button> </form> |
ãŸã ãããã«ã¯éä¿¡å æ å ±ãšåã»ã¯ã·ã§ã³ã®Nameå±æ§å€ãäžè¶³ããŠããŸãã®ã§ããããéããŸãã
Google Formã§äœæ¥
éæ¹é ã®å ã«ãªããã©ãŒã ãäœæããŸããããããããããã«WordPressã§èšè¿°ããé çªã§ããŒããäœããŸããããäœæãããããéä¿¡ãã¿ã³ãæŒããŠãçãäžã®ðãã§ãŒã³ã®ã¢ã€ã³ã³ãã¯ãªãã¯ããã®URLãæ°ããããŒãžã§éããŸããéããããChromeã®å³äžãïžãâããã®ä»ã®ããŒã«ãã®äžã®ãããããããŒããŒã«ããéããŸãã
åãéã®HTMLã³ãŒããåºãŠããã®ã§ãäžæ°ã«ããæ°ã倱ãããããããŸããããŸãã¯ãCtrl+Fã®æ€çŽ¢ã§formResponseãšããæåãå ¥ã£ãŠããã®ãæ€çŽ¢ãæ¢ãåœãŠãŸããããã¯ããèŠã€ããã¯ãã§ãããããã³ããŒããŠãããŸãã
å³ïŒãã®formResponseãšããæåã®å ¥ã£ãŠãURLãéä¿¡å æ å ±ã§ã
次ã«åããã¹ãããã¯ã¹ã®Nameå±æ§ã§ããå·ŠåŽã®ãã©ãŒã ã®ããã¹ãããã¯ã¹ã觊ã£ãŠãå³ã¯ãªãã¯âæ€èšŒãããã°ãã®å Žæã«ããé£ã¹ãŸãããã®ããã¹ãããã¯ã¹ã«ã€ããŠãNameå±æ§ãäžåãã€ååŸããŠãããŸããentry.111111ãšãã£ããããªåœ¢ã§ååãã€ããŠããã¯ãã§ãããããããã¯ã¹ã®æ°ã ãååŸããŠãããŸãã
å³ïŒnameå±æ§ã®å€ãããã§ååŸã§ããŸãã
åã³WordPressã®åºå®ããŒãžãž
æ å ±ãéãŸã£ãã®ã§ãéä¿¡å æ å ±ãšnameå±æ§å€ãWordPressåŽã«èšè¿°ããå 容ã«åæ ããŸãããŸããéä¿¡å æ å ±ã§ãããformã¿ã°ã®äžã®actionå±æ§ã«ãã®å€ãå ¥ããŠãããŸãã次ã«ãåããã¹ãããã¯ã¹ã®nameå±æ§ã«ããããååŸããentryãšåã®ã€ããå€ãå ¥ã蟌ãã§ãããŸãã
1 2 3 4 5 6 7 8 9 |
<form action="https://docs.google.com/forms/d/e/1FAIpQLSdeDZ8keuKkca393hksm6BpPAZqoLEbXVP53IPXg_h0urcThQ/formResponse"> <label for="text">ãåå</label> <input id="text" name="entry.508605068" required="" type="text" placeholder="ããªãã®ååãããŠãã ããã" /> <label for="email">ã¡ãŒã«ã¢ãã¬ã¹</label> <input id="email" title="ã¡ãŒã«ã¢ãã¬ã¹ã¯ãaaa@example.com ã®ãããªåœ¢åŒã§èšå
¥ããŠãã ããã" name="entry.1595555552" pattern=".+@.+..+" required="" type="email" placeholder="example@mail.co.jp" /> <label for="msg">ãåãåããå
容</label> <textarea id="msg" name="entry.204792544" required="" placeholder="ãæ°è»œã«ãåãåãããã ããã"></textarea> <button name="button" type="submit" value="éä¿¡">ã¢ã³ã±ãŒããéä¿¡</button> </form> |
ãŸã åé ç®ã®åŸ®åŠãªãã¶ã€ã³ä¿®æ£ã¯ããŠããŸããããããã§ããåäœããŸãããµã³ãã«ããŒãžã¯ãã¡ããrequiredå±æ§ã®ãããã§ã¡ã¢ãã®Validationããã£ã¡ãå¹ããŠããŸããéä¿¡ããããšãã¡ããšãã©ãŒã åŽã«ããŒã¿ãå ¥ãããã«ãªã£ãŠããã®ã確èªããŸããããéä¿¡ãæŒããšãGoogle Formã®ç»é¢ã«ãªãã€ã¬ã¯ãããŠçµäºããæšã®ã¡ãã»ãŒãžãåºãã°æåã§ãã
å³ïŒå¥œããªãã¶ã€ã³ã§åŒãåããŸã
Google Sitesã«åã蟌ãæã¯
Google Sitesã«äžèšã§äœæããã³ãŒããåã蟌ããšãã²ã©ããããŒãå ¥åæ¬ã«ãªããŸããWordPressãšéã£ãŠCSSããªãããã§ããããã§ãåã蟌ãã³ãŒãã«äžæéå ããŠãCSSãä»ãå ããŠãããŸããããŸããåã»ã¯ã·ã§ã³ãæ¹è¡ãããïŒè¡ã«ãªã£ãŠããŸãã®ã§ãåã»ã¯ã·ã§ã³ã®ææã«ã¯<p>ã¿ã°ãå ¥ããŠãããŸãã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 |
<style> input[type="text"],input[type="email"], textarea { padding: 0.8em; outline: none; border: 1px solid #DDD; -webkit-border-radius: 3px; -moz-border-radius: 3px; border-radius: 3px; font-size: 16px; } textarea { width: 500px; } button.button3 { /* æåãµã€ãºã1.4emã«æå® */ font-size: 1.4em; /* æåã®å€ªããboldã«æå® */ font-weight: bold; /* 瞊æ¹åã«10pxã * 暪æ¹åã«30pxã®äœçœãæå® */ padding: 10px 30px; /* æåè²ãçœè²ã«æå® */ color: #fff; /* ããŒããŒããªãã */ border-style: none; /* ãã¿ã³ã®åœ±ã®æå® * 圱ã®æšªå¹
ã2px * 瞊é·ã2px * ãŒããã3px * åºããã1px * è²ã#666ïŒã°ã¬ãŒïŒã«æå® */ box-shadow: 2px 2px 3px 1px #666; -moz-box-shadow: 2px 2px 3px 1px #666; -webkit-box-shadow: 2px 2px 3px 1px #666; /* ããã¹ãã®åœ±ã®æå® * 圱ã®æšªå¹
ã1px * 瞊é·ã1px * ãŒããã2px * è²ã#000ïŒé»ïŒã«æå® */ text-shadow: 1px 1px 2px #000; /* ã°ã©ããŒã·ã§ã³ã®æå® */ background: -moz-linear-gradient(bottom, #36d, #248 50%, #36d); background: -webkit-gradient(linear, left bottom, left top, from(#36d), color-stop(0.5, #248), to(#36d)); /* è§äžžã®æå® */ -moz-border-radius: 5px; -webkit-border-radius: 5px; border-radius: 5px; } button.button3:hover { /* éæ床ã20%ã«æå® */ opacity: 0.8; } </style> <form action="https://docs.google.com/forms/d/e/1FAIpQLSdeDZ8keuKkca393hksm6BpPAZqoLEbXVP53IPXg_h0urcThQ/formResponse"><label for="text">ãåå</label><p> <input id="text" name="entry.508605068" required="" type="text" placeholder="ããªãã®ååãããŠãã ããã" style="width:300px"/><p> <label for="email">ã¡ãŒã«ã¢ãã¬ã¹</label><p> <input id="email" title="ã¡ãŒã«ã¢ãã¬ã¹ã¯ãaaa@example.com ã®ãããªåœ¢åŒã§èšå
¥ããŠãã ããã" name="entry.1595555552" pattern=".+@.+..+" required="" type="email" placeholder="example@mail.co.jp" style="width:500px"/><p> <label for="msg">ãåãåããå
容</label><p> <textarea id="msg" name="entry.204792544" required="" placeholder="ãæ°è»œã«ãåãåãããã ããã" cols="100" rows="5"></textarea><p> <center><button name="button" class="button3" type="submit" value="éä¿¡">ã¢ã³ã±ãŒããéä¿¡</button></center></form> |
è¿œå ããé ç®ã¯
- åã»ã¯ã·ã§ã³ã®ææã«<p>ã¿ã°ãè¿œå ããŸãããããã§æ¹è¡ãããŸãã
- ButtonèŠçŽ ã«Classæå®ãå ããŠããã¿ã³ãCSSè£ é£ŸããŸããã
- inputãtextareaã®èŠçŽ ã«styleèŠçŽ ãªã©ãå ããŠå¹ ãè¿œå ããŸããã
- <style>ã»ã¯ã·ã§ã³ãè¿œå ããããã¹ãããã¯ã¹ãéä¿¡ãã¿ã³ãè£ é£ŸããŸããã
- éä¿¡ãã¿ã³ãã»ã³ã¿ãªã³ã°ããŸããã
ãŸããéä¿¡ãããšç»é¢ãGoogle Formã®ããã«é£ãã§ããã®ã§ãããçŸåšã®ããŒãžã§ã¯ãªãæ°ãããŠã£ã³ããŠã§éãããã®ãªãã°ã<base target="_blank">ãïŒè¡è¶³ããŠããããšè¯ãã§ãã
ããã§èŠæ ãã®è¯ã圢ã§ãGoogle Sitesã«ãåã蟌ããŸããããªãªãžãã«ããããã¶ã€ã³ã«ãããããŠããã°ããã§ããå°ä»åã®CSSã®è£ 食ã³ãŒãã¯ããã¡ãã®ãµã€ããããåãããŸããã
å³ïŒGoogle Sitesã«ãåã蟌ããããã©ã»ã»ã»
å³ïŒãã¶ã€ã³ãè¯ãããã«ã¯CSSã®è£ 食ãå¿ èŠ
éä¿¡åŸã«ThanksããŒãžã«ãªãã€ã¬ã¯ã
å®ã¯ãã®ãŸãŸã ãšããŠãŒã¶ããã©ãŒã ãéä¿¡åŸã«ãGoogleãã©ãŒã ã®éä¿¡ããããšããããŒãžã«ç§»åããŠããŸããéåžžã«ã¹ããŒããããããŸãããïŒãã£ããUIãGoogle Formããåãé¢ããã®ã«ïŒãããã§ãä»åã®ã³ãŒãã«éä¿¡åŸã«ç¹å®ã®ããŒãžã«ãªãã€ã¬ã¯ããã现工ãå ããŸããWordPressãªãã°äºããåºå®ããŒãžã«ãŠãThanksããŒãžããçšæããŠãããŸãããã
- äºãThanksããŒãžãäœã£ãŠããããã®URLãã³ããŒããŠãã
- ããŒãžã«è²Œãä»ããéä¿¡ã³ãŒãã以äžã®ããã«çŽ°å·¥ãã
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<form action="https://docs.google.com/forms/d/e/1FAIpQLSdeDZ8keuKkca393hksm6BpPAZqoLEbXVP53IPXg_h0urcThQ/formResponse" method="POST" id="ss-form" target="thanks" onsubmit="submitted=true"> <label for="text">ãåå</label> <input id="text" name="entry.508605068" required="" type="text" placeholder="ããªãã®ååãããŠãã ããã" /> <label for="email">ã¡ãŒã«ã¢ãã¬ã¹</label> <input id="email" title="ã¡ãŒã«ã¢ãã¬ã¹ã¯ãaaa@example.com ã®ãããªåœ¢åŒã§èšå
¥ããŠãã ããã" name="entry.1595555552" pattern=".+@.+..+" required="" type="email" placeholder="example@mail.co.jp" /> <label for="msg">ãåãåããå
容</label> <textarea id="msg" name="entry.204792544" required="" placeholder="ãæ°è»œã«ãåãåãããã ããã"></textarea> <button name="button" type="submit" value="éä¿¡">ã¢ã³ã±ãŒããéä¿¡</button> </form> <script type="text/javascript">var submitted=false;</script> <iframe style="display: none;" name="thanks" id="thanks" onload="if(submitted) {window.location='ãªãã€ã¬ã¯ãå
URL'}"></iframe> |
å ·äœçã«ã¯ã
- formã¿ã°ã«targetå±æ§ãšããŠthanksãã€ãã
- formã¿ã°ã«onsubmitãšããŠsubmittedãtrueã«ããã¢ã¯ã·ã§ã³ãã€ããŠããïŒéä¿¡ãããšå€æ°ãæžãæããïŒ
- ãã©ãŒã äžã®ã»ãã«submittedå€æ°ãçšæããŠãããåæå€ã¯false
- iframeã§ãããŒã®ãšãªã¢ãçšæããŠãããnameå±æ§ãšããŠthanksãã€ããŠãã
- iframeã®onloadã«ã¯submittedãtrueã«ãªã£ãããwindow.locationã§ãªãã€ã¬ã¯ãå ã«ç§»åããããã«ããŠãã
- ããã§ãèŠãç®ãæåãå®å šã«Google Formsã§ããäºãé èœããäºãã§ããŸããã
â»æ³šæãšããŠãWordpressã®å Žåãã®ç¶æ ã§ãããžã¥ã¢ã«ãã¢ãŒãã«ããŠããŸããšãã³ãŒããç Žå£ãããã®ã§äœæ¥ã¯ãããã¹ããã¢ãŒãã§è¡ãããã«ããŸãããã
å³ïŒç¡äºã«èªåã®ThanksããŒãžã«éä¿¡åŸãªãã€ã¬ã¯ãããŸããã
é£æé²æ¢ããã«ããŠã³å¯Ÿå¿
åœãµã€ãã§ã¯ãGoogle Workspaceã®ããã¢ãŒã·ã§ã³ã³ãŒããé åžããããŒãžãçšæããŠããŸããããã¡ãã§ãéæ¹é ãã©ãŒã ã䜿ã£ãŠããŸãããã¡ãã§ã¯ããã¿ã³ãæŒããšã¹ãã¬ããã·ãŒãäžã®åšåº«ã³ãŒããæãåºãããŠéãããä»çµã¿ã§ããããã¿ã³ãé£æããããšé£æãããåã ãã³ãŒããªã¯ãšã¹ããçºç«ããŠããŸããå°ã£ãããšã«ãªããŸãã
ããã§ããªã¯ãšã¹ããã¿ã³ãæŒããšiframeã®é ç®ã衚瀺ããããšå ±ã«ã
- onLoadã€ãã³ãã§ããŒãã£ã³ã°ãµãŒã¯ã«ã衚瀺
- sendrequestã®ãªã¯ãšã¹ããã¿ã³ãé衚瀺ã«ãã
- ãã©ãŒã éä¿¡å®äºããããªã¯ãšã¹ãå®äºããŒãžã«ãªãã€ã¬ã¯ã
ãšããåŠçãå ¥ããŠããŸãããŸããã©ã³ããã«ããŠã³ã§æ§ç¯ãããã¡ããGoogle Formã®entry IDãå ã«éãã€ããŠããŸããããã§é£æãé²æ¢ã§ãã確å®ã«ãªã¯ãšã¹ããéãããšãå¯èœã§ãã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<script type="text/javascript" src="https://code.jquery.com/jquery-2.1.4.min.js"></script> <script type="text/javascript">var submitted=false;</script> <form action="https://docs.google.com/forms/u/0/d/e/hogehoge/formResponse" method="POST" id="ss-form" target="thanks" onsubmit="submitted=true"> <label for="text">ãåå</label> <input id="text" name="entry.xxxxxxx" required="" type="text" placeholder="ããªãã®ååãããŠãã ããã" /> <label for="email">ã¡ãŒã«ã¢ãã¬ã¹</label> <input id="email" title="ã¡ãŒã«ã¢ãã¬ã¹ã¯ãaaa@example.com ã®ãããªåœ¢åŒã§èšå
¥ããŠãã ããã" name="entry.xxxxxxx" pattern=".+@.+..+" required="" type="email" placeholder="example@mail.co.jp" /> <label for="msg">ãšãã£ã·ã§ã³ãéžæ</label> <select id="titleman" class="inputman" name="entry.xxxxxxx" required=""> <option value="Google Workspace Business Starter">Google Workspace Business Starter</option> <option value="Google Workspace Business Standard">Google Workspace Business Standard</option> </select> <br> <center> <input id="sendrequest" name="button" type="submit" value="ãªã¯ãšã¹ã" /> </center> </form> <p id="circle" style="display: none;"><img src="https://officeforest.org/wp/library/loading.gif" width="128" height="128" /></p> <iframe style="display: none;" name="thanks" id="thanks" onload="if(submitted) { document.getElementById('circle').style.display = 'block'; document.getElementById('sendrequest').style.display = 'none'; window.location='転éå
ã¢ãã¬ã¹' }"></iframe> |
ã¢ããªã³ã«ã€ããŠ
æ°ããGoogle Formã«æèŒãããã¢ããªã³æ©èœãããã¯Google Apps Scriptã§äœæãããŠãè¿œå ã¢ãžã¥ãŒã«ã§ããäž»ã«è£œäœè ã«ãšã£ãŠãã©ã¹ã«ãªããããªè¿œå æ©èœãã¢ããªã³ã®åœ¢ã§èª°ã§ã䜿ããããã«ãããã®ã§ãããã ãæ®ã©ãè±èªè¡šèšã§ãããæ£çŽãªæãããŸã§å¿ èŠããªããšæããããªã¢ããªã³ãå°æ°ãªãªãŒã¹ãããŠããã ããªã®ã§ã䜿ãã䜿ããªããïŒã¯å€æãå¥ããæã§ãã
ä»åã®ãšã³ããªãŒã¯Google Apps Scriptã䜿ããªãã§ã®ã«ã¹ã¿ãã€ãºãªã®ã§ãè±èªè¡šèšã§ã倧äžå€«ãšãã人ã«ãšã£ãŠã¯æçšãªãã®ãããããŸãããèªåå¿çã¡ãŒã«ãéã£ãããã«ã¬ã³ããŒãšé£æºããããQRã³ãŒããçæããããã¯ãŒã¯ãããŒã·ã¹ãã çãªãã®ã«ä»äžããããªã©ãç²ããããªã¢ããªã³ã§ã¯ãããŸãã
䜿ãæ¹ã¯å³äžã®ãïžããã¯ãªãã¯ããŠãã¢ããªã³ããéžæãæ°ã«å ¥ã£ãã¢ããªã³ãããã°ã¯ãªãã¯ããŠãå³äžã®ç¡æãšæžããããã©ã¹ãã¿ã³ãã¯ãªãã¯ããã°ããã©ãŒã ã«æ©èœãè¿œå ãããŸãã
å³ïŒãã³ããã°ã©ãã³ã°ãªãã°æçšã§ãã
ãã©ãŒã é£æºãµãŒãã¹
ã«ãŠã³ãããŠã³ã¿ã€ããŒ
ã¢ããªã³ãè¿œå ããäºã§ãè©Šéšãã¯ã€ãºã®ãã©ãŒã ã«å¯ŸããŠã«ãŠã³ãããŠã³ã¿ã€ããŒãèšçœ®ããäºãå¯èœã§ããã«ãŠã³ãããŠã³ãçµäºãããšåŒ·å¶çã«çµäºãããã©ãŒã ã®éä¿¡ãè¡ãããä»çµã¿ã§ãïŒããã¯ãåçã®æéå¶éãã€ãããã®ã§ãæåºæéã§ãããã©ãŒã ã®é瀺æéãèšå®ããŠéãããã®ãšã¯å¥ç©ã§ãïŒã
çŸåšå ¬éãããŠãã¢ããªã³ãšããŠã¯ä»¥äžã®ãããªãã®ããããŸã
è©Šãã«ãExtended Formsã䜿ã£ãŠã¿ãŸããå°å ¥æé ã¯ä»¥äžã®éã
- Exntended Formsã®ããŒãžãéããŠãåå¥ã€ã³ã¹ããŒã«ãã¯ãªãã¯
- æš©éãªã¯ãšã¹ããæ¥ãã®ã§ããèš±å¯ããã¯ãªãã¯ãã
- 次ã®ç»é¢ã§ã¯è¿œå ã®èšå®ãã¯ãªãã¯ãã次ã®ç»é¢ã§ã¯åãã¢ã«ãŠã³ãã§ãã°ã€ã³ãã
- æ¢åã®ãã©ãŒã ãéããšãäžã®ã¡ãã¥ãŒã«ããºã«ã¢ã€ã³ã³ãåºãã®ã§ã¯ãªãã¯ãã
- Extended Formsãšããã¡ãã¥ãŒãåºãã®ã§ã¯ãªãã¯ãã
- Configureãšããé ç®ãã¯ãªãã¯ãã
- å³äžã«ãµã€ãããŒãåºãã®ã§ãConnect to Extendedforms.ioãšåºãã®ã§ã¹ã€ããããªã³ã«ãã
- èµ€ãèŠåãåºãã®ã§ãFixãã¯ãªãã¯ãã
- Share formããã©ãŒã ã®å ±ææ¹æ³ãOrg Email Requiredã§çµç¹å ã®ã¿å ±æã«ãªããŸãã
- Time Limitãå¶éæéãä»åã¯3ãå ¥ããŠ3åãšããŸããã
- Restrict Attemptsã¯è©Šè¡å¶éåæ°ã1åã®ã¿ãšããŸããã
- Auto Submit after timer endsããªã³ã§ãå¶éæéåŸã«èªåçã«éä¿¡ãšãªããŸãã
- Saveã§ä¿åãšãªããŸãã
ããã§ãå°å ¥ã¯å®äºããŸãããããã泚æç¹ãããã€ãããã®ãµãŒãã¹ã¯å€éšãµãŒãã¹ãšã®é£æºã«ãããã®ã§ãä»åã®ã«ãŠã³ãããŠã³ã®ç®¡çãªã©ã¯ããµãŒãã¹ã®ããã·ã¥ããŒãã§ç¢ºèªåºæ¥ãŸããå¿ ããã©ãŒã ãšåãã¢ã«ãŠã³ãã§ãã°ã€ã³ããŠããªããšãForm not foundã§é£æºãåºæ¥ãªããªããŸããè€æ°ã¢ã«ãŠã³ãã§ãã°ã€ã³ããŠãããšå ·åãæªãã®ã§ãGoogleã¢ã«ãŠã³ãã¯1åã ããã°ã€ã³ããŠããããã«ããŸãããã
ãã©ãŒã ã®ã«ãŠã³ãããŠã³ãå®äºãããšèªåçã«ãã©ãŒã ã¯éä¿¡ãããŠãYour response has been recorded.ãšåºãããã«ãªããŸãã
ãŸããæ¢åã®ãã©ãŒã ã«ExtendedForms Id (skip this field)ãšããé ç®ãåºãŸããããã¯åé€ããŠã¯ãªããŸããããå€æŽãããŠã¯ãããŸãããå®éã®ãã©ãŒã ã«ã¯ããã¯è¡šç€ºãããããã®é ç®ãæã£ãŠããŠé£æºãããŠããããã§ãã
ãŸãããã©ãŒã ã®URLãGoogle Formã®ãªã³ã¯ã§ã¯ãªããç¬èªã®ãã®ãšãªããShare Form暪ã®å ±æã¢ã€ã³ã³ãã¯ãªãã¯âForm Link Copiedãšãªã£ãããã¡ãŒã«ããŠã§ãã«ãã®ãªã³ã¯ã貌ãããšã§æ©èœããŸããéåžžã®Google Formã®ãªã³ã¯ã§ã¯ã¿ã€ããŒã¯äœåããŸããã
ãã¹ãã§ã€ãã£ãŠã¿ãã¿ã€ããŒãã©ãŒã ã¯ãã¡ãã«ãããŸãã
å³ïŒã¿ã€ããŒã®ã»ããã£ã³ã°
å³ïŒã¿ã€ããŒä»ãã§äœåãã
å³ïŒå€éšã®ç®¡çç»é¢
ãã£ããããããäœã
äœæããGoogle Formã§ããããã®ãŸãŸã§ããã©ãŒã ãšããŠäœ¿ããŸããããã£ãããããåãããšã€ã³ã¿ã©ã¯ãã£ããªæãã§ãã©ãŒã å ¥åãåºæ¥ãããã«ãªããŸãããã£ãããããã«ããããã«ã¯ãFobi.ioãšãããµãŒãã¹ãå©çšããŸãããã®ãµãŒãã¹ã¯Google Formã«å¯Ÿå¿ããŠããããŸã質åå 容ã®ããŒããã»ãŒå¯Ÿå¿ããŠãåªããã®ã§ãã
äœãæ¹ã¯ä»¥äžã®æé
- Google Formã®å³äžã®éä¿¡ãã¯ãªãã¯ãã
- ðéã®ããŒã¯ãã¯ãªãã¯ããŠããªã³ã¯ãååŸãã
- Fobi.ioã®ãµã€ãã«è¡ããäžéšã®ããã¹ãããã¯ã¹ã®Past from Linkã«2.ã®ãªã³ã¯ãã³ããããŠãCreate Botããã¯ãªãã¯
- 次ã®ç»é¢ã®äžçªäžã®ãSave Botããã¯ãªãã¯ãããå°ãã®ç»é¢ã§ããã©ãŒã å 容ãã¡ãã£ãšä¿®æ£ã§ãã
- ãã£ãããããçšã®ãªã³ã¯ãåºãŠæ¥ãã®ã§ããããGoogle SitesãWordPressã«iframeã§åã蟌ãã
- iframeã®ã³ãŒãã®src=以äžã®éšåã®URLãèªåãäœã£ããããã®URLã«çœ®ãæããŠãã
åã蟌ãiframeã®HTMLã³ãŒãã¯ä»¥äžã®ãããªæã
1 |
<iframe width="100%" height="700" src="https://fobi.io/#/f/JIur2O1" frameborder="0" marginheight="0" marginwidth="0"></iframe> |
å®éã«WordPressãšGoogle Sitesã«åã蟌ãã§ã¿ãããã£ããã«çããŠéä¿¡ãããšãã¡ããšãã©ãŒã ã«ã¯ããŒã¿ãèšé²ãããŠãããåã䟿å©ã§ããããããªãã°Google Sitesã«åã蟌ãã§ããã¶ã€ã³çã«ãã°ããã
å³ïŒFormã®ãªã³ã¯ããŸãã¯ã³ãã
å³ïŒSAVE BOTã§äœæå®äº
å³ïŒãªã³ã¯ãåºãŠæ¥ãã®ã§ããã貌ãä»ãã
å³ïŒãã£ããããããšäŒè©±ãã
ã¿ã¹ã¯ã©ã³ããŒãµãŒãã¹ã䜿ã
IFTTTãMicrosoft FlowãZapierãªã©ã®ãŠã§ããµãŒãã¹ãé£æºãããã¿ã¹ã¯ã©ã³ããŒãµãŒãã¹ãå©çšããäºãã§ããŸãããã ããããäžé·äžçããããçŸåšGoogle Formãšé£æºåºæ¥ãã®ã¯Zapierã®ã¿ã§ããããããIFTTTã¯ã¹ãã¬ããã·ãŒããšé£æºãå¯èœãªã®ã§ä»£çšå¯èœã§ãã
IFTTTãå©çšãã
IFTTTã®å Žåã«ã¯ãGoogle Formããã¹ãã¬ããã·ãŒããžæžã蟌ã¿ããããããLINE Notifyãžéç¥ããã¬ã·ããäœã£ãŠã¿ãããšæããŸããIFTTTã¯LINEã«å¯Ÿå¿ããŠãã®ã§ç°¡åã«äœæå¯èœã§ããäºåã«éä¿¡å ã®LINEã°ã«ãŒããäœã£ãŠãããLINE Notifyãã°ã«ãŒãã«åå ãããŠãããŠãã ããã
以äžã®æé ã§äœæå¯èœã§ãã
- IFTTTã«ãã°ã€ã³ããå³äžã®äººã®ã¢ã€ã³ã³ãã¯ãªãã¯âcreateãå®è¡
- if + then thatã®ïŒèšå·ãã¯ãªãã¯ãã
- choose a serviceã§ãGoogle Sheetsãéžæãã
- New Row added to Spreadsheetãã¯ãªãã¯ããŸãã
- Enter the folder pathã¯é©åœã«ãRecipesããšã§ãå ¥åãã
- copy and paste spreadsheet URLã«Google Formãæžã蟌ãã¹ãã¬ããã·ãŒãã®URLãã³ãã
- Create Triggerãã¯ãªãã¯ãèªèšŒãèŠæ±ãããã®ã§ãæ¿èªããã
- ç¶ããŠãif + then + thatã®å³åŽã®ïŒèšå·ãã¯ãªãã¯ãã
- choose action serviceã§LINEãéžæãã
- send messageãéžæãã
- Recipientã§ãéä¿¡å LINEã°ã«ãŒããéžæããã
- Messageã«ã¯ã©ã®ãããªã¡ãã»ãŒãžãéãããçµã¿ç«ãŠãããŸãããã®ãŸãŸLINEã«éãããŸãã
- Create Actionãã¯ãªãã¯ãã
- Finishãã¯ãªãã¯ããŠå®äºã
- å®éã«Google Formããéããšãã¹ãã¬ããã·ãŒãã«æžã蟌ãŸããIFTTTãåããLINEã«éãããŸãã
å³ïŒãããªæãã§LINEã«éãããŠãã
Zapierãå©çšãã
ä»åã¯ãGoogle Formã§æ°ãããšã³ããªãŒãè¿œå ãããããLINE Notifyãžéç¥ããã¬ã·ããäœã£ãŠã¿ãããšæããŸããGoogle Apps Scriptã§ã®éç¥ã¯æ¬¡åã
äºåæºå
ãŸãã¯ã以äžã®æé ã§æºåãé²ããŸãã
- ãããããLINEã«ãŠããŒã¯ã°ã«ãŒããäœã£ãŠããããã®æãLine Notifyãã°ã«ãŒãã«è¿œå ããŠããã
- Line Notifyã«ãã°ã€ã³ããŠãããŒã¯ã³ãçºè¡ããŠããããããŒã¯ã³åãé©åœã«å ¥ããããŒã¯ã°ã«ãŒãåãéžæ
ãã®æãã¡ããšåããã©ããã¯ãOSXãªãã°ã¿ãŒããã«ãã以äžã®ã³ãã³ããæããã°Status:200ãšåºãŸãããããæåã§ãã401ã404ã¯ãšã©ãŒã§ããã
1 |
curl -X POST -H 'Authorization: Bearer ããã«ããŒã¯ã³ãããã' -F "message=ãŠããš" https://notify-api.line.me/api/notify |
å³ïŒèµ€åã§ããŒã¯ã³æååãåºãŠããŸãã
å³ïŒterminalãããã¹ãããŠã¿ã
Zapierã§ã¬ã·ãäœæ
zapierã«ãã°ã€ã³ããŠãããããã¬ã·ããäœããŸããäœãZapierã¯GoogleãµãŒãã¹ã«å¯ŸããŠ5åããã«ãã§ãã¯ãããŠãã®ã§ãå±ããŸã§è¥å¹²ã¿ã€ã ã©ã°ããããŸããGoogleããã®ã¡ãŒã«éç¥ã®ã»ããæ©ãæ¥ããããããŸããããªã®ã§ããããäºãåºæ¥ããã£ãŠããåèçšåºŠã«ã¿ãŠäžããã
- Zapierã®Dashboardãéããäžéšã«ãããMake a Zap!ããã¯ãªãã¯
- ãŸãã¯ãGoogle FormãããChoose Triggerã§Google Formãéžæãã次ãžé²ãã
- New Response in Google Spreadsheetãéžã¶ã
- æ¥ç¶ããGoogleã¢ã«ãŠã³ããå ¥ãããèªåã®ã¢ã«ãŠã³ãã§ããã
- Spreadsheetã¯Google Formãæžã蟌ãã§ãã¹ãã¬ããã·ãŒããéžæããWorksheetã¯ã·ãŒãåãåºãŠæ¥ãã¯ããªã®ã§ãããéžæã
- Fetch&Continueãã¯ãªãã¯ããŠæ¥ç¶æåããã°å®äºã
- 次ã®Actionã§ã¯LINEã¯äžèŠ§ã«ãªãã®ã§ãWebhooks by Zapierãéžã¶ã
- POSTãéžæããŠæ¬¡ã«ããã
- URLã«ã¯ãhttps://notify-api.line.me/api/notifyãå ¥å
- dataã«ã¯messageãšå ¥ããé£ã®ããã¯ã¹ã«ã¯é©åœã«ã¡ãã»ãŒãžãå ¥ããŠããã
- headersã«ã¯Authorizationãšå ¥åããé£ã®ããã¯ã¹ã«ã¯Bearer ããŒã¯ã³åããšå ¥ãããBearerã®åŸã«åè§ã¹ããŒã¹ãããã®ã«æ³šæã
- Send test webhook...ãã¯ãªãã¯ããŠãLINEã«å±ãã°OKã§ãã
- Finishãã¿ã³ãæŒããŠããã®ã¬ã·ãã«ååãä»ããŸãã
- Your Zap isã®ã¹ã€ããããªã³ã«ããŸãããªã³ã«ããªããšããªã¬ãŒãåããŸããã
- ãã®ã¬ã·ããæšãŠãæã¯ã¹ã€ããããªãã«ããªããšãŽãç®±ã«å ¥ããããŸããã
å³ïŒGoogle Formã®èšå®
å³ïŒWebhookã®èšå®ãã®ïŒ
å³ïŒWebhookã®èšå®ãã®ïŒ
å³ïŒã¹ã€ããã¯ONãå¿ããã«
ãã©ãŒã ã®è²Œä»ãã»éä¿¡
ã¡ãŒã«ã§éä¿¡ãã
ãã®Googleãã©ãŒã ã䟿å©ãªã®ã¯çžæãGMailã§ããã°GMailå ã§åçãè¡ãããã¡ãŒã«ãéãäºãã§ããç¹ã§ãããã¡ãã¡ãã©ãŒã ã®é²èŠ§ç»é¢ã«è¡ãå¿ èŠãç¡ãã®ã§ãããå€ãã®åçãæåŸ åºæ¥ãŸããG Suiteãªã©ã§çµç¹å ã§ã®ã¢ã³ã±ãŒããªã©ã«äœ¿ãå Žåã«ã¯æé©ãªæ¹æ³ã§ããéä¿¡å ã¯åå¥ã¡ãŒã«ã¢ãã¬ã¹ããã°ã«ãŒãã®ã¢ãã¬ã¹ãäž¡æ¹äœ¿çšããäºãå¯èœã§ãã
ã¡ãŒã«ã§éä¿¡ããæé ã¯ä»¥äžã®éãã
- ç·šéç»é¢ã«æŒããŠãå³äžã®ãéä¿¡ããã¿ã³ãæŒã
- ã¡ãŒã«ãéžæããéä¿¡å ãå ¥åããŸããã«ã³ãåºåãã§è€æ°éä¿¡å ãéžã¹ãŸãã
- 件åãæ¬æã¡ãã»ãŒãžãå ¥åãã
- æåŸã«ããã®ãã©ãŒã ãã¡ãŒã«ã«å«ãããã«ãã§ãã¯ãå ¥ãã
- ã¡ãŒã«ã¢ãã¬ã¹ãåéãããªãã·ã§ã³ã¯å¿ èŠã«å¿ããŠãã§ãã¯ãå ¥ããã
- éä¿¡ãã¿ã³ãæŒããšå®äº
ãããšãåä¿¡è ã«ã¯ä»¥äžã®ãããªGMailå ã§åçãåºæ¥ãã¡ãŒã«ãå±ããŸããäœããã®ãã©ãŒã ã¡ãŒã«ãã¹ããã©ã ãšåããŸããã®ã§æ³šæïŒ
å³ïŒPCçã§ã¯ãã®ãŸãŸGMailäžã§åçãåºæ¥ãŸã
Google Sitesã«è²Œãä»ãã
äžçªå€ãå©çšæ¹æ³ãªã®ã¯åºå®çã«ãã©ãŒã ãGoogle Sitesã«è²Œãä»ããŠããŠãŒã¶ã«ä»»ããŠåçããŠãããæ¹æ³ã§ããGoogle Sitesã®ç·šéç»é¢ã«ãŠè²Œãä»ãããããŒãžäžã§æ®éå³ãµã€ãããŒããããã©ãŒã ããéžãã§ã貌ãä»ããããã©ãŒã ãã¯ãªãã¯ããã ããããšã¯çžŠæšªã®ãµã€ãºã調æŽããã°å®äºã§ãã
å®éã«è²Œãä»ããŠã¿ããµã³ãã«ããŒãžã¯ãã¡ããããªããå ¬éãã¿ã³ãæŒããŠããçæ§ã«ãç¥ããããŸãããã
å³ïŒãã ãã®ãŸãŸã ãšãã¶ã€ã³ãããŸãã¡ã§ããã»ã»
å€éšãµã€ãã«è²Œãä»ãã
å€éšãµã€ãïŒäŸãã°èªåã®WordPressã®ããã°ãªã©ïŒã«ã貌ãä»ããäºãå¯èœã§ãããšãã£ãŠãiframeã§ãã©ãŒã ã衚瀺ããŠããã ãã§ããããã®æãGoogle Formã ãã¯èªåã®ãã¡ã€ã³å€ã®äººã«ãåçåºæ¥ãããã«å ¬éããäºãåºæ¥ãããã«ãªã£ãŠããŸãããã®å Žåã®å€éšã®åçè ã¯åœç¶ã¹ãã¬ããã·ãŒãã«ã¯ããããŸããã
貌ãä»ãæ¹ã§ãã以äžã®æé ã§ãã
- ç·šéç»é¢ã®å³äžã®éä¿¡ãã¿ã³ãæŒã
- ãïŒïŒããšããã¿ããã¯ãªãã¯ããŠãHTMLãåã蟌ãã衚瀺ãã
- 衚瀺ãããŠãã³ãŒããã³ããŒãããã³ããŒåã«ãµã€ãºèª¿æŽå¿ããã«ã
- WordPressã®ç·šéç»é¢ã«ãŠãããã¹ãã¢ãŒãã§è¡šç€ºããŠã³ãŒãã貌ãä»ããã
- è©Šãã«ã€ãã£ãŠã¿ãã
ãã¶ã€ã³ãããŸãã¡ã§ãµã€ããšå šããã£ããããŠããŸãããã貌ãä»ããããŸããéæ¹é ããŠèªãµã€ãã«åã圢ã§ã«ã¹ã¿ãã€ãºããŠè²Œãä»ããã»ããè¯ããããããŸããã
åæå€ãã»ããããç¶æ ã§è²Œãä»ãã
æ°ããGoogle Formã§ã¯åæå€ãã»ããããç¶æ ã§ãã©ãŒã ã貌ãä»ããæ©èœãè¿œå ãããŠããŸããäœãããã®åæå€ã¯åçã«å€æŽããäºãåºæ¥ãŸããããŸããåæå€ã¯URLã«å«ãã圢ã§çæãããŸããäœãæ¹ã¯ä»¥äžã®éãã
- ãã©ãŒã ãäœãäžããããå³äžã®ãïžããã¯ãªãã¯ãããäºåå ¥åããURLãååŸããã¯ãªãã¯
- ãã©ãŒã ãé²èŠ§ã¢ãŒãã§éãããã®ã§ããã©ãŒã ã®é ç®ãå ¥ããããããåæå€ã«ãªãã
- ããªã³ã¯ãååŸãã¿ã³ããã¯ãªãã¯ããã
- ãã®æãåæå€å«ãã貌ä»ãçšãã©ãŒã ã®URLãã³ããŒãããŠããŸãã
- Google Sitesã®å Žåãå³ãµã€ãããŒã®ãã©ãŒã ã§ã¯ãªããåã蟌ã¿ã䜿ã£ãŠURLã貌ãä»ããŠåã蟌ãã
- WordPressã®ãããªå Žåã¯ãiframeã䜿ã£ãŠåã蟌ã¿çšURLãã»ããããŠãããã
ãã®URLã解æããã°ãéãæã«å¥ã®ã¢ããªããåæå€å ¥ãã®URLãã»ããããŠéãããã°ããŠãŒã¶åãã¡ãŒã«ã¢ãã¬ã¹ãåçã«å ¥ããããšãåºæ¥ãŸãã
å³ïŒãªã³ã¯ãååŸã®URLã¯åæãããšé¢çœã
ãã©ãŒã ããŒã¿ã®åæ
ã¹ãã¬ããã·ãŒãã«æžã蟌ã
åçãããã¢ã³ã±ãŒããèªåçã«ã¹ãã¬ããã·ãŒãã«èç©ãããäºãã§ããŸããã¹ãã¬ããã·ãŒãã¯äºæ¬¡å©çšãå¯èœãªã®ã§ãéåžžã¯ãã®ãªãã·ã§ã³ãçãã䜿ãããšã«ãªããšæããŸãã䜿ãæ¹ã¯
- ç·šéç»é¢ã«ãŠãåçãã¿ããã¯ãªãã¯ãã
- åçã¿ãã®å³æ¹åã«ãããïžããã¯ãªãã¯ãã
- åçå ãéžæãã¯ãªãã¯
- æ°ããã¹ãã¬ããã·ãŒããäœæãªãã°ãååãä»ããŠãã©ãŒã ãšåãå Žæã«èªåçæãããŸããïŒäœæäºäŸïŒ
- æ¢åã®ã¹ãã¬ããã·ãŒãã®å Žåãæå®ããäºã§ãã®ã¹ãã¬ããã·ãŒãã«æ°èŠã·ãŒããäœæãããŠé£çµãããŸãã
- äœæãšé£çµãããã¹ãã¬ããã·ãŒãã¯ãåçã¿ãã®å³ã«ããç·è²ã®ã¢ã€ã³ã³ãã¯ãªãã¯ãããšããé²èŠ§ã§ããŸãã
åããªãã·ã§ã³ã«ãŠããæ°ããåçã«ã€ããŠã¡ãŒã«ã®éç¥ãåããããã¯ãªãã¯ããŠãã§ãã¯ãããšãåçããããã³ã«äœæè ã«ã¯ã¡ãŒã«ã§éç¥ãæ¥ãããã«ãªããŸããåçãããŠã³ããŒããã¯ãªãã¯ãããšãçŸæç¹ã§ã®åçå 容ãCSVãã¡ã€ã«ïŒZIPã§å§çž®ãããŠããŸãïŒã§å ¥æããããšãåºæ¥ãããã«ãªããŸãã
â»äžã€åé¡ãã»ã»ã»æ°å€ã®å Žåé ãã0ãã®ãããªãã®ïŒäŸïŒé»è©±çªå·ãªã©ïŒã¯ãæžã蟌ã¿ããæã«ããã®é ã®0ãæ¶ããŸãã»ã»ã»æ ã«èªåã¯ã¹ã¯ãªããã§æžã蟌ãããã«ããŠããããŸãã
â»äœããã®CSVãæåã³ãŒããBOMç¡ãUTF-8ã«ãªã£ãŠãããExcel2013ã§èªã¿èŸŒãŸããæãæååãããŠãŸããShift-JISãšèª€èªèãããçºãäžåºŠä»¥äžã®äœæ¥ãããŸãã
- ã¡ã¢åž³ïŒnotepadïŒãèµ·åãã
- 察象ã®CSVãã¡ã€ã«ãèªã¿èŸŒãŸããŠããã®ãŸãŸäžæžãä¿åãã
- ã¡ã¢åž³ãéããŠãã®ãŸãŸãcsvãã¡ã€ã«ãExcelã«èªã¿èŸŒãŸãã
- æååãããéããïŒBOMæãUTF-8ãšãªãïŒ
ç°¡åãªäœæ¥ã§ãã
å³ïŒã¹ãã¬ããã·ãŒãé£æºãçŸå³ãããã€ã³ã
å³ïŒãã®ãŸãŸã ãšæååãããCSVããŒã¿ðš
ã¢ã³ã±ãŒãç¶æ³ã確èªãã
åçãããã¢ã³ã±ãŒãã¯ããã©ãŒã èªäœã«ãèç©ãããŠããŸãããã®å 容ã¯ã°ã©ãåãããŠãããã²ãšç®ã§ã¢ã³ã±ãŒãç¶æ³ã確èªã§ããããã«ãªã£ãŠããŸããèŠãããã«ã¯ç·šéç»é¢ã«ãŠä»¥äžã®äœæ¥ãè¡ããŸãã
- ç·šéç»é¢ãéããããåçãã¿ããã¯ãªãã¯ãã
- æŠèŠã¯å šãŠã®éèšçµæããŸãšããããŒã¿ã«ãªããŸãã
- åå¥ã¯ç³è«è å人ããšã®ããŒã¿ãæ ŒçŽãããŠããŸããã¡ãŒã«ã¢ãã¬ã¹åéãããŠãå Žåã誰ãã©ãçããã®ããããããŸãã
å³ïŒéèšãã°ã©ãã§äžç®çç¶
é¢é£ãªã³ã¯
- Googleãã©ãŒã ã§submitåŸã«ãµã³ã¯ã¹ããŒãžã«é·ç§»ãããã
- Add Timer in Google Form Quiz
- Yahooç¥æµè¢
- Googleformåã蟌ã¿ã§åçå®äºç»é¢ã«é·ç§»ãããªãæ¹æ³
- Google ãã©ãŒã éä¿¡åŸã« redirect ããããµã³ãã«ã³ãŒã
- Googleãã©ãŒã åã蟌ã¿ã§ãã§ãã¯ããã¯ã¹è€æ°éžæããããŒã¿ãéä¿¡ããæ¹æ³
- Googleformåã蟌ã¿ã§ã©ãžãªãã¿ã³ã®ããŒã¿ãéä¿¡ããæ¹æ³
- ããã¶ã€ã³ãGoogle Formãã«ã¹ã¿ãã€ãºããŠã¿ããGoogle Formã
- åºæ¬ 管çã¯Googleãã©ãŒã +QRã³ãŒãã絶察䟿å©ïŒ
- Googleãã©ãŒã ã§ããŒã³ãŒããQRã³ãŒããçºå¹ããã·ã¹ãã ãçµãã§ã¿ã
- Google Formãäºåå ¥åãããç¶æ ã§ãªã³ã¯ãæž¡ã
- Googleãã©ãŒã ã®URLããQRã³ãŒããäœæããæ¹æ³ïŒ
- ãã©ãŒã äœæããŒã«formrunïŒãã©ãŒã ã©ã³ïŒã£ãŠïŒGoogleãã©ãŒã ãšã®éãã解説
åããŠè³ªåãããŠããã ããŸãã
F660Aã䜿çšããŠãããŸãã
éåžžã«ããã«ãªãåŠç¿ãããŠããã ããŠãããŸãã
ãã 以äžèšå®ã«ããçç±ãããããæ©ãã§ãããŸãã
ãæãããã ããã°å¹žãã§ãã
5GHzéçš
F660Aã®å Žåãåäœã¢ãŒãã¯Mixed(802.11a+802.11n)ã«èšå®ããŠãã
ãšããèšå®ã«ããçç±ã
çç±ã¯èŠæ Œã®æ°ãããšé床é¢ã§ã®æå©ãã
ãŸããWifiã®èŠæ Œã§ãã802.11b/gã«ã€ããŠã¯ã2.4GHzããèšå®ããããŸããïŒå€ãèŠæ Œã§ããããïŒ
802.11aã«ã€ããŠã¯ãäž¡æ¹èŠæ ŒããããŸãããé床ã802.11nãããäœãã®ãšã802.11aãå€ãèŠæ Œã®ïŒã€ã§ãã
802.11n以äžã®5GHzã®å ŽåãçŸåšæ®ã©ã®ç«¯æ«ã察å¿æžã¿ã§ããã®ãšïŒäžéšãæ Œå®ã¹ããã©ã5GHzèªäœã«æªå¯Ÿå¿ãšããã®ã¯ãããŸããïŒèŠ³ç¹ããã802.11a+802.11nã®Mixedãé²ããŠããŸãã
802.11næªå¯Ÿå¿ã ããã©ãã802.11aã«ã¯å¯Ÿå¿ããŠãã±ãŒã¹ãããããã
802.11b/gã¯ããããã¬ã¬ã·ãŒãªèŠæ Œã§ãããããã©ãããŠãå©çšãããå Žåã«ã¯ãå¥ã®APã§ç«ãŠãŠéçšãããšè¯ãã§ãããã