Table Automations : Calculations and Table links
Hi
Please assist.
I have attached my document for you to reference to what i require to be automated.
My document is a Letter of Appointment(LOA) and a Cover Letter(CL) for the Letter of Appointment (LOA)
I have issues surrounding my automations and calculations with my tables. My Tables use Legacy formfields (Mostly Text Input ff)
I managed to add a new row with form fields and i managed to delete a row from the selected table.
Issue 1
(Table No1)- ITEM Table in my document (3 x cols, headings : No, Item and Amount), the rows is dependent on how many rows the user requires and the new row added copies the form fields in the previous row and creates a new form field name for each new cell. this table also totals the last column in the last cell of the last row of the table (Including newly added rows)
My requirement : I would like to copy/link this table to my Cover Letter , however because the document is a template as the item table in the LOA gets updated with new information/amounts and new rows, the copied or linked table on the cover letter needs to automatically update with the same information and newly added rows as the table on the LOA.
Issue 2
Then (Table No2) - Payment Milestone Table (3 x cols, headings : Percent, Milestone and Amount), this table is slightly different as it requires a little more calculations.
The rows is dependent on how many rows the user requires and the new row added copies the form fields in the previous row and creates a new form field name for each new cell. this table also totals the last column in the last cell of the last row of the table (Including newly added rows).
However each cell in the last column cells has a formfield expression that calculates the Total (last cell of the last column) of Table 1(ITEM Table) multiplied by the Percent Value (in Column 1 cell/s in Table 2 in each row) which is a input by the user.
It becomes tricky when you add a new row and the expression/calculation in the new last cells' formfield does not automatically update the expression/sum {= SUM(Table1 C:C)*PercentVal}to change the 'PercentVal' name (which is the prev/old rows first cell ff ref name) (copied from the previous formfield) , to the name of the new/first cell ff in col 1 in the new row. The new rows calculation in the new last cell still references to the prev/old rows first cell ff name and makes the calculation wrong.
Would be really cool if someone could assist me with this.
Thanks, looking forward to seeing the solution
|