"Overall Total" for each person entered in a Table

[#1]

How can I get a table that expands using buttons to "total" the number of names when entered in the form?  Right now I have the table automatically number when you click the "Add Row" button, but unfortunately it is adding each number, for instance 1,2,3=6.  Please help!

[#2 · Accepted solution]

What you have stated seems correct for when using Formcalc, assuming the object names are correct. Make sure you put it in the Calculation field and it will then update as you go along.

[#3]

I am really having trouble with the division calculation.  Can someone please help me with that?

Calculations are:

Quantity * Unit Cost

Per Day Total:

Total number of employees / Total Cost

Per Employee:

Per Day / Total # of Days

[#4]

[#5]

I appreciate the prompt response, but that is not quite the answer that I need.  Is there a way for me to send you a sample of what I am working.  I also, have some calculations that I have added to the form.

[#6]

Hi,

From your description it sounds like you have one name per row and want to count the row instances. You can do that with the Instance Manager.

If you want to send the amount of rows to a NumericField for example. Add this to the Add Row button click event javascript:

NumericField1.rawValue = Table1.Row1.instanceManager.count;

Here is my test example:

The table row repeats, the button adds the row and count to the NumericField