Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In this order form Acrobat is going to do the math for us. So if for example I order two bottles of the Balsamic Oil at $10 a bottle, the line total fills in and so does the grand total. If I order three bottles of the Sesame Ginger Oil at $11 a bottle, the line total and the grand total take care of themselves. So let's see how all that is set up. I'm going to go to the beginning file and you can see all the form fields.
The grand total is going to be the total of all the total fields, total.0.1, so forth, so when I go to Calculate, I can just say value is the sum of the following fields and I could pick individually total.0.1 so forth and so on, but they're a family and I can talk to the whole family by just checking total much easier, click OK and close, there we go. Now I have to fix each line total, so for total.0 it's going to be the product of number.0 and price.0, so I click the Pick button and choose number.0 and scrolling down and also choose price.0. I don't have to exit this dialog to doctor all the other fields, so I choose total.1 and I can quickly say it's the product of number.1 and price.1, it's a little bit tedious, but it's pretty easy to do, so one more just to kind of prove the point, it's the product of, and this is going to be number.2 and price.2. Right about this time you're probably thinking, well, couldn't I have just fixed that first row and then duplicated all the rows and the totals would have taking care of themselves? Not quite.
If I set up that total.0 all the rest of them are going to have the same math, they're going to multiply that first line. So yeah you do have to handle each line total separately. It's not that tough it's just a little bit tedious, so let's see if the math works. I'll Close, go back to my Hand Tool, and I'll just enter numbers and prices just arbitrarily to see what's going on, okay that works just fine, 3 and A:, just the grins. But some thing is going right down here in my grand total, why is that? It's because that's doing its math before these line totals have finished theirs, and it's because I set up the math in that grand total field first which I wouldn't normally do, but I did it so that things would go all right and you'd see how to fix it, because if nothing goes wrong we don't learn quite as much.
So what I need to do is leave everything where it is, but change the order in which the calculations take place, it's easy to do once you find it the control is a little bit buried. We go to Tools and Forms>Edit>Other Tasks>Edit Fields and there it is finally down in the basement Set Field Calculation Order, so it's Other Tasks>Edit Fields>Set Field Calculation Order. You notice because grand total was edited first, it's going to be the first operation in the list, we need for it to be the last operation in the list, with it chosen, I just click the Down button until it's at the end of the pile, click OK, and then I can Close Form Editing and test.
I'm going to have to refresh this form, it doesn't refresh itself, again we're still just testing, so I'll just reset and let's just make sure everything works before we close this out, line total is good, my grand total is good, there, now my grand total is working because it's the last field to perform its calculations. So yes, it's a little bit tedious, but it's actually pretty easy to set up, and really Acrobat is doing the heavy-lifting for you.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98529 Viewers
80 Video lessons · 141529 Viewers
59 Video lessons · 59886 Viewers
52 Video lessons · 73077 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.