create a form to function like a spreadsheet

[rockylithicfitness]

a few years ago, i was given a PDF form as part of nutrition program.  As I entered my person information through various forms (drop boxes, numerical entry, etc) my estimated nutritional needs were calculated and shown at the bottom.  I have created several MS Excel spreadsheets that perform this function just fine, but when I convert to PDF I lose the functionality.  Is there a way to keep the functionality of the calculations, or a way to create a stand alone PDF that functions like a spreadsheet?

[John T Smith · Accepted solution]

You have to learn scripting... for example (NOT an exact example, I don't do scripting, you need to find tutorials)

Box A is data entry where you enter cost of an item

Box B is where you enter tax rate

Box C has script in the definition "something like" A x B = C

Just like an Excel cell

[Thom Parker]

Here are some links that will help you get started:

https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations

Calculating field values and more

https://acrobatusers.com/tutorials/conditional-execution

Free Video Content & Full Listing of Available Videos