Skip to main content
brandonh27939672
brandonh27939672
New Participant
May 12, 2020
Answered

JavaScript Count If Checked

  • May 12, 2020
  • 2 replies
  • 2345 views

I have a page with a grid of checkboxes -- columns and rows. 

 

I'd like a field to the right of the row that gives me just a total of the number of checkboxes checked across the row (checkbox1, checkbox2, checkbox3, checkbox4, checkbox5). 

 

I realize if I want to total up the row's checked boxes the calculation would be the same as if I checked a column's checkboxes, the only difference being how I indicate which fields are being counted conditionally. 

 

Anyone that can help me with this?

 

Thanks in advance! 

This topic has been closed for replies.
Correct answer brandonhull

I figured this out. I solved it by making sure each checkbox had a different exported value other than "Yes". I gave them the exported value of 1.

 Then I had a text field at the end of the row, and at the bottom of the column, that calculated the sum of the corresponding checkbox fields for that row or column. 

2 replies

B
brandonhullCorrect answer
Inspiring
May 20, 2020

I figured this out. I solved it by making sure each checkbox had a different exported value other than "Yes". I gave them the exported value of 1.

 Then I had a text field at the end of the row, and at the bottom of the column, that calculated the sum of the corresponding checkbox fields for that row or column. 

Thom Parker
Thom Parker
Inspiring
May 12, 2020

 

An easy way to count checked checkboxes is to name them so that the checkbox names can be automatically found from the name of the total field.  Then a generic script can be written to automatically generate the names. 

 

For example "Row1_Col1"  "Row1_Col2" "Row1_Col3" ....  "Row1_Total"

 

Do you have any scripting experience?

These are also called table calculations. Serarch for this word on the forum and you'll find other threads that discuss specific code.

You can read more about general form scripting. Watch the video on Field Naming:

https://www.pdfscripting.com/public/PDF-Form-Scripting.cfm

 

 

 

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
B
brandonhull
Inspiring
May 13, 2020

I was logged in with the wrong account when I posted this originally. Replying here with my proper account. 

 

I have limited experience with scripting so I didn't understand your reply, but maybe I should have been a little more clear with my post to begin with. My table ONLY has checkboxes, no fields with numbers. Here's how it looks: 

In that column to the far right, I want to put a numeric field that simply tells me how many boxes were checked across the cooresponding row. Not sure this changes your suggestion to me...

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices