Participating Frequently

Question

Calculation Help - Scoring Sheet

Forum|Forum|2 years ago
July 24, 2023
3 replies
2993 views

JavaScript Newbie here...

I am attempting to automate the attached scoring sheet. This is a Federal form, so I cannot change the format. I am using radio buttons for each question as only one choice can be selected. The first 3 fields have unique values assigned and that value varies based on the specific question. However, the 4th field "Did Not Occur" retains the same value as the "Good" field - either 3, 6, or 9 depending on the question. In an attempt to differenciate between the two fields, I gave the "Did Not Occur" fields values adding a .1.

I need to total the value of all questions with a score of "Did Not Occur" separately from the other scores, that number must be subtracted from the "Maximum Total Score" (192). I have added an "Adjusted Max Total Score" field for that number. Then, the Adjusted Max is used to calculate the "Percent Score."

Here are the calculation instructions from the manual:

TYIA!

ETA_Handbook_No_382.pdf

This topic has been closed for replies.

C

Cathy208Author

Participating Frequently

Here's the script that I came up with, but I am not getting any results. I've been combing through the community questions for 3 days now, I just have so many questions. Can I format my "Did Not Occur" answers differently? Could someone help me troubleshoot?

var total = 0;

var n = 0;

for (var i=1; i<=31; i++)

{

if (this.getField("Score"+1).value == 3.1)

{ event.value = 3;}

else if (this.getField("Score"+1).value == 6.1)

{ event.value = 6;}

else if (this.getField("Score"+1).value == 9.1)

{ event.value = 9;}

else

{ event.value = nSum;}}

Thom Parker

Community Expert

Excellent Try!! You're script is close, but needs some fixes in order to operate. For example, variables named "Total" and "n" are declared, but never used. A variable named "nSum" is used, but never declared. And the loop isn't doing anything because the same field is being aquired everytime around the loop. But you've managed to put together a reasonal structure.

Here's an update:

var total = 0, nScore;

for (var i=1; i<=31; i++) 
{
   nScore = this.getField("Score"+i).value
   if (nScore  == 3.1)
     total  += 3;
   else if (nScore  == 6.1)
     total  += 6;
   else if (nScore  == 9.1)
     total  += 9;
}
event.value = total;

Your first post implies the "3.1", "6.1", and "9.1" are export values from a radio button group. Is this true? if it is, then the the comparison is incorrect. You're not comparing to a number, but to a string. However, it should still work since JavaScript does automatic conversions.

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often

Thom Parker

Community Expert

Hi Thom - I guess I should have tried the script before replying. I am still not getting a result at all. The box is just blank.

Are any errors reported in the console window?

Can you post the form?

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often

maxwithdax

Community Expert

If this is a federal form remember that whatever you implement must also comply with Section 508 Accessibility Requirements.

C

Cathy208Author

Participating Frequently

This is for internal use only. The final scoring is submitted through the Federal Sun system using the totals. I am just trying to make the process easier and (hopefully) eliminate human error with manual calculations.

Thom Parker

Community Expert

Read these articles:

https://www.pdfscripting.com/public/How-to-Write-a-Basic-PDF-Calculation-Script.cfm

https://www.pdfscripting.com/public/How-to-write-an-If-statement.cfm

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often