Level 1

0% to

Level 2

Tip /

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

View all

## Sum of various row by loop

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile
aka44356106
Level 2

05-09-2019

I have a livecycle dynamic form in which table10 contains Row0, Row1.....Row9

i create a loop for sum of cell4 of table10 rows

var vTotal = 0;

var nRows = SFcsl.Table10.resolveNodes("Row" + i + ".Cell4");

for (var i=0; i<nRows.length; i++)

vTotal = vTotal + nRows.rawValue;

this.rawValue = vTotal;

but it result show always 0

plz help me

#### Accepted Solutions (1)

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile
MVP

06-09-2019

Your SOM expression for resolveNodes() is wrong.

Try

`var nRows = SFcsl.Table10.resolveNodes("#subform[*]" + ".Cell4"),   vTotal = 0;for (var i=0; i<nRows.length; i++) {    vTotal += nRows.item(i).rawValue;} this.rawValue = vTotal;`

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile
MVP

19-09-2019

Ok, that's no a big deal.

`var c = this.caption.value.text.value,r = ""; switch (c) { case "Bad" : r = "Good"; break; case "Good" : r = "Average"; break; case "Average" : r = "Bad"; break;default: r = "Good";} this.caption.value.text.value = r;`

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile
aka44356106
Level 2

19-09-2019

Thank you very much

finally its working.

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile
aka44356106
Level 2

19-09-2019

i want to use a Button instead of Dropdown List

so i can choose a option (good/average/bad) by click a button

after first click  of button "button's caption = Good"

after Second click  of button "button's caption = Average"

after third click of button "button's caption = bad"

plz help

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile
MVP

19-09-2019

Well, you might explain what you're after. Where do you enter the values "OnClick" etc. and which caption you want to change?

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile
aka44356106
Level 2

18-09-2019

sir its not working in click event of a button plz help?

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile
aka44356106
Level 2

14-09-2019

when i use this script in click event of a button its not working.

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile
MVP

14-09-2019

Hi,

for this scenario you can use a switch() expression.

`var c = this.rawValue, r = "";switch (c) {case "OnClick" : r = "Good"; break;case "On2Click" : r = "Average"; break;case "offClick" : r = "Bad"; break;}this.caption.value.text.value = r;`

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile
aka44356106
Level 2

13-09-2019

plz suggest a script to change caption of a button when click

i try this but not working

if (this.rawValue == "OnClick")

{

this.caption.value.text.value = "Good";

}

else if (this.rawValue == "offClick")

{

}

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile

MVP

Likes

395 likes

Total Posts

2,686 posts

491 solutions
View profile
MVP

07-09-2019

You can filter the type of row by using predicates.

`var nRows = SFcsl.Table10.resolveNodes('#subform.[assist.role == "TR"]'),    vTotal = 0; for (var i=0; i<nRows.length; i++) {     vTotal += nRows.item(i).Cell4.rawValue; } this.rawValue = vTotal;`

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile

aka44356106
Level 2

Likes

10 likes

Total Posts

56 posts

0 solutions
View profile
aka44356106
Level 2

06-09-2019

Thanks a lot for correction in script.

its work perfectly but

this script will not work  if table10 conatins headerRow  with textfield.

i check       for (var i=1; i<nRows.length; i++)

but no result show.