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

Calculations and Flowed Subforms

Avatar

Avatar
Validate 1
Level 2
meem23
Level 2

Like

1 like

Total Posts

94 posts

Correct Reply

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

Avatar
Validate 1
Level 2
meem23
Level 2

Like

1 like

Total Posts

94 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
meem23
Level 2

16-04-2021

Hi experts!

I have a dynamic form created in Adobe LiveCycle Designer ES4 and I have a few stumbling blocks.

Here is a screen shot of the stripped down version of what I’m trying to create:

meem23_0-1618594208311.png

Problem #1:

Subform called amt has a drop-down with A and B options and a field called monthlyNetDue to enter a dollar amount.  Instances are added or removed using buttons.  This subform is wrapped into subform called SF1 and this subform can be added/removed using buttons.

Following the SF1 subform is a subform called summary.  There are two fields Atotal and Btotal.  These fields need to calculate the total of the amounts entered in amt subform monthlyNetDue field.  I don’t know how to script the calculation for these two fields.  Can someone provide the script for these calculations?

Example:

meem23_1-1618594254307.png

Problem #2:

Subform called bottomSF has two fillable fields and needs to be at the bottom of each page.  When subform SF1 and/or amt subform are added and fill up page one, I want bottomSF to remain on page 1 and not flow to the next page.

I set up a Master Page 2 that has the same two fillable fields from the bottomSF so they autofill, but this doesn't help for page 1 because of the fillable fields.  I want SF1 and summary subforms to overflow onto Master Page 2 and somehow keep bottomSF positioned on the first page.  Is this possible?

Master Page 2:

 

meem23_2-1618594320119.png

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
Employee
Kosta_Prokopiu1
Employee

Likes

132 likes

Total Posts

311 posts

Correct Reply

87 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Establish
Employee
Kosta_Prokopiu1
Employee

Likes

132 likes

Total Posts

311 posts

Correct Reply

87 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
Kosta_Prokopiu1
Employee

22-04-2021

For the benefit of others here the solution that worked for meem23:

The bottomSF subform went to the bottom of the 1st Masterpage. The second Masterpage just serves for pagination.

Kosta_Prokopiu1_0-1619093876023.png

All subforms have standard pagination, SF1 also gets Overflow: Go To Page2

Kosta_Prokopiu1_1-1619094043941.png

And for field ATotal and BTotal the calculate script loops through all monthlyNetDue and checks the state of the drop-down. It adds to the corresponding total field.

Kosta_Prokopiu1_2-1619094219313.png

 

 

Answers (0)