Skip to main content
Participating Frequently
November 10, 2019
解決済み

Acrobat Forms - Calculations

  • November 10, 2019
  • 返信数 1.
  • 3530 ビュー

So I've created an Acrobat form, and I want to use the calculate feature for some of the fields, to enter the results into another field. And that's working great. But I also then want to calculate the total from that field plus another field, with results to end up in a third field. And I can't seem to get it to work. 

 

Is it because one of the fields used in the calculation gets its total from other fields as opposed to direct input? 

このトピックへの返信は締め切られました。
解決に役立った回答 try67

Really? From my file, or did you create your own? So you were able to get "Total Fee Write-Off Amount" and "Total OOP Write-Off Amount" to sum into "Total Write-Off Amount" (the third field in the gray bar)? Using the same settings as mine? 


Yes, in my own file. I had a chance to examine your file more closely and I found the issue for this error.

Somehow (my guess is you created the fields in InDesign, not Acrobat), you were able to insert a space at the end of the field name of "Total OOP Write-Off Amount", which causes it not to be picked up by any scripts.

Remove that space and it should work correctly.

返信数 1

try67
Community Expert
Community Expert
November 10, 2019

No, that should not be an issue. The only thing you have to make sure is that the calculation order is correct, ie that the total field is calculated after the fields it uses for its own calculation.

Please specify in what exact way it's not working and we'll help you further with this issue.

NicoleHickman作成者
Participating Frequently
November 10, 2019

The first total field is working correctly, that is, grabbing the sum of figures entered into the input fields. That total field is then followed by another field, which the user needs to enter an amount into manually, and then the third total field should sum the values from the first and second fields. I Googled calculation order, but could not find where to adjust the calculation order in my version of Acrobat, which is Pro DC, latest version. 

 

That third field is not resulting in a total of the prior two. It just remains at zero.

 

So I have essentially four types of fields. The results of the first group, up to seven different fields titled "Write-off amount", should sum together and the total lands in a field titled "Total Fee Write-Off Amount". This field is followed by a field titled "Total OOP Write-off Amount", which the user enters a value into, and then the final field should sum the totals from "Total Fee Write-Off Amount" and "Total OOP Write-off Amount". 

try67
Community Expert
Community Expert
November 11, 2019

The field calculation order can be set via Prepare Form - More - Set Fields Calculation Order.

 

I would recommend you check the JS Console (Ctrl+J) for error messages.

 

Also, if you could share the file with us we could help you fix the issues in it.