Assuming you are using LiveCycle Designer 8.X, a quick search in the Help system (F1) for "Calculating sums of fields" revealed detailed instructions.
Hope this helps,
I've got verson 8.2, but I'm assuming that wouldn't change something like this. I went to help on the topic you provided, but it helps with calculations for repeating fields, and not 2 different fields. I do not understand script at all, so I'm just kind of lost....
If you can post your form we'll explain what needs to be done.
Okay, here it is. On page 4, where it says "Room & Board", "Tuition and Fees" and "Total", I'd like the "Total" field is adding Room and Board and Tuition and Fees together automatically as a student puts numbers in the fields..
Then, below it in the larger section of that page, I want to add each field so that the "TOTAL" field at the bottom is a grand total of each amount added.
Also, are my fields for dollar amounts correct? Is there a different way I should be formatting them?
I'm sorry... I'm all about WYSIWYG--this script stuff is Greek to me... Thanks in advance for your help!!!!!!
Okay, here it is. On page 4 at the top, I want "Room and Board" and "Tuition and Fees" to automatically add in the "Total" field.
While we're at it, in the section below that, I want all of the figures to tally into the big "Total" box at the bottom.
Should I be using a special-designed field for dollar amounts, or is what I'm doing okay?
Sorry, I enjoy WYSIWYG... this stuff is all Greek to me. Thanks in advance for your help!!!!
Okay, here it is. On page 4 at the top, I want "Room and Board" and
"Tuition and Fees" to automatically add in the "Total" field.
While we're at it, in the section below that, I want all of the figures
to tally into the big "Total" box at the bottom (other than the info in
the section above it).
Should I be using a special-designed field for dollar amounts, or is
what I'm doing okay?
Sorry, I enjoy WYSIWYG... this stuff is all Greek to me. Thanks in
advance for your help!!!!
There are numerous ways to do this. One way to get this working is to make sure all these fields are numeric. Put the following piece of code in the calculate event of the 'Total' field:
Okay, I'm REAL close (I think). I made the script
this.rawValue = xfa.resolveNode("RoomBoard").rawValue + xfa.resolveNode("TuitionFees").rawValue;
But when I put "100" in one field and "100" in the second field, the "Total" field read "100,100" and not "200"...
Am I almost there??
Change the type of all three fields to numeric. Highlight each field and in the Object window, on the Field tab, pull down the Type dropdown and select "Numeric Field".
Thank you, thank you!
Sheesh, this stuff is not easy for me... trying to change the color of a field is like rocket science for some reason... I'm sure I'll get the hang of it.
Sorry, another question.
I did the same with the fields below to add them all together and used the following script (based on binding name updates):
this.rawValue = xfa.resolveNode("ParentsContribution").rawValue
+ xfa.resolveNode("Gifts").rawValue ;
but I'm not getting a total in the "Total" field. I've made all fields numeric and the "Total" field read only, too.... thoughts?
Your statement must be on a single line and you do not need an xfa.resolveNode so it should look like this:
this.rawValue =ParentsContribution.rawValue + AnticipatedSummerEarnings.rawValue + StudentAssets.rawValue ........
Did everything as you said, but the following message comes up
(see attached image)
"Line 2, Column 45" occurs where the first "+" is...
Am I missing something? I don't see any attachments to your messages.
I don't have an attachment for any of your posts. Make sure you're using the Attach Files box and Browsing for your form.
Hmmm... Did that, but there were error messages, so maybe it didn't go through. I'll try via e-mail instead. Does this work? (sorry for all the trouble, and ignorance)....
Don't know about email. You can't post .xdp files, so if that's the extension on your form it won't work. Try renaming it to .xxx and posting.
it's a .tds file ... I hit "browse" and am attaching it. Does it work now?
There is still no attachement. Can you save it as a PDF file and attach.
Sorry for all the trouble. I am trying to attach the page as a PDF file. If you can retrieve it, below the section where it says "Please refer to the financial aid award package letter sent to you by your school to complete this section. What other sources of financial assistance do you have available to you to put toward funding your education?" is where I need the help. I have the following script written for it, based on names I gave some of the fields:
this.rawValue =ParentsContribution.rawValue + AnticipatedSummerEarnings.rawValue + StudentAssets.rawValue + CollegeFinancialAidOffer.rawValue + OtherScholarship1.rawValue + OtherScholarship2.rawValue + YourJob.rawValue + OhioInstructionalGrant.rawValue + OhioCollegeOpportunityGrant.rawValue + OhioChoiceGrant.rawValue + PellGrant.rawValue + SupplementalEducation.rawValue + AcademicCompetitiveness.rawValue + Loans.rawValue + WorkStudy.rawValue + Gifts.rawValue;
Let me know if you don't receive the PDF...
help.pdf 17.7 K
OK it attached this time but it was saved as a static form and has no scripts. Open your original file and when you "Save as" select Save As Type "Adobe Dynamic XML Form (*.pdf). Then re-attach the file.
1 person found this helpful
PERFECT!! Oh, I'm such a novice... thank you, everyone who has helped!!!!