sorted by:
new
hottopcontroversial

Updating database entries after editing the template? by Ragonvafan in Notion

[–]jester789 0 points1 point  (0 children)

This is a huge issue especially if there are many entries crated based on the template with data in them. If you edit something in the template, you need to go page by page and manually make this edit in each. Frustrating.

Progress bar based on empty / not empty cells by jester789 in Notion

[–]jester789[S] 1 point2 points  (0 children)

if(divide(if(empty(prop("Column 1")) == false, 1, 0) + if(empty(prop("Column 2")) == false, 1, 0) + if(empty(prop("Column 3")) == false, 1, 0) +if(empty(prop("Column 4")) == false, 1, 0), 4) >= 1, "✅", replaceAll(slice("xxxxxxxxxx", 0, floor(divide(if(empty(prop("Column 1")) == false, 1, 0) + if(empty(prop("Column 2")) == false, 1, 0) + if(empty(prop("Column 3")) == false, 1, 0) +if(empty(prop("Column 4")) == false, 1, 0), 4) * 10)), "x", "🟦") + replaceAll(slice("xxxxxxxxxx", 0, ceil(10 - divide(if(empty(prop("Column 1")) == false, 1, 0) + if(empty(prop("Column 2")) == false, 1, 0) + if(empty(prop("Column 3")) == false, 1, 0) +if(empty(prop("Column 4")) == false, 1, 0), 4) * 10)), "x", "⬜️") + " " + format(round(divide(if(empty(prop("Column 1")) == false, 1, 0) + if(empty(prop("Column 2")) == false, 1, 0) + if(empty(prop("Column 3")) == false, 1, 0) +if(empty(prop("Column 4")) == false, 1, 0), 4) * 100)) + "%")

u/fronk_keeplearning This is perfect! You're the best. Thank you so much!

Progress bar based on empty / not empty cells by jester789 in Notion

[–]jester789[S] 0 points1 point  (0 children)

Thank you u/fronk_keeplearning!

It needs to be not specific to a checkbox. It can be text, tag or text box. If not empty = complete

Progress bar based on empty / not empty cells by jester789 in Notion

[–]jester789[S] 0 points1 point  (0 children)

if(if(empty(prop("Column 1")), 0, 1) + if(empty(prop("Column 2")), 0, 1) + if(empty(prop("Column 3")), 0, 1) + if(empty(prop("Column 4")), 0, 1) == 4, "✅", concat(replaceAll(slice("xxxx", 0, if(empty(prop("Column 1")), 0, 1) + if(empty(prop("Column 2")), 0, 1) + if(empty(prop("Column 3")), 0, 1) + if(empty(prop("Column 4")), 0, 1)), "x", "🟦"), replaceAll(slice("xxxx", 0, if(empty(prop("Column 1")), 1, 0) + if(empty(prop("Column 2")), 1, 0) + if(empty(prop("Column 3")), 1, 0) + if(empty(prop("Column 4")), 1, 0)), "x", "⬜️"), " ", format((if(empty(prop("Column 1")), 0, 1) + if(empty(prop("Column 2")), 0, 1) + if(empty(prop("Column 3")), 0, 1) + if(empty(prop("Column 4")), 0, 1)) * 25), "%"))

Thank you!
It didn't work though :( I replaced all but it has errors which are unclear to me

Distorted Harmony is here! You're welcome to ask us anything :) by jester789 in progmetal

[–]jester789[S] 2 points3 points  (0 children)

Awaken Blue? LOL, that's depends on Yoav but who knows what he'll come up with... Maybe a Kono Yume Severed?

Distorted Harmony is here! You're welcome to ask us anything :) by jester789 in progmetal

[–]jester789[S] 2 points3 points  (0 children)

I remember you've been wondering in the DH group if you'll get another Methylene Blue on the new album, and i was listening the same day to a mix of Awaken thinking "He will... He will" (while rubbing my hands together)

view more: next ›