"Overall Total" for each person entered in a Table

Avatar

Avatar
Validate 1
Level 1
Nortel22
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Nortel22
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
Nortel22
Level 1

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)

Avatar

Avatar
Validate 1
Level 4
MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

Correct reply

54 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

Correct reply

54 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
MinusZero
Level 4

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)

Avatar

Avatar
Validate 1
Level 1
Nortel22
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Nortel22
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
Nortel22
Level 1

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

Avatar

Avatar
Validate 1
Level 1
Nortel22
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Nortel22
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
Nortel22
Level 1

06-02-2018

Doc1.jpg

Avatar

Avatar
Validate 1
Level 1
Nortel22
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Nortel22
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
Nortel22
Level 1

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.

Avatar

Avatar
Validate 1
Level 4
MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

Correct reply

54 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
MinusZero
Level 4

Likes

30 likes

Total Posts

326 posts

Correct reply

54 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
MinusZero
Level 4

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