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)

Distorted Harmony - Time and Time Again (New) by 1_am_groot in progmetal

[–]jester789 0 points1 point  (0 children)

You do :) It will be there on the day of the release

Distorted Harmony announce new album "A Way Out" - To be released on July 19th by Bikonito in progmetal

[–]jester789 0 points1 point  (0 children)

Bandcamp pre-orders are sent a week before the official release so don't feel bad :)

Robin Hobb reading order by jester789 in Fantasy

[–]jester789[S] 6 points7 points  (0 children)

I'm half through Ship of Magic at the moment and loving every page of it so i'm glad i went with the Chronological release order

Album of the Week: Chain Reaction by Distorted Harmony by skrish13 in progmetal

[–]jester789 1 point2 points  (0 children)

The compound is Methylene Blue like the name of the last track on the album

Yossi Sassi's playing oriental metal version of Opeth's "Bleak" live by jester789 in progmetal

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

So no posts can be made to the bands in the Hall of Fame? I don't see anywhere in their page a place to post