"Overall Total" for each person entered in a Table

Nortel22

01-02-2018

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!

Accepted Solutions (1)

Accepted Solutions (1)

MinusZero

06-02-2018

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.

Answers (4)

Answers (4)

Nortel22

06-02-2018

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

Nortel22

06-02-2018

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.

MinusZero

01-02-2018

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

1408753_pastedImage_0.png