
AppSheetåå¿è ãæšãŠãã¹ãäœã£ãŠçµããæè
AppSheetã§ã¢ããªãäœã£ãã®ã«ãçŸå Žã䜿ã£ãŠãããªãâŠãããªæ©ã¿ãæ±ããŠããŸãããïŒ ããªãã®åªåã¯ã誰ã«ã䜿ãããªããããžã¿ã«å»å¢ããšåããŠããŸãããïŒ ãã®èšäºã¯ãAppSheetãå°å ¥ãããã®ã®ãçŸå Žããªããªãåãããã¢ããªã掻çšãããªãçŸç¶ã«äžæºãæ±ããäžå°äŒæ¥ã®æ åœè ãçµå¶è åãã§ãã
ãäœã£ãŠçµãããã®AppSheetã¯ãããªãã®æ¥åæ¹åãåæ»ãããæå€§ã®å å¶ã§ãããã®èšäºãèªãã°ããªãããªãã®AppSheetã¢ããªã䜿ãããªãã®ãããã®çã®çç±ãåãããçŸå Žãããããªã䜿ããïŒããšèªèµ°ãå§ããUIæ¹åã®å ·äœçãªæé ãæã«å ¥ããŸãããããäœã£ãã¯ãããã誰ãèŠåããããªãã·ã¹ãã ãã§æéãšåŽåãç¡é§ã«ããã®ã¯çµããã«ããŸãããã
çµè«ïŒAppSheetã¯ãäœã£ãŠçµãããã§ã¯ãªããçŸå Žã®ãæå¥ããèããæ¹åãç¶ããã®ãå¯äžã®é
çŸå Žã«AppSheetã¢ããªãå°å ¥ãããããã§æ¥åå¹çãäžããã¯ãã ããšæåŸ ã蟌ãããã®ã®ãçŸå®ã¯ã©ãã§ããããã
ã»ãšãã©ã®ã±ãŒã¹ã§ãçŸå Žã®åå¿ã¯èãããæ £ããªãããé¢åããããã䜿ãã«ããããããªå£°ãèãããŠããããããŠãçµå±ã¯çŽãExcelã«æ»ã£ãŠããŸãã
ãªããã®ãããªæ²åãç¹°ãè¿ãããã®ããããã¯ãããªããAppSheetããã·ã¹ãã å°å ¥ããšããŠæãããäœã£ãŠçµãããã®æèã«é¥ã£ãŠããããã§ããAppSheetã¯ãäžåºŠäœã£ãã宿ã§ã¯ãããŸããããããããããããæ¬åœã®ã¹ã¿ãŒãã§ããçŸå Žãã¢ããªã䜿ãå§ããããããåºãŠãããæå¥ãããããæ¬¡ã«äœãæ¹åãã¹ãããæããŠããããæåŒ·ã®ä»æ§æžããªã®ã§ãã
ã·ã¹ãã ã¯ãçãç©ã§ãã䜿ãããç°å¢ã䜿ã人ã®å£°ã«åãããŠãåžžã«åœ¢ãå€ããé²åãç¶ããå¿ èŠããããŸãããã®ãæä»€æ®æ¹ãã®ç²Ÿç¥ããªããã°ãã©ããªã«çŽ æŽãããæ©èœãæã€ã¢ããªããçŸå Žã§ã¯åããªããããããããç§ãäžå°äŒæ¥ã®çŸå Žã§æ°ã ã®AppSheetã¢ããªãæ§ç¯ããæåãããŠããäžã§æŽãã çå®ã§ãã
AppSheetã®ãããã誀解ïŒãUIã¯èŠãç®ã ãã®åé¡ãã§ã¯ãªã
Q. èŠãç®ã綺éºã«ããã°çŸå Žã¯äœ¿ã£ãŠãããã¯ãïŒ
A. çŸå Žãæ¬åœã«æ±ããŠããã®ã¯ããèŠãç®ã®çŸãããã§ã¯ãããŸããããã©ãããã°ãä»ã®é¢åãªäœæ¥ãã©ã¯ã«ãªãã®ãããšããå®çšæ§ã§ããæ®å¿µãªãããã©ãã ãã¯ãŒã«ãªãã¶ã€ã³ã®ã¢ããªãäœã£ãŠããçŸå Žã®äœæ¥ã¬ãŒã³ã«ãã£ããããŠããªããã°ãããã¯åãªããåããªã食ããã«éããŸããã
ããããã®ã¯ãããœã³ã³ç»é¢ãåæã«ãã现ããUIãããã®ãŸãŸã¹ããã¢ããªã«èœãšã蟌ãã§ããŸãã±ãŒã¹ã§ããè»æãããæã§ã¿ããããçŸå Žã§ãå°ããªãã¿ã³ãã¹ã¯ããŒã«ããŸããã®å ¥åãã©ãŒã ã¯ããã¯ãæ·åã§ããçŸå Žã¯ãã¹ãããã¿ãã¬ããã§çæéã«ãµããšå ¥åãããããããçè§£ããªããŸãŸãããã£ãããããããšæ©èœããã¶ã€ã³ãè©°ã蟌ãã®ã¯æ¬æ«è»¢åã§ãã
èŠãç®ã®åé¡ã¯ãæ¬è³ªã§ã¯ãªããUIæ¹åãšã¯ãçŸå Žã®ã䜿ãè¡çºããã®ãã®ãæ¹åããããšã§ããå ¥åé ç®ãå€ãããªããããã¿ã³ã¯æŒãããããµã€ãºãããæžããã§ã¯ãªããéžã¶ãã§æžãŸããããªãããããŒã¿å ¥åã®ããã³æž¡ãã¯ã¹ã ãŒãºããçŸå Žãã¹ãã¬ã¹ãªã䜿ãããã©ããããã¢ããªã®æåŠãåããã®ã§ãã
ãUIæ¹åã¯æéããããããšããåè«ã朰ã
Q. æ¹åããŠããæéããªããçŸå Žãå¿ããããæèŠãåºãªãã
A. ãæéããªãããå¿ããããšããèšèã¯ãæè忢ã®ãµã€ã³ã§ããæ¹åã«æéããããã®ã§ã¯ãªãããŸãã¯ãå°ããå§ããŠåã€ããšããèãæ¹ã«åãæ¿ããŸãããã60ç¹ã§ãããããçŸå Žã«åºããçŸå Žããã®ãã£ãŒãããã¯ãæéã§åæ ããããããAppSheetã䜿ã£ãå 補åDXã®ç骚é ã§ããå®ç§ãªã·ã¹ãã ãªã©ããã®äžã«ååšããŸããã
çŸå Žãå¿ãããŠæèŠãåºãªããšãã声ãèããŸãããããã¯ãæèŠãèãå Žããšãèãå§¿å¢ããã§ããŠããªãã ãã§ããäžçªæå¥ãèšãããã©ã³ãããã¢ããªæ¹åã®æé«ã®ããŒãããŒã«ã§ããŸãããããããããã®æ©èœãããå€ããŠã¿ããã©ãã§ããïŒãããã®äžæºãããããã°è§£æ±ºã§ããŸãããïŒããšå ·äœçã«ã¢ãããŒããã圌ãã®å£°ãæŸããå³åº§ã«ä¿®æ£ããŠãããªãã®ããã«çŽããŸããããšäŒããŸãããã圌ãã¯ãã£ãšããéã«ããªãã®å ±ç¯è ã«ãªããæ¹åã®æšé²åã«ãªããŸãã
æ¹åã¯ãé±ã«1åããã£ã5åã§ãããã®ã§ãã倧ããªå€æŽã§ãªããŠãããã¿ã³ã®äœçœ®ãå°ãåãããéžæè¢ãäžã€å¢ããããšãã£ããæä»€æ®æ¹ããç©ã¿éããŠããã°ãã¢ããªã¯çŸå Žã®è¡èãšãªã£ãŠãããŸããæ¬åœã«æéããããã®ã¯ãã䜿ãããªãã·ã¹ãã ãããã€ãŸã§ãæŸçœ®ããçŸå Žã®çç£æ§ãäœããŸãŸã®ç¶æ ãç¶ããããšã®ã»ãã§ãã
çŸå Žããèªèµ°ãããUIæ¹åã®ãã§ãã¯ãªã¹ã
AppSheetã¢ããªããäœã£ãŠçµãããã«ãããçŸå ŽãèªãåãUIãžãšæ¹åããããã®å ·äœçãªã¹ãããããå±äººåæé€ã®èŠç¹ãããã§ãã¯ãªã¹ãã«ãŸãšããŸããããã®ãªã¹ããèŠãªãããããªãã®AppSheetã¢ããªãèŠçŽããŠã¿ãŠãã ãããä¿åããŠã瀟å ã§ã®è°è«ã®å©ãå°ã«ããŠãã ããã
å ¥åé ç®ã¯æ¬åœã«å¿ èŠãïŒïŒåŒãç®ã®çŸåŠã培åºãã
çŸå Žã«ãæžããäœæ¥ã極åãããªãã
éžæè¢ïŒEnumïŒãã¹ã€ããïŒToggleïŒãæ¥ä»ããã«ãŒïŒDate pickerïŒã§ãéžã¶ãã«çœ®ãæããã
ããŒã³ãŒããQRã³ãŒããNFCã¿ã°ã§èªåå ¥åã§ããé ç®ã¯ãªããïŒ
GPSã§å Žæãèªåèšé²ã§ããªããïŒ
以åã®ããŒã¿ããä»ã®ããŒã¿ããèªåã§åŒã£åŒµã£ãŠããããªããïŒïŒåç §èšå®ïŒ
ãã¿ã³ã¯ãè»æèŠªæãµã€ãºããïŒïŒçŸå Žã®æäœæ§ãæåªå
ã¹ããç»é¢ã§ãè»æãããŠããŠãè¿·ããæŒãããµã€ãºã»äœçœ®ã«é 眮ãããŠãããïŒ
ç¹ã«äœ¿çšé »åºŠã®é«ããã¿ã³ã¯ãç»é¢äžéšãªã©ã¢ã¯ã»ã¹ããããå Žæã«ãããïŒ
衚瀺ããŒã¿ã¯ãçŸå Žã®å°å³ããïŒïŒä»ãäœãå¿ èŠããæç€ºãã
çŸå Žã®äººããä»ãç¥ãããæ å ±ãããããç»é¢ã«ãããããã衚瀺ãããŠãããïŒ
ããšãã°ãæ åœè ããšã®é²æç¶æ³ã仿¥ã®äœæ¥äºå®ãåšåº«ç¶æ³ãªã©ãçŸå Žã®ãå°åž³ãããå ±æã¡ã¢ãã®åœ¹å²ãæãããŠãããïŒ
äžèŠãªæ å ±ã¯é衚瀺ã«ããæ¬åœã«èŠãã¹ãããŒã¿ã ããèŠããŠãããïŒ
æ¿èªã®é¢æã¯ãã¯ã³ã¿ããããïŒïŒã¹ããŒããšéææ§ã远æ±
æ¿èªãããŒãå¿ èŠãªå Žåãè€éãªæ¿èªã®é¢æã«ãªã£ãŠããªããïŒ
äžåžã¯ã¯ã³ã¿ããã§æ¿èªã§ãããïŒ
æ¿èªåŸ ã¡ã®ä»¶æ°ãäžç®ã§åãããããã«ããã¯ã«ãªã£ãŠããªããïŒ
å±äººåBefore/AfterïŒèª°ã§ã䜿ããã·ã¹ãã ãžã®é²å
BeforeïŒå±äººåã®éïŒ: çŽã®äŒç¥šæãå人ãã¹ã¯ã®åŒãåºãã«ç ããExcelå°åž³ã¯æ åœè ã®PCã«ããå ¥ã£ãŠããããç¹å®ã®äººããæ¬¡ã®äœæ¥ãžã®ãããã³æž¡ãããã§ããªããç¹å®ã®ç¥èãçµéšãæã€æ åœè ãããªããã°æ¥åãæ»ããæ¥ãªæ¬ å€ã§äœæ¥ã¬ãŒã³ãåæ»ãããããã®äººã«èããªããšããããªãããšããç¶æ³ãåžžæ åã
AfterïŒæ å ±å ±æã®é«éã¬ãŒã³ïŒ: AppSheetã¢ããªã«å šãŠã®èšé²ã鲿ããªã¢ã«ã¿ã€ã ã§å ±æããã誰ã§ãææ°æ å ±ããçŸå Žã®å°å³ãã®ããã«ç¢ºèªã§ãããæ¥åã®ãåŒãç¶ãç·ããæç¢ºã«ãªããæ åœè ã®æ¥ãªæ¬ å€ã§ããä»ã®äººãã¹ã ãŒãºã«ä»£è¡å¯èœãããã®ã¢ããªãèŠãã°ãããããšããç¶æ ãäœããå人ã®ç¥èã«äŸåããªããèªèµ°ããçµç¹ãžãšå€é©ã
ãŸãã¯ããã£ã1ã¶æãããæ¹åãå§ããã
AppSheetã䜿ã£ãUIæ¹åã¯ã決ããŠé£ãããããŸããã倧åãªã®ã¯ããå®ç§ãç®æããªãããšããšãçŸå Žã®å£°ã«è³ãåŸããããšãã§ãã仿¥ããã§ããããšãšããŠãããªãã®AppSheetã¢ããªãäžã€éžã³ãäžèšã®ãã§ãã¯ãªã¹ãã®é ç®ã§ããã£ã1ã¶æãã ããæ¹åã§ããç¹ãèŠã€ããŠã¿ãŠãã ããã
äŸãã°ããå ¥åé ç®ãå€ãããããšæãããªããå¿ é ã§ã¯ãªãé ç®ãäžæçã«é衚瀺ã«ããŠã¿ãããããã¯ãããã¿ã³ãæŒãã«ããããªãããã®ãµã€ãºãå°ã倧ããããã ãã§ãæ§ããŸããããã®å°ããªäžæ©ããçŸå Žã®åå¿ãå€ããã¢ããªã®æŽ»çšçãåçã«åäžããããã£ããã«ãªããŸããããªãã®æã§ãAppSheetããäœã£ãŠçµãããã®ããžã¿ã«å»å¢ãããçŸå Žãèªèµ°ãããçããã·ã¹ãã ããžãšé²åãããŸãããã
ãã®UIæ¹åã®ææ³ã¯ãè£œé æ¥ã®çŸå Žæ¹åã§ææãäžããŠããç§ã®çµéšã«åºã¥ããŠããŸããç¹ã«çŽã®æ¥å ±ãæ€æ»èšé²ãæ£åžãã§ãç³ãšExcelã®æŠå Žãã«ããæ¹ã¯ãããã«å ·äœçãªå®è·µæé ãç§ã®èæžã§åŠã¹ãŸãã
ç§ãå·çãããè£œé æ¥ãã ãŒãåã·ã¹ãã éçº: çŸå Žæ¥å ±ã»QCã»æ£åžã»å䟡管çãAppSheetÃGASã§äžæ°ã«ããžã¿ã«åãã§ã¯ãAppSheetãšGoogle Apps ScriptïŒGASïŒã䜿ãã補åãã¹ã¿ã»å·¥çšå°åž³ãåºç€ã«ãäœæ¥æ¥å ±ãQCã»æ€æ»èšé²ãæ£åžã»åšåº«ç®¡çãèšåç¹æ€ãåºè·ã»ãã¬ãŒãµããªãã£ãå䟡ããã·ã¥ããŒããæ®µéçã«ã€ãªãæé ãæŽçããŠããŸããæåã¯æ¥å ±1ã¢ããªãå°äººæ°ã§è©Šããå ¥åã»åæã»æ¿èªã»éèšã確ãããŠããæ¬¡ã®æ¥åãžåºããé²ãæ¹ã§ãã
ãã®æ¬ã¯Kindle Unlimited察象ã§ããäŒå¡ã®æ¹ã¯è¿œå æéãªãã§èªããŸãã®ã§ããã²æã«åã£ãŠã¿ãŠãã ãããããŒãåããšã¯ç¡æè©Šäœãæ¢åå¥çŽã®æŽ»çšãæããŸããæ¬çªå©çšã®å¥çŽæã»ç«¯æ«éä¿¡è²»ã»èšèšæè²ä¿å®ã®å·¥æ°ãŸã§ç¡æãšæ¡å ãããã®ã§ã¯ãããŸããã
ãŸãã¯å°ããäžæ©ãèžã¿åºãããšããå§ããŸãããããããŠãæ¹åãé²ãããããã²ãã®èšäºã®ã¹ããã³ã¡ã³ãã§æããŠãã ããããããªãã®ãæä»€æ®æ¹ããªæ¹åããä»ã®èª°ãã®åžæã«ãªããŸãã
#AppSheet #UIæ¹å #ããŒã³ãŒã #æ¥åæ¹å #DX #è£œé æ¥ #å 補å #GWS #GoogleWorkspace #è°äºé²
å®æè³Œèªãã¬ãžã³: ãGWSÃAppSheetïœéçºè²»ãŒãã®ãå 補åãDXã
ããç¥ãããçŸå ŽDXéå Žãã£ãŠãŸã
GAS/AppSheet ã®ãã³ãã¬é åžãšè³ªåæ²ç€ºæ¿ããã¡ã³ããŒã·ããã§å ¬éããŠããŸãã
çœåž¯ïŒÂ¥980/æïŒ: äŒå¡éå®èšäºã®èªã¿æŸé¡ïŒè³ªåæ²ç€ºæ¿ïŒãã³ãã¬éïŒã³ããŒããŠäœ¿ããGAS/AppSheetïŒ ãçœåž¯äŒå¡ç¹å žãååã®ã¿30åã®ç¡æçžè«äŒããå©çšããã ããŸããããã¡ã®çŸå Žã§äœããæãã€ããã°ãã?ããäžç·ã«æŽçããå Žã§ãã
é»åž¯ïŒÂ¥49,800/æïŒ: DXãèªèµ°ã§ããäŒç€Ÿã«å€ãã䌎走å¥çŽãçžè«ã»èšèšã»éçºã»AIå°å ¥ãŸã§ãçŸå Žã«å ¥ãäžç·ã«æŠããŸã