BASES - Absolute Progress Bars

1 min read

Setup

  • You need two numeric properties (e.g. estimatedEffort and currentEffort) in your notes
  • In you base, click on Properties, Add Formula, and give it a name (e.g. fProgressPct)
    • Copy/paste the first code snippet from below
  • Create another property (e.g., fProgressTxt)
    • Copy/paste the second code snippet from below
  • Create another property (e.g., fProgressBar)
    • Copy/paste the third code snippet from below
  • You can replace the icons in the formula with whatever you prefer

Result

You get a view like this: Bases table with seven notes showing progress percentage and block-character progress bars

Code

Snippet 1 - fProgressPct

progress / 100

Snippet 2 - fProgressTxt

if(formula.fProgressPct> 0, (formula.fProgressPct * 100).round(), "0") + " %"

Snippet 3 - fProgressBar

if(formula.fProgressPct * 10 > 0, "▰".repeat (number(formula.fProgressPct * 10))) + if((formula.fProgressPct * 10).floor() < 10, "▱▱▱▱▱▱▱▱▱▱".slice( 0, 10 - (formula.fProgressPct * 10).floor()), "").toString()

Source