Interactive invoice form calculations: Acrobat or InDesign?

[#1]

I once designed an invoice form for a car company in InDesign with interactive fields. It was later customized in Acrobat Pro with calculations, based on some javascript inside the fields themselves and also for the whole document.

Mostly calculating a sum for parts, a leasing rate based on a chosen period and stuff like auto-fill-out a date on first opening and autodelete a whole row of fields when deleting the first field with the article number.

Heres my question: Can i use all the scripting and interactiv fields also in the original file in InDesign or is something better done in Acrobat?

I'd like to avoid different programs and also i want to change the layout in InDesign because Acrobat makes a mess with text area. It automatically merges some texts and i did not understand why it does that.

[#2]

I once designed an invoice form for a car company in InDesign with interactive fields. It was later customized in Acrobat Pro with calculations, based on some javascript inside the fields themselves and also for the whole document.

Mostly calculating a sum for parts, a leasing rate based on a chosen period and stuff like auto-fill-out a date on first opening and autodelete a whole row of fields when deleting the first field with the article number.

Heres my question: Can i use all the scripting and interactiv fields also in the original file in InDesign or is something better done in Acrobat?

I'd like to avoid different programs and also i want to change the layout in InDesign because Acrobat makes a mess with text area. It automatically merges some texts and i did not understand why it does that.

[#3]

Has to be done in Acrobat

[#4]

If you have a form with revised base art, but the fields and calculations will remain the same, then in Acrobat, you can use "Replace Page" function.

[#5]

Sounds interesting. I guess all the field names must stay the same then.

[#6]

The method I described leaves the original form fields untouched. Names of fields, calculations, scripts, appearance, etc. will be retained. "Replace Page" only exchanges the static art portion of the form in the event of a revision.