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

Formulas to take answers from one multiple-choice grid to another in Adobe Forms

New Here ,
Nov 01, 2023 Nov 01, 2023

Copy link to clipboard

Copied

Hi,

I need to create a form that begins as one multiple choice grid with 4 columns of possible answers A to D (I am ok with this part).

 

Then I need to calculate the total number of answers in each column (not the values of those answers) and have those show up at the bottom of each column.

Then I need each answer from the first grid, transferred to a second grid.

E.g on the first grid, answer selected is 1C. So on the second grid, row 1, column C, correlates with a value of 2. So I need this box selected or checked in the second grid.

 

Then, the values from each column in the second grid need subtotals, and an overall total.

Please help!

Thank you so much.

TOPICS
How to , PDF forms

Views

118

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 ,
Nov 03, 2023 Nov 03, 2023

Copy link to clipboard

Copied

LATEST

Unfortunately, adding colums of mutually exclusive radio buttons is not straight forward. 

I'll assume that the export values of the radio button is the same as the choices you've listed "A" - "D"

The radio button groups will need to be named in a way that can be automated, such as "Answer.Row1", "Answer.Row2". 

 

The custom calculation script for the total field on the first column must check for "A" values

 

var nSum = 0;

this.getField("Answer").getArray().forEach(function(a){if(a.value == "A") nSum++;);

event.value = nSum;

 

 

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

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