ã¯ãïŒããã±ãŒãžè¿œè·¡ã¯ããŒã 䜿çšåãã«èšèšãããŠããŸããAPIããŒãããŒã ãšå ±æããã ãã§ããããŒã ã¡ã³ããŒãéè·ããå Žåã«äŸ¿å©ãªããã«ããã€ã§ãããŒã倿Žã§ããŸãã
Google Sheetsã䜿çšããŠããå Žåãã·ãŒãã®ææè ãAPIããŒã远å ããå¿ èŠãããå ŽåããããŸãã
䜿çšå¶éã¯ã1æ¥ã«è¿œè·¡ããããã±ãŒãžã®ç·æ°ã«é©çšãããæ°ãã远å ã ãã§ã¯ãããŸãããããšãã°ãã¹ã¿ãŒãã¢ãããã©ã³ïŒ100ããã±ãŒãžïŒã«ããŠãGoogleã·ãŒãã«ãã§ã«100åã®è¿œè·¡çªå·ãããå Žåãããã«è¿œå ããã«ã¯ã¢ããã°ã¬ãŒãããå¿ èŠããããŸãã
é 鿥è ã远跡çªå·ãåå©çšãããããå€ãçªå·ãæ°ããããŒã¿ã衚瀺ãããšæ··ä¹±ãæãå¯èœæ§ããããããå€ã远跡çªå·ãåé€ããããšããå§ãããŸãã
䜿çšéã¯æ¯æ¥UTCã®æ·±å€ã«ãªã»ãããããŸããå¶éãå¢ããããã«ããã€ã§ããã©ã³ãã¢ããã°ã¬ãŒãã§ããŸãã
ã¡ãŒã«ã¢ãã¬ã¹ã倿Žããã«ã¯ãæ¬¡ã®æé ã«åŸã£ãŠãã ããïŒ
ããã±ãŒãžè¿œè·¡ã«ã¯æ¬¡ã®åãå©çšã§ããŸãïŒ
DHLã¯ç¹å¥ãªã±ãŒã¹ã§ãDHL::ãã¬ãã£ãã¯ã¹ãå¿
èŠã§ããBlue Dart远跡çªå·ã®å ŽåããDHL::ãã¬ãã£ãã¯ã¹ã远å ããå¿
èŠããããŸãã
远跡çªå·ã1234567ã®å Žåã代ããã«DHL::1234567ã䜿çšããŸã
ã»ã«B2ã«è¿œè·¡çªå·ãããå Žåãæ¬¡ã®ããã«=track()颿°ãåŒã³åºãããšãã§ããŸãïŒ
=track(B2, "status,provider,date,location,delivered,url,expected", false, $A$1)é 鿥è ã®ååãããã£ãŠããå Žåã¯ã远跡çªå·ã®åã«é 鿥è ãä»ããããšã匷ããå§ãããŸããããã«ããããã®é 鿥è ããã®çµæã®ã¿ãååŸããããã«æç€ºãããŸããããã«ãããå¿çæéãå€§å¹ ã«ççž®ãããŸãïŒ
DHL::1234567ã¢ããã³éµäŸ¿::1234567DHLçªå·ã¯DHL::ãã¬ãã£ãã¯ã¹ã§å§ãŸãå¿ èŠããããŸãã
=track()åŒã®2çªç®ã®åŒæ°ã¯ãè¿ãããåã®ã«ã³ãåºåãã®æååã§ããå©çšå¯èœãªåã®å®å
šãªãªã¹ãã«ã€ããŠã¯ããã®FAQããŒãžã®ãäžè¬ãã»ã¯ã·ã§ã³ãåç
§ããŠãã ãããååã§ã»ã«ç¯å²ãæå®ããããšãã§ããŸãïŒ
=track(B2, $C$1:$H$1, false, $A$1)3çªç®ã®åŒæ°ã¯ãå®å šãªå±¥æŽãè¿ããã©ããïŒtrueãŸãã¯falseïŒã§ãã
4çªç®ã®åŒæ°$A$1ã¯ãªãã·ã§ã³ã§ã颿°ãæŽæ°ã§ããŸãïŒè©³çްã«ã€ããŠã¯ã次ã®ãããã¯ãã¹ããŒã¿ã¹ãæŽæ°ããã«ã¯ïŒããåç
§ããŠãã ããïŒã
Google Sheetsã§ã¯ãã«ã¹ã¿ã 颿°ãèªåçã«æŽæ°ããããšã¯ã§ããŸããããã ãããªã³ããã³ãã§é¢æ°ãæŽæ°ã§ããåé¿çããããŸããã«ã¹ã¿ã 颿°ã®åŒæ°ã倿Žããããã³ã«ã颿°ãæŽæ°ãããŸãã颿°ã®æåŸã®åŒæ°ãšããŠã»ã«åç §ã远å ããããšã§ããã®ã»ã«ã®å€ã倿ŽããŠã¹ããŒã¿ã¹ãæŽæ°ã§ããŸãã
=track(B2, "status,date", false, $A$1)$A$1ã®å€ã倿ŽããããšãåŒãæŽæ°ãããŸãã$A$1ãéžæããŸããããä»»æã®ã»ã«ãéžæã§ããŸãã
ããã±ãŒãžè¿œè·¡ã¢ããªã³ãã€ã³ã¹ããŒã«ããŠããã®ãšã©ãŒã衚瀺ãããå Žåãå ±æã·ãŒãã䜿çšããŠããå¯èœæ§ããããŸãããã®å Žåããã®å ±æã·ãŒãã®ææè ãã¢ããªã³ãã€ã³ã¹ããŒã«ããŠå®è¡ããå¿ èŠããããŸãã
ææãŠãŒã¶ãŒã®å ŽåãAPIããŒãã·ãŒãã®ææè ãšå ±æã§ããŸãããŸãã¯ãã·ãŒãã®æææš©ãèªåã«å€æŽããããšãã§ããŸãã
ã«ã¹ã¿ã 颿°ãå®è¡ããã«ã¯ãGoogle Sheetsã§æç€ºçãªæ¿èªãå¿ èŠã§ãããµã€ãã¡ãã¥ãŒãéãããšã§ããã®æ¿èªãå®è¡ã§ããŸãã
ã·ãŒãã®ææè ãæ¿èªãå®è¡ããå¿ èŠãããããšã«æ³šæããŠãã ãããããã¯ãå ±æã·ãŒãã䜿çšããŠããå Žåãæ¬¡ã®ãããããè¡ãå¿ èŠãããããšãæå³ããŸãïŒ
ãµã€ãã¡ãã¥ãŒãéãããããã¹ããŒã¿ã¹ãæŽæ°ããã«ã¯ïŒãã®æé ã«åŸã£ãŠåŒãæŽæ°ããŠãã ãã
=INDEX(track(B2,"status,date",true,$A$1),ROWS(track(B2,"status,date",true,$A$1)))2çªç®ã®ã€ãã³ããååŸããã«ã¯ãåã«1ãåŒããŸãïŒ
=INDEX(track(B2,"status,date",true,$A$1),ROWS(track(B2,"status,date",true,$A$1))-1)Google Sheetsã§è¡ããããã¹ãŠã®å€éšãªã¯ãšã¹ãã¯ããããã·ãééããå®è¡ã§ããå€éšåŒã³åºãã®æ°ã«å¶éã課ããŸããå¶éã¯G Suiteãµãã¹ã¯ãªãã·ã§ã³ã«ãã£ãŠç°ãªããŸããURL FetchåŒã³åºãã®å¶éã¯ãã¡ãã§ç¢ºèªã§ããŸãã
ãã®ãšã©ãŒãçºçããå Žåãæ¬¡ã®ããšãã§ããŸãïŒ
Googleã¯ãããã·ã䜿çšããŠãµãŒããŒããããŒã¿ãååŸããéåžžã«å³ããã¿ã€ã ã¢ãŠãããããŸãã倧éã®ããã±ãŒãžã远跡ããŠããå Žåããã®ãšã©ãŒãé »ç¹ã«çºçããå¯èœæ§ããããŸãã
ãã®å ŽåãExcelã¢ããªã³ã䜿çšããŠãã ãããExcelããªãå Žåã¯ãoffice.comã§ç¡æçã䜿çšã§ããŸãã
ã»ã«ã«é¢æ°ãããå Žåããã®ã»ã«ãŸãã¯è¡ãé衚瀺ã§ãã£ãŠã颿°ãåŒã³åºãããŸãã
ã»ã«ã衚瀺ãããŠããå Žåã®ã¿é¢æ°ãåŒã³åºãå Žåã¯ã次ã®ããã«ããŸãïŒè¿œè·¡çªå·ãB3ã«ãããšä»®å®ïŒïŒ
=if(subtotal(103,B3)=0,"hidden",track(B3,"status",false))ããã¯æ¬¡ã®ããããïŒãŸãã¯äž¡æ¹ïŒãæå³ããå¯èœæ§ããããŸãïŒ
;ã«çœ®ãæããŠãã ãã=track(B2, "status,location,date", false, $A$1)ã»ã«B2ã«è¿œè·¡çªå·ãããå Žåãæ¬¡ã®ããã«=PACKAGE.TRACK()颿°ãåŒã³åºãããšãã§ããŸãïŒ
=PACKAGE.TRACK(B2, "status,provider,date,location,delivered,url,expected", false)é 鿥è ã®ååãããã£ãŠããå Žåã¯ã远跡çªå·ã®åã«é 鿥è ãä»ããããšã匷ããå§ãããŸããããã«ããããã®é 鿥è ããã®çµæã®ã¿ãååŸããããã«æç€ºãããŸããããã«ãããå¿çæéãå€§å¹ ã«ççž®ãããŸãïŒ
DHL::1234567ã¢ããã³éµäŸ¿::1234567DHLçªå·ã¯DHL::ãã¬ãã£ãã¯ã¹ã§å§ãŸãå¿ èŠããããŸãã
=PACKAGE.TRACK()åŒã®2çªç®ã®åŒæ°ã¯ãè¿ãããåã®ã«ã³ãåºåãã®æååã§ããå©çšå¯èœãªåã®å®å
šãªãªã¹ãã«ã€ããŠã¯ããã®FAQããŒãžã®ãäžè¬ãã»ã¯ã·ã§ã³ãåç
§ããŠãã ãããååã§ã»ã«ç¯å²ãæå®ããããšãã§ããŸãïŒ
=PACKAGE.TRACK(B2, $C$1:$H$1, false)3çªç®ã®åŒæ°ã¯ãå®å šãªå±¥æŽãè¿ããã©ããïŒtrueãŸãã¯falseïŒã§ãã
Slackã§ããã±ãŒãžã远跡ããããã®å æ¬çãªã¬ã€ããã芧ãã ãã
Stripeåºæã®FAQã¯ããã«è¿œå ãããŸãã