Hi,
I am attaching a survey-type form containing 13 statements: for each statement the user chooses from 5 radio button options, and a survey score appears at the end. Steve Walker, on this forum, help alot with this form (see: http://forums.adobe.com/thread/540343?tstart=0).
What I now need to do is add survey statements: the total number would be 36, not the 13 currently.
I have tried to add 2 pages to the form's page 1, so that page 2 has 13 more statements (14-26), and page 3 has 10 more (27-36) so the total on the 3 paqges is 36 statement. The "total" boxes on all 3 pages work OK to total and display each page's score. The difficulty I have is getting a grand total box on the 3rd page to show the total score for all 36 statements.
I've tried adding the individual page totals, but nothing populates into the grand total box:
pseudocode:
var grandtotal = total (on page 1) + total (on page 2) + total (on page 3).
I would appreciate any suggestions for getting this 13 statement form to become a 36 statement form.
Kind Regards,
Solved! Go to Solution.
Views
Replies
Total Likes
The attached contains 3 pages with a total for each page and a grand total on page 3.
Steve
Views
Replies
Total Likes
Hi,
Steve's script for totaling the options/opinions is sweet!
Adding the three individual totals into a grand total is relatively straightforward. In the calculate event of the grand total field you would have the following in FormCalc (the SOM will depend on your naming convention for the pages and objects):
$ = page1.total + page2.total + page3.total
In Javascript it would look like this:
this.rawValue = page1.total.rawValue + page2.total.rawValue + page3.total.rawValue;
If a total field was in a subform, then you would include the name of that subform in the script (eg page1.aSubForm.total). A handy way to reference objects in script is to click into the script editor and then press Control and click the object you want to reference. LC will insert the full SOM into the script for you.
Good luck,
Niall
The attached contains 3 pages with a total for each page and a grand total on page 3.
Steve
Views
Replies
Total Likes
Thanks Niall and Steve.
These gave me leads as to "how to" plus sophisticated scripting examples.
Your help is very much appreciated.
Kind Regards,
saratogacoach
Views
Replies
Total Likes