How to check if all checkboxes in a canvas are checked?

[Freerk_Lap]

Hi there, I want to disable a button in a table until all checkboxes in a canvas (in the same row) are checked. Is this possible? The checkboxes are content in the canvas, not in a table.

Cheers,
Freerk

[Christiaan_Huizer]

hi @Freerk_Lap ,
I remember that @Paul_Danyliuk has solved this before, but I could not find it directly so below how I would handle it (but I guess that Paul had a different way).

• First we turn the canvas column into a JSON object
• second we count the checkboxes
• third we note how many of these are checked
• the last step is comparing step 2 & 3

the rest is obvious
cheers, Christiaan

[Agile_Dynamics]

@Christiaan_Huizer, bravo!

[Freerk_Lap]

You are a god-send Christiaan! Your articles on Medium keep popping up too. Its an honor to have you solve my riddle

[Christiaan_Huizer]

Thanks for the compliments @Freerk_Lap
This is the article I wrote about your question:

How to Coda with JSON — Canvas

enjoy, Christiaan

[Freerk_Lap]

@Christiaan_Huizer I made a slight adaptation in your script to account for other content in the canvas. Using …style pulls in all elements, so I first convert the parseJSON into a list, then filter that list for items that contain CheckboxList.

listcombine(thisRow.[Definition of Ready]._Merge().ToText().ParseJSON("$..style")).Filter(Contains(CurrentValue, "CheckboxList")).Count()

[Christiaan_Huizer]

interesting and very well done. As often stated: in Coda is everything a list and once you see this, it cannot be unseen. I adapted my blog and document accordingly:

Freek · Counting CheckBoxes in Canvas