Two Live Cycle Designer Questions

Q. Can I total values in a table, e.g. one amount in a number field per row?

To cover a related question, this approach should work for check boxes in a table which gave been allocated values

Assuming you have a table with repeating rows in place

Form with Table prepared , rows and fields renamed
Form with Table prepared , rows and fields renamed

You then need to open the script editor panel via the Window menu.

Select the field that will act as the grand total – in my example, this is called Total.

In the Object panel set value to Calculated Read Only

Set Value to Calculated Read Only

Set Value to Calculated Read Only

In the Script Editor panel choose calculate

In the Script Editor panel, choose Calculate
In the Script Editor panel, choose Calculate

Set the Language to FormCalc

Set language to FormCalc
Set language to FormCalc

Then in the panel add the following code – Use your table name, row name and field name. Read  [*] as saying “for each instance of the object” “This” refers to the currently selected object, in this case the grand total field.

this=sum(Table1.DataRow[*].Amount[*])

Save and test

Use tab key to move from field to field
Use tab key to move from field to field. This will trigger the recalculation of the total.

Q. Can I auto-number my rows?

Yes you can, but you will need to be comfortable with adding some code.  Please read this very good article here “Numbering rows in a LiveCycle Designer table or repeating subform” which also has a sample file.

I’d like to do a video on this, but due to time limitations, I wont make promises I can’t keep.

Best Wishes

Steven