Help needed :(

[Alyda]

Im new to this.... 

I have a client asking for a specific form.

They plan to have a form that is filled out once a week with a 'Weekly Completed' column.

Each week the form is filled out, they would like a column containing a 'Running Total' from previously filled out forms.

Example:

Week 1 > form filled out > Weekly Completed column filled out with value = 2

Week 2 > form filled out > Weekly Completed column filled out with value = 3 > Running Total column updates to = 5

Week 3 > form filled out > Weekly Completed column filled out with value = 6 > Running Total column updates to = 11 

and so on...

I am wondering how i can do this. Is there a way we can link form fields between pdf forms and add calculations this way? or will i need some kind of javascript?

I have to say.. i am a huge amateur when it comes to javascript.

Any help or advice would be amazing!!

[Amal.]

Hi Alyda 

Hope you are doing well and sorry for the trouble. As described, you want a column containing a 'Running Total' from previously filled out forms fields.

The Calculate tab appears in the Properties dialog boxes for only text fields and dropdown boxes. Use these options to perform mathematical operations on existing form field entries and display the result. For more information please check the calculate tab for form field properties  in the help page https://helpx.adobe.com/acrobat/using/pdf-form-field-properties.html

For information about using Javascript please check the help page https://acrobatusers.com/tutorials/javascript_console/ and see if that helps. 

Regards

Amal