An easy way of recruiting participants.
æ¬ããã¯ã¯ãäžèŠæš¡ãŸã§ã®å¿çåŠå®éšãè¡ãéã«ãåå è ã®åéã»é£çµ¡ãåæ»ã«è¡ããã®ã§ãã Google Apps Script (ãšã¯ã»ã«VBAã®ãããªãã®)ãçšããŠãGoogleã®åçš®ãµãŒãã¹ (googleãµã€ããgoogleãã©ãŒã ãgoogleã«ã¬ã³ããŒåã³gmail) ãé£æºãããããšã§ãã»ãŒèªåã§åå è ã®åéã»é£çµ¡ãè¡ãããšãã§ããŸãã
ãªããher0m31ããã®ãGoogle Form -> SpreadSheet -> Calendar && Mailã§ç°¡åãªäºçŽãã©ãŒã ãäœããã ã®ã説æã»ã³ãŒãã倧å€åèã«ãããŠããã ããŸããã
ãšã©ãŒçãããŸãããïŒhttps://github.com/grocio/participants-recruitment-jp/issues ïŒæ¬å®¶ïŒã§å ±åããŠãããã ããïŒparticipant.recruit.testã
gmail.com ãŸã§ãé£çµ¡ãã ãã(ã
ã¯@
ã«å€æŽããŠãã ãã)ã
ãŸãïŒhttps://github.com/SNishiyama/participants-recruitment-jp ïŒå家ïŒã®ã»ããæ å ±ãæ°ããå¯èœæ§ããããŸãã
Google Apps Scriptã䜿çšããŠäžæ¥ã«èªåã§éä¿¡ã§ããã¡ãŒã«ã®æ°ã«ã¯å¶éããããŸãã
ãã®ã¡ãŒã«ã«ã¯æ¬ã·ã¹ãã ã§éä¿¡ããããã¹ãŠã®ã¡ãŒã«ãå«ãŸããŸãã
ãããè¶
ãããšã·ã¹ãã ãéãããšããåçš®ã¡ãŒã«ãéä¿¡ãããªããªãã®ã§ã泚æãã ããã
åéãéå§ããåæãªã©ã«å¿åã殺å°ããå ŽåïŒäºçŽã®å®äºã¯è¿ãæ¥ã®äººã ãã«éå®ããã®ããããšæãããŸãã
ã¡ãªã¿ã«èªåéä¿¡ã®äžéã¯100éã§ãã
ãã ãããã©ã«ãèšå®ã§ã¯ïŒåçš®ã¡ãŒã«ãå°ãªããšãåå è
ãšå®éšè
ã®2ã€ã®ã¢ãã¬ã¹ã«éä¿¡ãããïŒã€ãŸã1åã«2éåïŒã®ã§ïŒå€ããŠã50人åããã¡ãŒã«ãéä¿¡ã§ããªããšããããšã«ãªããŸãã
selfBcc...
ãããã®èšå®ãå€ããŠèª¿æŽããŠãã ããïŒãããã¯Googleã«èª²éããŠäžéãç·©åãããŸãããïŒã
- åå è
ã¯ã空ãæéã確èªãã空ããŠããæé垯ã«å¿çåŠå®éšã®ä»®äºçŽãããããšãã§ããŸãã
- å®éšå®æœå¯èœæéãèšå®ããŠããã®æéå€ã«äºçŽããŠããå Žåã¯å¿åè ã«åç»é²ãä¿ãã¡ãŒã«ãèªåã§éä¿¡ãããŸãã
- æ¢ã«ååšããäºçŽãäºå®ãšéè€ããæéã«äºçŽããŠããå Žåãåæ§ã®ã¡ãŒã«ãéä¿¡ãããŸãã
- å®éšè
ã¯ãä»®äºçŽãããæé垯ãã¹ãã¬ããã·ãŒãäžã§ç¢ºèªããäºçŽå®äºã
111
ãšå ¥åããããšã§è¡ãããšãã§ããŸãã- ããã«é£åããŠãåå è ã«ã¯å®éšæ¥æãªã©å¿ èŠãªæ å ±ãèšèŒãããã¡ãŒã«ãèªåã§éä¿¡ãããŸãã
111
ãšå ¥åãã代ããã«ã222
(æ¢åå ),333
(å®å¡è¶ é)ã®ãããããå ¥åãããšãããããã«å¯Ÿå¿ããã¡ãŒã«ãèªåã§éä¿¡ããåå ãæãããšãã§ããŸãã
- å®éšã®åæ¥ã«åå è ã«ãªãã€ã³ããŒã¡ãŒã«ãèªåã§éä¿¡ãããŸãã
- å®éšè ãè€æ°ããã±ãŒã¹ã«ã察å¿ããŠããŸãã
- ãããã®æ©èœã«é¢ããèšå® (ã¡ãŒã«ã®æ¬æãªã©) ãã¹ãã¬ããã·ãŒãäžã§å€æŽããããšãå¯èœã§ãã
- ãã³ããã°ã©ããŒã®æ¹ã ã§ãçšéã«åãããŠæè»ã«å€æŽã§ããããã«ããŸããã
- åãæé垯ã«è€æ°äººã®äºçŽãå ¥ããããšã¯ã§ããŸããããããã£ãŠã1åã®å®éšã«2人以äžãåå ãããšããå®éšã«ã¯å¯Ÿå¿ããŠããŸããã
- 2019/07/31
- å®éšéå§æ¥ãšçµäºæ¥ãæããŸããã§ãããšãã«èªåã§åžææ¥ãæŽæ°ãã
modifyFormType2
ãããŸãåäœããªããã°ãä¿®æ£ããŸããã
- å®éšéå§æ¥ãšçµäºæ¥ãæããŸããã§ãããšãã«èªåã§åžææ¥ãæŽæ°ãã
- 2019/07/25
- åçã®ãªãè¡ã®äºçŽã¹ããŒã¿ã¹ã«å€ãå ¥åããéã«ãšã©ãŒãçããªãããä¿®æ£ããŸããã
- 2019/07/16
- ã¹ãã¬ããã·ãŒããéãããšãã«èªåéä¿¡ã¡ãŒã«ã®æ®æ°ãæŽæ°ãããããã«ä¿®æ£ããŸããã
- ããã©ã«ãèšå®æã®ã·ãŒãã®æžåŒèšå®ãæŽããŸããã
- 2019/07/13
- ã¹ãã¬ããã·ãŒãã䜿çšããïŒäºçŽå®äºã¡ãŒã«ãšãªãã³ã€ããŒæ©èœã ãã䜿çšããããšãå¯èœã§ãã
- å®éšã®åžææ¥ã»åžææ¥æãã¹ãã¬ããã·ãŒãäžã«ããã¥ã¢ã«ã§å ¥åããŠäºçŽå®äºã¡ãŒã«ã»ãªãã€ã³ããŒãéãããšãå¯èœã«ãªããŸããã
- ã¹ãã¬ããã·ãŒãã䜿çšããïŒäºçŽå®äºã¡ãŒã«ãšãªãã³ã€ããŒæ©èœã ãã䜿çšããããšãå¯èœã§ãã
- 2019/07/07
- æçµæ¥(
closeDate
)ã«å¿åãã人ãæéå€ãšå€å®ãããŠããŸããã°ãä¿®æ£ããŸããã
- æçµæ¥(
- 2019/06/18
- ã¡ãŒã«åšãã®ä»¥äžã®2ç¹ãä¿®æ£ããŸããã
- èªåã«bccã§ã¡ãŒã«ãéããã©ãããèšå®ã§ããããã«ããŸããã
- ç¿æ¥ã®å®éšäºå®ãããã°ããïŒãïŒããŸãšããŠã¡ãŒã«ã§éç¥ã§ããããã«ããŸããããã®æ©èœãèšå®ã§ON/OFFãåãæ¿ããããŸãã
- ã¡ãŒã«åšãã®ä»¥äžã®2ç¹ãä¿®æ£ããŸããã
- 2019/06/12
- ãã©ãŒã ã®åžææ¥ãèªåã§æŽæ°ããé¢æ°ãä¿®æ£ããŸããã
- 2019/06/07
- äŒæ¥çšã®ã¡ãŒã«æ¬æãç¥æ¥ã§ãéä¿¡ãããããã«ãªããŸãããhttps://qiita.com/jz4o/items/d4e978f9085129155ca6 ãåèã«ããŸããã
- 2019/06/06
- åç §ããã«ã¬ã³ããŒãèšå®ã·ãŒãã§å€æŽã§ããããã«ããŸããã
- 2019/05/31
- æ¥ä»ã«åãããŠãã©ãŒã ã®åžææ¥ã®éžæãæŽæ°ããé¢æ°ã®é倧ãªãã°ãä¿®æ£ããŸãã
- 2019/05/28
- è€æ°ã®ããªã¬ãŒãäºçŽå®äºã®ããªã¬ãŒãšããŠæå®ã§ããããã«ãªããŸããã
- éžæåŒ
TYPE = 2
ã®å Žåã«ïŒæ¥ä»ã«ããããŠãã©ãŒã ã®åžææ¥ã®éžæè¢ãæŽæ°ãããããã«ãªããŸããã- å®éšéå§æ¥ïŒãã§ã«éå»ã®å Žåã¯ä»æ¥ïŒããå®éšæçµæ¥ãŸã§ã®æ¥ä»ãèªåã§å ¥åãããããã«ãªããŸãã
- ããã¯ïŒãªãã€ã³ããŒãéä¿¡ãããã¿ã€ãã³ã°ã§åäœããŸãã
main.gs
ãå©çšããåå è
åéã·ã¹ãã ãå°å
¥ããŸããæé ã¯ä»¥äžã®ããã«ãªããŸãã
- åå åéãã©ãŒã ã®äœæ
- ãã©ãŒã ã®åçãèšé²ãããã¹ãã¬ããã·ãŒãã®äœæ
- ã¹ãã¬ããã·ãŒãã«å¯ŸããŠ
main.gs
ãå®è¡ã§ãããããžã§ã¯ãã®äœæ - ã«ã¬ã³ããŒã®èšå®
- åå è ãã¢ã¯ã»ã¹ãããµã€ãã®äœæ
æ¬ã³ãŒãã§äœ¿çšããã¡ãŒã«ã¢ãã¬ã¹ã¯Gmailã®ãã®ãšããŸãããã®ãããGoogleã¢ã«ãŠã³ããæã£ãŠããªãå Žåã¯äœæããŠãã ããããªãããã§ã«ã¢ã«ãŠã³ããæã£ãŠããå Žåã§ãå®éšå°çšã®ã¢ã«ãŠã³ãã®äœæãããããããŸãããã©ã€ããŒãã§ã䜿çšããŠããã¢ã«ãŠã³ãã§ãã®ã·ã¹ãã ãå©çšãããšãæ¬ããã¯ãããŸãåäœããªãã£ãããæ®æ®µã®ã«ã¬ã³ããŒã®å©çšãäžäŸ¿ã«ãªã£ããããå¯èœæ§ããããŸãã
googleãã©ãŒã ãå©çšããŠè³ªåãã©ãŒã ãäœæããŸãã
- å©çšããGoogleã¢ã«ãŠã³ãã®googleãã©ã€ããéã
- Googleãã©ã€ãã®å·Šäžã«ãããïŒããã¿ã³ãã¯ãªãã¯ããããã©ãŒã ããéžæããæ°èŠãã©ãŒã ãäœæãã
- å¿ èŠãªè³ªåé ç®ãäœæããŸãã
æ¬ããã¯ã§ã¯ãåžææéã®èãåãã«é¢ããŠæ¬¡ã®2çš®é¡ã®æ¹æ³ã«å¯Ÿå¿ããŠããŸãã
-
èªç±åçã¿ã€ã: åå è ã«ä»»æã®åžææ¥æãå ¥åããŠããããŸããå°ãªããšã以äžã®3ã€ã質åé ç®ãšããŠèšå®ããŠãã ããã
- åå (çæåç)
- ã¡ãŒã«ã¢ãã¬ã¹ (çæåç)
- åžææ¥æ (æ¥ä», å³äžã®èšå®ãã¿ã³ãã¯ãªãã¯ããŠæå»ãå«ããã«ãã§ãã¯)
-
éžæåŒã¿ã€ã: åå è ã¯äºåã«çšæãããå®éšã®å®æœæ¥ã»æéã®éžæè¢ããéœåã«åããã®ãéžæããŸããå°ãªããšã以äžã®4ã€ã質åé ç®ãšããŠèšå®ããŠãã ããã
- åå (çæåç)
- ã¡ãŒã«ã¢ãã¬ã¹ (çæåç)
- åžææ¥ (ãã¿ã³éžæ or ãã«ããŠã³éžæ)
- æ¥ä»è¡šç€ºã®ãã©ãŒãããã¯åããŸãã (2019/5/23, 5æ23æ¥)
- 幎ãå«ãå Žåã¯è¥¿æŠã䜿çšããŠãã ããã
- å®æœæãåéæãšåãã§ãªãéãæ¥ã«ã¡ã ãã®éžæè¢ã¯çšããªãã§ãã ããã
- åžææé (ãã¿ã³éžæ or ãã«ããŠã³éžæ)
- éžæè¢ã«ã¯å®éšçµäºæéãå«ããããšãããããããŸã (12:30 - 13:30ãªã©)
- æé衚瀺ã®ãã©ãŒãããã¯åããŸãã (12:30, 12æ30å)
èªç±åçã®å Žåãå®éšè ãäºåã«éžæè¢ãèšå®ããå¿ èŠã¯ãªããåå è ãèªèº«ã®äºå®ã«åãããŠèªç±ã«å®éšæ¥æãæå®ããããšãã§ããŸãã ãã ããããŸã«äžéå端ãªå®éšééãçããããšããããŸãã äŸãã°ã1æéã®å®éš3ã€ããããã13:00-14:00, 14:45 - 15:45, 16:00 - 17:00ã«äºçŽãå ¥ããããªå Žåãã2ã€ç®ã®äºçŽã15:00 - 16:00ãªãã°14:00-15:00ã«å¥ã®å®éšäºçŽãå ¥ã£ããããããªãã®ã«ãããããšããæ°æã¡ã«ãªããŸãã
éžæåŒã®å Žåãå®éšè ã¯äºåã«éžæè¢ãèšå®ããå¿ èŠããããåå è ããã®æéã«ããå¿åããããšããã§ããŸããããå®éšæéã®ã¹ããããåºå®ããããšãã§ããŸãã ãã®ãããå è¿°ã®ãããªäºæ ãåé¿ããããšãã§ããŸãã æ¯èŒçé·ãå®éšã1æ¥ã®ãã¡ã«è©°ããŠå®æœãããå Žåã¯ãéžæåŒã®ã»ãã確å®ããšæããŸãã
å¿ èŠã«å¿ããŠè³ªåé ç®ãå¢ããããšãã§ããŸããäŸãã°ã
- ãµãã㪠(çæåç)
- 幎霢 (çæåç, åçã®æ€èšŒ -> ãæ°åããšãããšåè§æ°åã ããåãä»ããããããã«ãªã)
- æ§å¥ (ãã¿ã³éžæ or ãã«ããŠã³éžæ)
- æå± (çæåç or ãã«ããŠã³éžæ[ãã£ã¡ã¯è¡šèšããããªããŠãã])
- åŠå¹Ž (çæåç or ãã«ããŠã³éžæ[ãã£ã¡ã¯è¡šèšããããªããŠãã])
ãã ããåžææ¥æ (èªç±åç) ãããã¯åžææ¥ã»åžææé (éžæåŒ) ã¯ãã©ãŒã ã®æåŸã«æã£ãŠããããšãæšå¥šããŸãã åŸè¿°ã®åæèšå®ã®ãŸãŸã·ã¹ãã ãå©çšããããšãã§ããŸãã
ãªããæ¬ããã¯ã¯å®éšåå ã®åžææ¥æãè€æ°å°ããããšã«ã¯å¯Ÿå¿ããŠããŸããã åžææ¥æè€æ°èãããªãã¹ãå€ãã®å®éšãçæéã«è©°ããŠå®æœã§ãããã調æŽããããšãå¯èœã§ã¯ãããŸãããããããæ©ãã³ã¹ãã®å²ã«åŸãããå¹æã¯èããšèããŠããŸãã å©çšããŠåäžã®åžææ¥æãèãå çé ã«äºå®ãçµãã§ãã£ãå Žåã§ããçžå¿ã«å®éšãè©°ããŠå®æœã§ãããšæããŸãã
- ããããã®è³ªåé ç®ã«ã¯ãèšå®ãã¿ã³ããã説æããã¯ãªãã¯ãããšèª¬ææãå ããããšãã§ããŸãã泚æäºé çãèšèŒãããšè¯ããšæããŸãã
- ããããã®åçãå¿ é ã®åçã«ããŠããããšãå¿ããªãã§äžããã
- ãã©ãŒã ã®å®çšäŸãšããŠãhttps://sites.google.com/view/participant-recruit-test/home/free ããã㯠https://sites.google.com/view/participant-recruit-test/home/choice ãã芧ãã ããã
ãã©ãŒã ã§åŸãããããŒã¿ãã¹ãã¬ããã·ãŒãã«éãããã«èšå®ããŸãã äœæ¥ã¯ä»¥äžã®1æé ã®ã¿ã«ãªããŸãã
åçã¿ãããå³äžã«è¡šç€ºãããã¹ãã¬ããã·ãŒãã®äœæãã¯ãªãã¯ããã¹ãã¬ããã·ãŒããäœæããŸãã
以éããã©ãŒã ã«å ¥åãããããŒã¿ã¯ã¹ãã¬ããã·ãŒãã«åæ ãããããã«ãªããŸãã
ã¢ã³ã±ãŒãã®åçããã£ããšãããåå ã®äºçŽãå®äºããããšãã«ã»ãŒèªåã§ã¡ãŒã«ãéä¿¡ãããããã«ãã¹ãã¬ããã·ãŒãã«å¯ŸããŠåäœããããã°ã©ã ãå°å ¥ããŸãã
- main.gsã®ã³ãŒããã³ããŒããŠäžããã
- ããã«ã¢ã¯ã»ã¹ããŠ
crtl-A
ããã³ctrl-C
ïŒMacãªãcommand-A
,command-C
ïŒ
- ããã«ã¢ã¯ã»ã¹ããŠ
- 質åãã©ãŒã ã®åçãèšé²ãããã¹ãã¬ããã·ãŒããéããäžéšã®ããŒã«ããŒãã
ããŒã«
->ã¹ã¯ãªãããšãã£ã¿
ã®é ã«ã¯ãªãã¯ããŠäžããã - ã¹ã¯ãªãããšãã£ã¿ãéãããŸãã®ã§ãããã«
main.gs
ã®å 容ã貌ãä»ããŸããctrl-S
ïŒMacãªãcommand-S
ïŒã§ä¿åããŠãã ããããã®ãšãïŒãããžã§ã¯ãã®ååãæ±ããããã®ã§ïŒé©åœã«æ±ºããŠãã ããã
googleã«ã¬ã³ããŒã®ããŒãžã«é£ãã§ãã ããã ããŒãžå·ŠåŽã«ã«ã¬ã³ããŒäžèŠ§ããããŸãããä»åã¯ãã€ã«ã¬ã³ããŒã®äžçªäžã«ããã«ã¬ã³ããŒã䜿çšããŸãã
- ãã®ã«ã¬ã³ããŒã®å³ã«çŸãã瞊åãã®3ã€ã®ç¹ãã¯ãªãã¯ãããèšå®ãšå ±æããéžæããŠäžããã
- ã¢ã¯ã»ã¹æš©éã®ãäžè¬å ¬éããŠèª°ã§ãå©çšã§ããããã«ãããã«ãã§ãã¯ãå ¥ããŠãã ãã
- ããã«ãå¿ ãå³åŽã®ãé²èŠ§æš©é (ãã¹ãŠã®äºå®ã®è©³çŽ°) ããã¯ãªãã¯ããäºå®ã®æéæ ã®ã¿ãäžè¬ã«å ¬é (詳现ã¯é衚瀺ãã«å€æŽããŠãã ããã
ã€ãã³ãåã«åå è ã®ååãå ¥ãã®ã§å人æ å ±ã衚瀺ããªãããã«ãå¿ ãäºå®ã®æéæ ã®ã¿ãäžè¬ã«å ¬éã«ã¯ãã§ãã¯ãå ¥ããŠäžããã
åå è ãå®éš (è ) ã®äºå®ãåç §ããªããå¿åã§ããããã«ãã«ã¬ã³ããŒãšå¿åãã©ãŒã ãé 眮ããgoogle siteãäœããŸãã å®æäŸãšããŠãhttps://sites.google.com/view/participant-recruit-test/home/free ããã㯠https://sites.google.com/view/participant-recruit-test/home/choice ãã芧ãã ããã
Google ãã©ã€ãã«ã¢ã¯ã»ã¹ãããã©ãŒã ãäœæãããšããšåæ§ã«ãå·Šäžã®æ°èŠ -> ãã®ä» -> Google ãµã€ãã®é ã«ã¯ãªãã¯ããŠãã ããã
- å®éšã®æŠèŠãèšèŒããããã®ããã¹ãããã¯ã¹
- åå è ã®æ å ±åã³åžææ¥æãå ¥åããŠããã質åãã©ãŒã
- 空ãæéãåç §ããããã®ã«ã¬ã³ããŒ
ãé 眮ããŸãã
ãã¹ãŠå³åŽã«ããããŒã«ããŒãæ¿å ¥ãã¿ãããéžæããŸãã
- 質åãã©ãŒã ã¯ããã©ã€ã -> (ãã©ãŒã ãä¿åãããã©ã«ã ->) 該åœãããã©ãŒã ãã§æ¿å ¥ã§ããŸãã
- ã«ã¬ã³ããŒã¯ãæ¿å ¥ãã¿ããäžã®æ¹ãŸã§ã¹ã¯ããŒã«ãããšãã«ã¬ã³ããŒãããšããé ç®ãããã®ã§ããããã¯ãªãã¯ããgmailã®ã¢ãã¬ã¹ã衚瀺ãããŠãããã®ãéžæããŠãã ããã
- ã·ã¹ãã ã®åæèšå®
- ã«ã¬ã³ããŒã®æºå
- åäœç¢ºèª
å
ã»ã©éããã¹ã¯ãªãããšãã£ã¿ããinit
ãšããé¢æ°ãå®è¡ããããã°ã©ã åäœãéä¿¡ãããã¡ãŒã«å
容ãªã©ã®åæèšå®ãè¡ããŸãã
ã¹ã¯ãªããã®äžçªæåã®è¡ã«ããTYPE
ãå¿åãã©ãŒã ã®åœ¢åŒã«åãããŠå€æŽããŠãã ãã
- å®è¡ãã¿ã³ (â¶) ã®å³ã«ãã
é¢æ°ãéžæ
ããinit
ãéžæ - å®è¡ãã¿ã³ (â¶) ãã¯ãªãã¯
é¢æ°ãéžæã§ããªãå Žåã¯ïŒã¹ã¯ãªãããä¿åãããŠããªãããšãåå ãããããŸããã
ctrl-S
ïŒMacãªãcommand-S
ïŒã§ä¿åããŠãã ããããã®ãšãïŒãããžã§ã¯ãã®ååãæ±ããããã®ã§ïŒé©åœã«æ±ºããŠãã ããã
ãã®çŽåŸã¹ãã¬ããã·ãŒããéããšããåæèšå®ãè¡ããŸãããšãããŠã£ã³ããŠã衚瀺ãããŸãã 説æãèªã¿åé¡ãªããã°åæèšå®ãè¡ã£ãŠãã ãããã¹ãã¬ããã·ãŒãã«ãèšå®ãããã³ãã¬ãŒãããã¡ã³ããŒããšããã·ãŒããæ°ãã«è¿œå ãããŸãã
以äžã®æé ã§ããã°ã©ã ãæ¿èªããŠãã ããã
- 詳现ã衚瀺ãã¯ãªãã¯
- ç»é¢ãã¹ã¯ããŒã«ããŠãŠã£ã³ããŠäžéšã«ãã
å®å šã§ãªãããŒãžã«ç§»å
ãã¯ãªã㯠- ç»é¢ãã¹ã¯ããŒã«ããŠãŠã£ã³ããŠäžéšã«ãã
èš±å¯
ãã¯ãªãã¯
å®éšå®æœå¯èœæéå ã§ãå®éšãã§ããªãæéãããã°ã䜿çšããã«ã¬ã³ããŒã«ãããè¿œå ããŠãã ããã
äžžäžæ¥å®éšãããªãå ŽåïŒäŸãã°ïŒåæ¥ç¥ïŒã¯ïŒãããã®æ¥çšã«çµæ¥ã®äºå®ãå ¥ããŠãã ããã
åç
§ããã«ã¬ã³ããŒãå€æŽããå Žåã¯ïŒä»¥äžã®æé ã§ãã®ã«ã¬ã³ããŒã®IDãååŸããŠïŒåç
§ããã«ã¬ã³ããŒ
ã®å€ãå€æŽããŠãã ããïŒGoogleã®ãã«ãããæç²ãïŒå€æŽïŒã
- Google ã«ã¬ã³ããŒã®å·ŠåŽã®é åã«ãã[ãã€ã«ã¬ã³ããŒ]ãããå©çšãããã«ã¬ã³ããŒãæ¢ããŸãã
- åœè©²ã«ã¬ã³ããŒã®ãšããã§ïŒïžïŒçžŠäžç¹ïŒ> [èšå®ãšå ±æ] ã®é ã«ã¯ãªãã¯ããŸãã
- [ã«ã¬ã³ããŒã®çµ±å] ã»ã¯ã·ã§ã³ãŸã§äžã«ã¹ã¯ããŒã«ããŠã[ã«ã¬ã³ã㌠ID] ãã³ããŒããŸãïŒé·ã ID ã§ãïŒã
å®éã®å®éšåéã«å©çšããåã«åäœç¢ºèªãè¡ã£ãŠãã ããã
ãµã€ãã«ã¢ã¯ã»ã¹ãããã©ãŒã ããå®éšåå ã®å¿åãè¡ã£ãŠãã ããã ãªãã以äžã®ç¹ãããããããŸãã
- ã·ãŒã¯ã¬ãã (ãã©ã€ããŒã) ãŠã£ã³ããŠãããµã€ãã«ã¢ã¯ã»ã¹ããã
- å®éšçšã®ã¡ãŒã«ã¢ãã¬ã¹ã§ã¯ãªãã¢ãã¬ã¹ããã©ãŒã ã«èšå ¥ããã
ãšãã«åå è ãå©çšããç¶æ³ã«è¿ã¥ããããã§ãã ã·ãŒã¯ã¬ãããŠã£ã³ããŠãããµã€ãã«ã¢ã¯ã»ã¹ããå Žåã¯ãã«ã¬ã³ããŒã®äºå®ããäºå®ããããšã ã衚瀺ãããŠãããã©ããã確èªããŠãã ããã
ä»®äºçŽãã§ããŸãããããŸãã確èªã®ã¡ãŒã«ãåå è ãšèªåã«éä¿¡ãããŸãã
次ã«ã¹ãã¬ããã·ãŒãäžã«åçãèšé²ãããŸããäŸãã°ã
ã¿ã€ã ã¹ã¿ã³ã | ãåå | ã¡ãŒã«ã¢ãã¬ã¹ | åžææ¥æ | äºçŽã¹ããŒã¿ã¹ | é£çµ¡ããã | ãªãã€ã³ãæ¥æ | ãªãã€ã³ãããã | æ åœ |
---|---|---|---|---|---|---|---|---|
2017/04/05 12:30:35 | åå è 倪é | pro.sankasha@sample.com | 2017/04/09 16:00:00 |
ãšãã圢ã«ãªããŸãã
ãŸããã«ã¬ã³ããŒã«ã¯ããä»®äºçŽïŒåå è åããšããã€ãã³ããåžææ¥æ (+æèŠæé) ã®å¹ ã§çæãããŠããã¯ãã§ãã
以äžã®å Žåã«å¿åã®ä¿®æ£ãä¿ãã¡ãŒã«ãéä¿¡ããããã©ããã確èªããŠãã ããã
- èšå®ãããå®éšå®æœå¯èœæé (ããã©ã«ãã§ã¯9~19æ) ãããæ©ãoré ãã«äºçŽããã£ãå Žå
- äºå®ã®éè€ããã£ãå Žå
å®éšè
ãå®éšå¯èœã§ä»ã®åå è
ãåœè©²å®éšã«ãã§ã«åå ããããšããªãããªã©ã確èªããŠãã ããã
æ¢åå ãã©ããã¯ctrl+f
ã®æ€çŽ¢æ©èœãçšããããšã§ãã§ãã¯ã§ãããšæããŸãã
åé¡ãªããã°ãã¹ãã¬ããã·ãŒãããã©ãŒã ã®åç1ãã·ãŒãã«ãããäºçŽã¹ããŒã¿ã¹ãã®åã«111
ãå
¥åããŠãã ããã
äºçŽå®äºã¡ãŒã«ãéä¿¡ãããã¯ãã§ãã
ãŸããã«ã¬ã³ããŒã®äºå®ããäºçŽå®äºïŒåå è
åãã«å€ãã£ãŠããã¯ãã§ãã
質åé
ç®ã«ããµãããªããèšããŠããã°ãäºçŽå®äºïŒåå è
å (ãµãããª) ããšã«ã¬ã³ããŒã«è¡šç€ºãããŸãã
äºçŽã¹ããŒã¿ã¹ã«222
(æ¢åå )ã333
(å®å¡è¶
é)ãå
¥åããåå ãæãã¡ãŒã«ãéä¿¡ããããã©ããã確èªããŠãã ããã
åå ãæãããŒãå
¥åããå Žåãã«ã¬ã³ããŒã«èšèŒãããä»®äºçŽã®äºå®ã¯åé€ãããŸãã
ãªãã€ã³ãæ¥æ
ã®åã«èšèŒãããæ¥ã®19æ~20æ (ããã©ã«ãã®å Žå) ã«ãªãã€ã³ãã¡ãŒã«ãéä¿¡ããããã©ããã確èªããŠãã ããã
é©åã«åäœããããšã確èªããããããèªèº«ã®çšéã奜ã¿ã«åãããŠã¡ãŒã«ã®é¡åã»æ¬æãç·šéããŠãã ããã
ã¹ãã¬ããã·ãŒãã®ããã³ãã¬ãŒããã·ãŒãã®é¡åã»æ¬æ (å¹³æ¥ or åæ¥ç¥) ã®åãç·šéããããšã«ãã£ãŠéä¿¡ãããã¡ãŒã«ã®é¡åã»æ¬æãç·šéããããšãã§ããŸãã
ã¡ãŒã«ã®æ¬æäžã«èšèŒãããŠããã¢ã«ãã¡ãããã®æåå (experimenterName
, experimenterMailAddress
) ã¯ãèšå®ãã·ãŒãã®ãã¡ãŒã«æ¬æå
ã§ã®ããŒãåã®æååãšäžèŽããŠããŸãã
main.gs
ã¯ããèšå®ãã·ãŒãã§ããŒãšããŠèšå®ãããŠããæåå (äŸãã°experimenterName
) ãã¡ãŒã«ã®æ¬æäžããæ¢ãããã®å Žæã«å¯Ÿå¿ããæ
å ± (ããã©ã«ãã§ã¯å®éšå€ªé) ãæ¬æã«åã蟌ãŸããããã«ãªã£ãŠããŸãã
ãããã£ãŠãå¿
èŠã«å¿ããŠãèšå®ãã·ãŒãã®æ
å ±ãã¡ãŒã«ã«èšèŒããªãããã«ãããããèšå®ãã·ãŒãã«æ°ããæ
å ±ãè¿œå ããããã¡ãŒã«ã«èšèŒãããããã«ããããšãã§ããŸãã
äºçŽå®äºã®éã«éä¿¡ããã¡ãŒã« (ããªã¬ãŒ111
ã®è¡) ã§ã¯é»è©±çªå·ãã¡ãŒã«ã«èšèŒãããŸããããããèšèŒãããªãããã«å€æŽããŸãã
ããã©ã«ãã®æ¬æã¯ä»¥äžã®ãšããã§ãã
participantName æ§
ãã®åºŠã¯å¿çåŠå®éšãžã®å¿åããããšãããããŸããã
expDatefromWhenãtoWhenã®å¿çåŠå®éšã®äºçŽãå®äºããŸããã®ã§ã¡ãŒã«ããããŸãã
å Žæã¯experimentRoomã§ããåœæ¥ã¯çŽæ¥ãè¶ããã ããã
ãäžæãªç¹ãªã©ãããŸããããexperimenterMailAddressãŸã§ãé£çµ¡ãã ããã
åœæ¥ããããããé¡ãããããŸãã
å®éšè²¬ä»»è
experimenterName (åœæ¥ã¯ä»ã®è
ãå®éšæ
åœããå¯èœæ§ããããŸã)
åœæ¥ã®é£çµ¡ã¯experimenterPhoneãŸã§ãé¡ãããããŸãã
ãã®æåŸã®1æãåé€ããã°é»è©±çªå·ã¯è¡šç€ºãããªããªããŸã (ãèšå®ãã·ãŒãããé»è©±çªå·ã®æ å ±ãåé€ããå¿ èŠã¯ãããŸãã) ã
åæã«ãæ¬æã«å®éšè ã®æå±ãèšèŒãããå Žåã¯ããŸããèšå®ãã·ãŒãã®æ°ããè¡ã«äŸãã°
1åç® | 2åç® | 3åç® |
---|---|---|
å®éšè ã®æå± | experimenterAff | å¿çåŠå€§åŠå®éšç ç©¶ç§ |
ãšäœæããããšãã¡ãŒã«ã®æ¬æã®æåŸã®1æã
å®éšè²¬ä»»è
experimenterAff experimenterName (åœæ¥ã¯ä»ã®è
ãå®éšæ
åœããå¯èœæ§ããããŸã) ã
ãšå€æŽããããšã§ãã¡ãŒã«ã«èšå®ããæå±ãèšèŒãããããšãã§ããŸãã
ã¡ãŒã«ã®æ¬æãç·šéããéã以äžã®ç¹ã«æ³šæããŠãã ããã
- ãèšå®ãã·ãŒãã«æ¢ã«ååšããããŒã¯çµ¶å¯Ÿã«å€æŽããªãã§ãã ãããããŸãåäœããªããªããŸãã
- ãèšå®ãã·ãŒãã«ç»å Žããªãã㌠(
participantName
,expDate
,fromWhen
,toWhen
) ã¯ããã°ã©ã å ã§ãã£ãã䜿ãããŠããŸãã - ã¡ãŒã«ã®ããŒã«äœ¿çšããæååã¯å¿ ãã¢ã«ãã¡ãããã䜿çšããŠãã ããã ããã°ã©ã ãã¡ãŒã«æ¬æã«èšèŒãããŠããããŒã確å®ã«æ€åºããããã§ãã
- ã¡ãŒã«ã®ããŒã«äœ¿çšããæååã¯ããçšåºŠé·ãããããšãããããããŸãã
çç±ã¯çŽåã®é
ç®ãšåãã§ãã
極端ãªäŸãšããŠãããŒãšããŠ
a
ã䜿çšãããšããã®æ å ±ããpa
rticipa
ntNa
me, expDa
teãªã©ããã³ãã¬ãŒãäžã®ããããa
ãA
ã«ãã®æ å ±ãåã蟌ãŸããŠããŸããŸãã
äžçªå·Šã®åãããªã¬ãŒããšã¯äºçŽã¹ããŒã¿ã¹ã«å ¥åããå€ã®ããšã§ãã ãã®å€ãšåãè¡ã«ããé¡åã»æ¬æãã¡ãŒã«ã«äœ¿çšãããŸãã
å¿ èŠã«å¿ããŠãæ°ãã«ãã³ãã¬ãŒããè¿œå ããããšãã§ããŸãã
äŸãã°ã以äžã®2è¡åãè¿œå ãããšãããš
ããªã¬ãŒ | åæ¥ã§ã®å€æŽ | é¡å | æ¬æ |
---|---|---|---|
444 | 0 | ç·æ¥ | ç·æ¥äºæ ã§ã |
æŽç¬ | 0 | æŽç¬ | å¯æãã§ããã |
ããã©ãŒã ã®åçãã®äºçŽã¹ããŒã¿ã¹ã«ããããã®ããªã¬ãŒãå ¥åããã°ããããã®é¡åã»æ¬æã§è©²åœããåå åžæè ã«ã¡ãŒã«ãéãããšãå¯èœã§ãã ãã ãïŒäºçŽå®äºã®ããªã¬ãŒãšããŠäœ¿çšããããã®ã«ã€ããŠã¯å¿ ãåè§æ°ååã«ããŠãã ãã
ãåæ¥ã§ã®å€æŽãåã§ã¯ïŒå®éšå®æœæ¥ãå¹³æ¥ã®å Žåãšåæ¥ã®å Žåãšã§éä¿¡ãããã¡ãŒã«ã®æ¬æå
容ãå€æŽãããã©ããã決ããããšãã§ããŸãã
å€æŽããå Žåã¯1
ãïŒããªãå Žåã¯0
ãå
¥åããŠãã ããã
ãã®åã«1
ãå
¥åãããŠããå Žåã¯ãæ¬æïŒåæ¥ç¥ïŒãã®åã«ã¡ãŒã«ã®å
容ãèšå
¥ããŠãã ããã
ãªãïŒæ®å¿µãªããç¥æ¥ã«ã¯å¯Ÿå¿ããŠããŸããã
æ¬ããã¯ã§ã¯ãå®éšè²¬ä»»è (å®éšã¢ã«ãŠã³ãææè ) 以å€ã«ãå®éšãæ åœãã人ããããšããçšéã«ã察å¿ããŠããŸãã å ·äœçã«ã¯ãååå è ã«éãäºçŽå®äºããã³ãªãã€ã³ããŒã®ã¡ãŒã«ãäºåã«èšå®ãã人ç©ã«éä¿¡ããããšãã§ããŸãã
- ãã¡ã³ããŒãã·ãŒãã«åæ è ã®ååãã¢ãã¬ã¹ãèšå ¥ããŠãã ããã
- ãããŒãåã«çªå·ããµã£ãŠãã ããã ç¹ã«çç±ããªãéã1ããé ã§åé¡ãããŸããã
- äºçŽãå®äºãããåã«ããæ
åœãåã«æ
åœè
ã®çªå·ãå
¥åããŠãã ããã
è€æ°äººããå Žåã¯
,
ã§åºåã£ãŠå ¥åããŠãã ãã (1,3
ãªã©) ã - å ¥ååŸäºçŽãå®äºãããã°å®éšã®æ åœè ã«ãã¡ãŒã«ãéãããŸãã
- ãã®ãŸãŸæŸã£ãŠããã°ããªãã€ã³ããŒããã®çªå·ã®äººã«éä¿¡ãããŸãã
- èšãæããã°ãæ åœè ãå€æŽã«ãªã£ããããå Žåã¯ãæ åœãã®åãå€æŽããã°ãªãã€ã³ããŒããæ°ããæ åœè ã«éä¿¡ããããšãã§ããŸãã
æ
åœåæ°åãäœæããã®ã§ãå¿
èŠãããã°å©çšããŠãã ããã
ããã©ã«ãã§é¢æ°ãå
¥åãããŠããŸãããæ
åœã®åã«1,3
ãªã©ãšè€æ°äººãæå®ãããŠããå Žåããã®é¢æ°ã¯æ©èœããŸãã
äœæè ã¯ãæ¬ããã¯ãå©çšããããšã«ããçããäžåã®æ害ãæ倱ã®è²¬ä»»ãè² ããŸããã
2æ¡é BSDã©ã€ã»ã³ã¹ãšããŸãã