Counting CheckBoxes in Canvas

Counting Sub Lists

Freerk

Explore

Counting CheckBoxes

in a canvas column

Christiaan Huizer

Based on a question in the community:

⁠

How to check if all checkboxes in a canvas are checked? 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 community.coda.io⁠

⁠

JSON Parser Online to parse JSON Secure JSON Parser is an online JSON Parser tool to Parse, Decode and Visualize JSON data in Tree view. JSON Parser online updated in 2022. jsonformatter.org⁠

⁠

and this kind of back ground info is useful:

⁠

JSON Full Form is JavaScript Object Notation JSON Full form is JavaScript Object Notation. It is a format that Douglas Crockford created because XML and other data formats were too verbose and not human-readable enough. A JSON object is a collection of name/value pairs where the names are strings, and the values can be strings, numbers, booleans, nulls, or even other objects. JSON is very popular in Web APIs because it has less overhead than XML and doesn’t require any declaration. codebeautify.org⁠

⁠

How to Coda with JSON — Extra Bringing data in and distributing it over rows huizer.medium.com⁠

⁠

Table

Table

Name

tasks

step0

step1

step2

trueCountMain

listCount

Checkbox

allInOne

row 1

invoicing new client

calling supervisor

planning day

Testing Freerk logic

{"type":"slate","root":{"children":[{"alignment":"Left","children":[{"text":"invoicing new client"}],"id":"cl-grid-6wGfsPxNcz::i-EUTm8rpWUh::c-vL52NrhYBL-0","lineLevel":0,"style":"CheckboxList","type":"Line","isChecked":true},{"id":"cl-DqiLUBMMO4","type":"Line","style":"CheckboxList","children":[{"text":"calling supervisor"}],"alignment":"Left","lineLevel":0,"isChecked":true},{"id":"cl-iaTmXg6MBw","type":"Line","style":"CheckboxList","children":[{"text":"planning day"}],"alignment":"Left","lineLevel":0},{"id":"cl-LhA-3kqt8o","type":"Line","style":"Paragraph","children":[{"text":""}],"alignment":"Left","lineLevel":0},{"id":"cl-Ry3J-o5jC4","type":"Line","style":"H3","children":[{"text":"Testing Freerk logic"}],"alignment":"Left"}],"normalizationOpsQueue":[]}}

CheckboxListCheckboxListCheckboxListParagraphH3

truetrue

row 2

breakfast

writing

reading

running

lunch

adding additional content

trying stuff

writing H3

{"type":"slate","root":{"children":[{"alignment":"Left","children":[{"text":"breakfast"}],"id":"cl-grid-6wGfsPxNcz::i-4LW20XP1xj::c-vL52NrhYBL-0","lineLevel":0,"style":"CheckboxList","type":"Line","isChecked":true},{"id":"cl-iMHMT8wDW8","type":"Line","style":"CheckboxList","children":[{"text":"writing"}],"alignment":"Left","lineLevel":0,"isChecked":true},{"id":"cl-Hv6ZBcIte5","type":"Line","style":"CheckboxList","children":[{"text":"reading"}],"alignment":"Left","lineLevel":0,"isChecked":true},{"id":"cl-iArzMyxdHy","type":"Line","style":"CheckboxList","children":[{"text":"running"}],"alignment":"Left","lineLevel":0,"isChecked":true},{"id":"cl--Q9wGftTp9","type":"Line","style":"CheckboxList","children":[{"text":"lunch"}],"alignment":"Left","lineLevel":0,"isChecked":true},{"id":"cl-yhXELRXSqb","type":"Line","style":"Paragraph","children":[{"text":""}],"alignment":"Left","lineLevel":0},{"id":"cl-vP6Sxdd-5b","type":"Line","style":"Paragraph","children":[{"text":"adding additional content"}],"alignment":"Left","lineLevel":0},{"id":"ecb-BnNdb3z4ol","type":"CodeBlock","children":[{"id":"cl-BT9IL2wjlW","type":"Line","style":"Code","children":[{"text":"trying stuff"}],"alignment":"Left"}],"language":"PlainText","lineLevel":0},{"id":"cl-zVq46_cF7G","type":"Line","style":"H3","children":[{"text":"writing H3"}],"alignment":"Left"},{"id":"cl-mf3scInqXa","type":"Line","style":"Paragraph","children":[{"text":""}],"alignment":"Left","lineLevel":0}],"normalizationOpsQueue":[]}}

CheckboxListCheckboxListCheckboxListCheckboxListCheckboxListParagraphParagraphCodeH3Paragraph

truetruetruetruetrue

row 3

calculating business case

study JSON

study JS

{"type":"slate","root":{"children":[{"alignment":"Left","children":[{"text":"calculating business case"}],"id":"cl-grid-6wGfsPxNcz::i-HnFJoo4-LG::c-vL52NrhYBL-0","lineLevel":0,"style":"CheckboxList","type":"Line"},{"id":"cl-eBw-f6Zq1S","type":"Line","style":"CheckboxList","children":[{"text":"study JSON"}],"alignment":"Left","lineLevel":0},{"id":"cl-dJIk6Lmp7p","type":"Line","style":"CheckboxList","children":[{"text":"study JS"}],"alignment":"Left","lineLevel":0}],"normalizationOpsQueue":[]}}

CheckboxListCheckboxListCheckboxList

There are no rows in this table

⁠

Want to work with me? All details below: ⤵️

⁠

Loading coda.io⁠

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.