ãð ãã³ãã¬é åžãNotion ã§ãµãã¹ã¯ã»åºå®è²»ã管çãã
ä»åã¯ããã¡ãã®ãã€ãŒãã§çŽ¹ä»ããå 容ã®æ·±å ããšããŠãNotion ã䜿ã£ã家èšç®¡çã«ã€ããŠè§£èª¬ããããšæããŸããå㯠Notion ã§èªåã®èº«ã®åãã®ãéã®æŽçãããçšåºŠããããã«ããŠããŠãæè³ãµããªãããµãã¹ã¯ã»åºå®è²»ããåå ¥ãã®ç®¡çã« Notion ã®ããŒã¿ããŒã¹ã䜿ã£ãŠããŸãã
ä»åã®èšäºã§ã¯ãåæ¯ç®¡çã®äžéšããµãã¹ã¯ã»åºå®è²»ãã®ç®¡çã«ã€ããŠè§£èª¬ããŠãããŸããäŸã«ãã£ãŠãèšäºã®æåŸã«åã䜿ã£ãŠãããã®ããã®ãŸãŸãã³ãã¬ãŒãåãããã®ãèŒããŠããã®ã§ããããããã°åèã«ããŠã¿ãŠãã ããã
åºå®è²»ã»ãµãã¹ã¯ç®¡çããŒã¿ããŒã¹
ã§ã¯ã以äžã§è©³ãã解説ããŠãããŸãããã
ððð
åèšé¡ã衚瀺ããŠæ¯æã®åºå®è²»ãå¯èŠåãã
Notion ã®äŸ¿å©ãªæ©èœã®ã²ãšã€ã«ãããŒã¿ããŒã¹ã®åèšå€ã楜ã«èšç®ããŠããããšãããã®ããããŸããæ¯åºé¡ã®èšç®ãšéåžžã«çžæ§ãè¯ããåãæçšããŠããæ©èœã®äžã€ã§ãã
ããŒãã«ã®äžéšã«åèšå€ã衚瀺ããããšãã§ãã
ããŒãã«ã®äžçªäžã«ãCalculate ãšããé ç®ãããŠã¹ããããŒãããšç»å Žããã®ã§ãããã¯ãªãã¯ããŸãããããšããããé ç®ã衚瀺ãããã®ã§ããããã®äžããåèšå€ãè¡šã Sum ãéžæããŸããããã§åèšé¡ã衚瀺ãããããšãã§ããŸãã䟿å©ã§ããã
Calculate ãéžæãããšãã®ããã
ððð
æéæããšå¹Žéæããããããã£ã§åãã ïŒLinked Database ã®æŽ»çšïŒ
ãµãã¹ã¯ãµãŒãã¹ã®äžã«ã¯ãæããšã«èª²éãããã®ãšå¹Žéã§èª²éãããã®ã®äºçš®é¡ããããšæããŸããåã¯ãã®2ã€ãåãããŒã¿ããŒã¹ã§ç®¡çããŠããã®ã§ãããåæã«èŠããŠããŸããšèšç®é¡ãçã£ããããŠå€§å€ãªã®ã§ãåé ã®ã¹ã¯ãªãŒã³ã·ã§ããã®ããã«ããŒã¿ããŒã¹ã暪ã«äžŠã¹ãŠè¡šç€ºããããã«ããŠããŸãã
Linked Database
æ¬äœã¯äžã€ãªã®ã§ãããåãããŒã¿ããŒã¹ãå¥ã®èŠãæ¹ãã§ãããšãã Notion ã® Linked Database ãšããæ©èœ ã䜿ã£ãŠããŸããæ¬äœã¯å·Šã§ãå³ã¯ Linked Database ãšãªã£ãŠããŸããïŒã¡ãªã¿ã« Linked Database ã¯ãã¹ã©ãã·ã¥ã³ãã³ããã /linked ãšå
¥åããæ¬äœã®ããŒã¿ããŒã¹åãå
¥åããŠæ€çŽ¢ãéžæããããšã§äœæã§ããŸãã以äžã¹ã¯ãªãŒã³ã·ã§ããåç
§ïŒ
Linked Database ãã¹ã©ãã·ã¥ã³ãã³ãããäœæ
ãåºå®è²»ããšå ¥åããŠã該åœã®ããŒã¿ããŒã¹ãæ€çŽ¢
å°ãè±ç·ããŠããŸããŸããããããã§ããŒã¿ããŒã¹ã2ã€ïŒæ¬äœã¯1ã€ïŒäœæããããšãã§ããŸãããããšã¯ãããããã®ããŒã¿ããŒã¹ã«ããããã£ã§ãã£ã«ã¿ããããŠããã ãã§ãã
ããŒã¿ããŒã¹ã®ããããã£ã«ãæé¡ãã幎éããéžæã§ããããããã£ãè¿œå ããŠãããŒã¿ããšã«ã©ã¡ãã®æ¯æãæ¹åŒãªã®ããéžæããããã«ããŸãã
æé¡ / 幎éãéžæã§ããããããã£
ãã®åŸãããŒãã«ã® Filter ã®ç®æããããæé¡ãã®ã¿ã衚瀺ããããã«ãã£ã«ã¿ããããŸããããã§æé¡æ¯æãã®ãã®ã®ã¿è¡šç€ºããããšãã§ããããã«ãªããŸãããåæ§ã«ã幎éæãã®ãã®ã¯ã幎éãã®ã¿ã衚瀺ããããã«ãã£ã«ã¿ããããŠããã° OK ã§ãã
ããŒãã«ã§ãæé¡ãã®ã¿è¡šç€ºããããã«ãã£ã«ã¿
ððð
解çŽæžã¿ã®ãã®ã«ã¯ãã§ãã¯ãå ¥ããŠé衚瀺ã«ïŒãã£ã«ã¿ïŒãã
ãããã«ã解çŽæžã¿ã®ãã®ãé衚瀺ã«ããŸããããããã§ã¯ã解çŽæžã¿ããããã£ãäœæããããã«ãã§ãã¯ãå ¥ããããšã§è§£çŽããããšã瀺ãèšèšã«ããŸãã
ã解çŽæžã¿ãããããã£
ãããŠãäŸã«ãã£ãŠããŒã¿ããŒã¹ã®ãã£ã«ã¿æ©èœã䜿ããã解çŽæžã¿ãã®ãã®ãé衚瀺ã«ããŸããããã»ã©ã®æ¡ä»¶ãšã¯ããã€ãã§æ¡ä»¶ãçµãããã®ã§ãAndãã§æ¡ä»¶åŒãç¹ããŸãã
ã解çŽæžãã§ãªããã®ã®ã¿ã衚瀺ãã
å®æ
以äžã§åºå®è²»ã»ãµãã¹ã¯ç®¡çããŒã¿ããŒã¹ã®å®æã§ãã
ððð
ãŸãšã
ããããå ã¯
ãã®èšäºãæ°ã«å ¥ã£ãããµããŒããããŠã¿ãŸãããïŒ