Progress Bar Task List

[Mike_Driscoll]

I have a todo list in a Canvas column and I want my Progress Bar to reflect the amount of boxes checked. Help!

[Christiaan_Huizer]

hi @Mike_Driscoll ,

this is a bit beyond the standard Coda Formula Language, but here you go:

thisRow.tasks._Merge().ParseJSON("*..style,lineLevel,Children,isChecked").WithName(Outcome,
  
  Outcome.Filter(CurrentValue = True())
  
  ).Count()

Cheers, Christiaan

[Mike_Driscoll]

Wow. Thank you. I tried to use the code on the doc I needed it and it’s not. working. Any ideas?

[Melanie_Teh]

@Mike_Driscoll

the dot is missing between merge() and ParseJSON.

For future reference - Red squiggly lines are hints to where the formula went wrong

cheers!
Mel

[Mike_Driscoll]

I got it to work! Thank you