if/then calc for multiple listings in PDF Form

Question

I need to build a calculation that will look at the field "listed or unlisted" which is a dropdown list with three choices; listed, unlisted or government; and then add the corresponding "market value" field(s) and place that total in a third set of fields "government assets" "listed assets" and "unlisted assets". There are 9 potential fields built as multiples (ie. listed.0-.8 and market value.0-.8), this is so that if the client needs to, they can enter the listed, unlisted or government assets in any combination they need.

Example: if "listed or unlisted" = Government, then add up the value from the corresponding "Market Value" (which would equal 9) and place that total in the "Government Assets" field on a different page. Same for listed and unlisted assets. Is this even possible?

Thank you for any assistance! PJ

Thom Parker · Answer

Yes this is possible, but it is complicated enough that you should consider either hiring a developer or spending some time to learn JavaScript. Contact me if you are interested in either case.

You'll find articles, tutorials and example files only exactly this topic on this membership site:

https://www.pdfscripting.com/public/Calculating-field-values-and-more.cfm

What you are looking for is called a "table calculation", and it involves naming the fields in such a way that a common calculation script can automatically build the field names it needs based on rows and columns.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded