Count all checkboxes in row without listing each column

Hello. Is there a way to count all the check boxes in a row without having to explicitly state each one?
I will have 135 checkboxes = 135 columns. I would like to count them all (true and false states) without listing them.

Can we use some combination of thisrow, Islogicial() , count() or filter()?

Ultimately want to count them to view the percentage of completion (see image below)

hi @Jessie_Nguyen ,
no there is not
your set up looks like a spreadsheet, but this is not how to make best use of Coda.
you do already have a column for students
and you could have a column containing all questions (135 I guess) per student with a checkbox. This will generate a long table instead of a wide one and in this long table you can filter and count.
courage!
Christiaan

1 Like

Like @Christiaan_Huizer says it’s not currently possible, he’s also giving you a nice alternative approach.

Otherwise, I’ve got a proposition planned out here: New formulas for columns

1 Like

@Jessie_Nguyen : Just to illustrate a little the suggestion @Christiaan_Huizer made earlier, here’s a sample containing 3 pages :innocent:

The 1st page is the page “Students” containing a table called Students used to store the students and their info :blush:

The 2nd page is the page “Questions” containing a table called Questions used to stored the questions and their info :blush: .

I’ve populated that table using the slider you’ll see in the callout and the button next to it, as you seemed to use something like : 1.0, 1.1, 1.2, 1.3, etc… for the names of your questions, well for 30 something questions, that represented a lot of rows to create :sweat_smile:

And, last but not least, the 3rd page is the page “Students & Questions” .

This page also contains a table (Students & Questions) where each row is used to link a student from the table Students to a specific question from the table Questions using 2 single select relations fields.

And this is where a checkbox can be checked or left unchecked.

To populate this table I’ve also created a canvas button which I left at the top of the page “Students” but it can also be done by creating a button field in Students

The button uses the value in the field [Missing Questions per Student] which is there to determine which questions still need to be added to Students & Questions for each student in Students, if any.
And this is done by comparing the actual list of questions in the table Questions to the questions already tied to a student in Students & Questions (with the help of the multi-select linked relation field next to it named Students & Questions which gathers back each specific question tied to a specific student in the table Students) …

This means that if you add a question to the table Questions, only this missing question will be added to Students & Questions and linked to each student in Student… And if you add a student to Students, only this student will be added to Students & Questions and be linked to every question they need to be linked :blush: .

As for counting the amount of checked checkboxes an unchecked ones, this can now simply be done by adding a related column from the linked relation field Students & Questions by accessing the field’s menu and then going to Add related columnCheckboxCount True or Count False

This is what I did for the fields [Checkbox - Count True] and [Checkbox - Count False] in the table Students :blush:

I hope this helps :innocent:

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.