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

Adaptive form calculate expression for multiple instances

Avatar

Avatar
Validate 1
Level 1
SiriKK
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

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

Avatar
Validate 1
Level 1
SiriKK
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
SiriKK
Level 1

28-07-2020

How do you call each instance and get the numeric value to calculate a total value? I'm stuck at identifying the syntax for each instance's value - here's the script for the calculated field:

 

var f = guideRootPanel.tblAgencies.Agency.instanceManager.instanceCount;
var total = 0;
for (var i=0; i < f; i++) {
total = total + guideRootPanel.tblAgencies.Agency(i).ContractID.value;
}
this.value = total;

calculated expression instance manager instances

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 1
SiriKK
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

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

Avatar
Validate 1
Level 1
SiriKK
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
SiriKK
Level 1

03-08-2020

Our team found the answer in case this helps someone else:

 

total = total + Agency.instanceManager.instances[i].ContractID.value;

Answers (1)

Answers (1)

Avatar

Avatar
Springboard
Level 10
Mayank_Gandhi
Level 10

Likes

310 likes

Total Posts

1,139 posts

Correct Reply

184 solutions
Top badges earned
Springboard
Establish
Validate 1
Contributor 2
Ignite 5
View profile

Avatar
Springboard
Level 10
Mayank_Gandhi
Level 10

Likes

310 likes

Total Posts

1,139 posts

Correct Reply

184 solutions
Top badges earned
Springboard
Establish
Validate 1
Contributor 2
Ignite 5
View profile
Mayank_Gandhi
Level 10

15-10-2020

@SiriKK  We will get this documented.