Sum of various row by loop

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

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)

Accepted Solutions (1)

Avatar

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485
radzmar
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;

Answers (10)

Answers (10)

Avatar

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485
radzmar
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;

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

19-09-2019

Thank you very much

finally its working.

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

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

Avatar

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485
radzmar
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?

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

18-09-2019

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

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

14-09-2019

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

Avatar

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485
radzmar
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;

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

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")

{

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

}

Avatar

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485

Avatar

radzmar

MVP

Total Posts

2.6K

Likes

386

Correct Answer

485
radzmar
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;

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

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.