Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

How to aggregate the values and text in the table?

Avatar

Avatar
Validate 1
Level 1
JainSa
Level 1

Likes

2 likes

Total Posts

9 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
JainSa
Level 1

Likes

2 likes

Total Posts

9 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
JainSa
Level 1

19-12-2018

Hi,

How to aggregate the values and text in the table?. (Form calc or Js)

Thanks,  Jain

Accepted Solutions (0)

Answers (3)

Answers (3)

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-01-2019

Hi JainSa,

If your rows are fixed you can simply add them up, but if you are dynamically adding rows, you can do this.

Assuming the first data entry row is repeating, in the total field at the bottom add this code.

form1.#subform[0].Table1.Row2.NumericField1::calculate - (FormCalc, client)

sum(Table1.Row1[*].NumericField1[*])

1658195_pastedImage_0.png

Whenever you create a new row ( i have repeated row1), a new instance will be created before the total row and the new totals will be displayed when the field is edited.

1658196_pastedImage_1.png

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

19-12-2018

Are you wanting to concatenate the values into another object? It isnt quite clear, so here it is.

Concatenating is easier in JS, calculating in FormCalc.

1650487_pastedImage_0.png

The NumericField3 calculate event simply has:

1650488_pastedImage_1.png

Whenever either field is changed, it recalculates.

The concatenate button is this:

1650489_pastedImage_2.png

When clicked a new rawValue is entered in the text field which is made up of the other fields concatenated into one value.

1650490_pastedImage_3.png

Avatar

Avatar
Validate 1
Level 1
JainSa
Level 1

Likes

2 likes

Total Posts

9 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
JainSa
Level 1

Likes

2 likes

Total Posts

9 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Applaud 5
Affirm 1
View profile
JainSa
Level 1

27-12-2018

Dear Minus zero,

Thanks for your reply. please find the below screenshot.

I expect below aggregation.

Capture.JPG