• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Sum Selected Radio Button Values in Total Field

New Here ,
Jun 10, 2024 Jun 10, 2024

Copy link to clipboard

Copied

I'm fairly new to creating "complex" fillable PDFs and am struggling with a basic sum formula. Any ideas?

 

Here's the overview:

There are 6 questions (and therefore 6 radio button groups) - I'm trying to sum the radio button selection for each of the questions in my TOTAL SCORE field. When I go to the calculate tab "Value is the SUM (+) of the following fields:" it does not have the option to add any of my radio buttons or groups. Is there a better, or 'standard' way of doing this? 

 

Here is how my questions are set up:

  • RTQ - Question 1
    • 18
    • 12
    • 6
    • 0
  • RTQ - Question 2
    • 0
    • 8
    • 12
    • 18
  • RTQ - Question 3
    • 0
    • 5
    • 10
    • 15
  • RTQ - Question 4
    • 15
    • 10
    • 5
    • 0
  • RTQ - Question 5
    • 19
    • 12
    • 7
    • 0
  • RTQ - Question 6
    • 15
    • 8
    • 0
  • TOTAL SCORE
TOPICS
How to , PDF

Views

48

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 11, 2024 Jun 11, 2024

Copy link to clipboard

Copied

They should be there. What do you see in the Fields Selection dialog?

And yes, there are other ways of doing it, but the SUM command should work for you...

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 11, 2024 Jun 11, 2024

Copy link to clipboard

Copied

The built-in options should work, but in case it doesn't for some reason, you can use this custom calculation script:

var total = 0;
for (var i=1; i<=6; i++){
var f = this.getField("RTQ - Question "+i).valueAsString;
if(f !== "Off")
total += Number(f);}
event.value = total;

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 11, 2024 Jun 11, 2024

Copy link to clipboard

Copied

Update: I figured it out - originally the form was prepared for e-sign. I removed e-sign options to do the calculations and kept editing. All I had to do was close the program and reopen it. The more you know!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 11, 2024 Jun 11, 2024

Copy link to clipboard

Copied

LATEST

Yes, that would do it. In the future, do not tick the box that says "This document requires signatures" when creating the form, as that converts the file to an Adobe Sign form, which has limited functionality compared to a "normal" PDF form.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines