TDD = Test-Driven Development
// 1,000 Callback
if(prop("Number") > 1000, concat(format(floor(prop("Number") / 1000)), ",", if(mod(prop("Number"), 1000) < 10, "00", if(mod(prop("Number"), 1000) < 100, "0", "")), format(mod(prop("Number"), 1000))), format(prop("Number")))
// 1,000 Callback no over 1,000,000
// -- Mod all number with 1,000,000
if(mod(prop("Number"),1000000) > 1000, concat(format(floor(mod(prop("Number"),1000000) / 1000)), ",", if(mod(mod(prop("Number"),1000000), 1000) < 10, "00", if(mod(mod(prop("Number"),1000000), 1000) < 100, "0", "")), format(mod(mod(prop("Number"),1000000), 1000))), format(mod(prop("Number"),1000000)))
// 1,000,0000 Callback
if(prop("Number") > 1000000, concat(format(floor(prop("Number") / 1000000)), ","), "")
// Final
// -- Concat("1,000,0000 Callback ", "1,000 Callback no over 1,000,000")
concat(if(prop("Number") > 1000000, concat(format(floor(prop("Number") / 1000000)), ","), ""), if(mod(prop("Number"),1000000) > 1000, concat(format(floor(mod(prop("Number"),1000000) / 1000)), ",", if(mod(mod(prop("Number"),1000000), 1000) < 10, "00", if(mod(mod(prop("Number"),1000000), 1000) < 100, "0", "")), format(mod(mod(prop("Number"),1000000), 1000))), format(mod(prop("Number"),1000000))))
// Round number
concat(if(round(prop("Number")) > 1000000, concat(format(floor(round(prop("Number")) / 1000000)), ","), ""), if(mod(round(prop("Number")),1000000) > 1000, concat(format(floor(mod(round(prop("Number")),1000000) / 1000)), ",", if(mod(mod(round(prop("Number")),1000000), 1000) < 10, "00", if(mod(mod(round(prop("Number")),1000000), 1000) < 100, "0", "")), format(mod(mod(round(prop("Number")),1000000), 1000))), format(mod(round(prop("Number")),1000000))))
// If empty
if(empty(prop("Number")), "", concat(if(round(prop("Number")) > 1000000, concat(format(floor(round(prop("Number")) / 1000000)), ","), ""), if(mod(round(prop("Number")), 1000000) > 1000, concat(format(floor(mod(round(prop("Number")), 1000000) / 1000)), ",", if(mod(mod(round(prop("Number")), 1000000), 1000) < 10, "00", if(mod(mod(round(prop("Number")), 1000000), 1000) < 100, "0", "")), format(mod(mod(round(prop("Number")), 1000000), 1000))), format(mod(round(prop("Number")), 1000000)))))
if(prop("Output") == prop("Expected"), "✅ PASS", "❌ FAILED")
สวัสดีครับ วันนี้ผมมาแชร์เทคนิคการเขียน สูตรแบบ ยังไงก็ไม่พลาดแน่ๆ กันครับ
.
เทคนิคที่ใช้ TDD (Test-Driven Development) คือ โดยผมประยุกต์ใช้ใน Notion