Notion 笔记 Formula 常用代码


用时

format((timestamp(prop("结束日期")) - timestamp(prop("开始日期"))) / 1000 / 60 / 60 / 24) + " 天"

进度

join("", if(largerEq(multiply(divide(prop("已看"), prop("集数")), 100), 10), slice("????????????????????", 0, multiply(floor(divide(multiply(divide(prop("已看"), prop("集数")), 100), 10)), 2)), ""), if(largerEq(multiply(divide(subtract(prop("集数"), prop("已看")), prop("集数")), 100), 10), slice("??????????", 0, multiply(ceil(multiply(divide(subtract(prop("集数"), prop("已看")), prop("集数")), 10)), 2)), ""), " ", slice(format(multiply(divide(prop("已看"), prop("集数")), 100)), 0, 5), "%")