BASES - Absolute Progress Bars

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:

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()