Calculations and Flowed Subforms | Community
Skip to main content
M
meem23
April 16, 2021
Solved

Calculations and Flowed Subforms

  • April 16, 2021
  • 2 replies
  • 953 views

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:

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:

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:

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Kosta_Prokopiu1

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.

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

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.

 

 

2 replies

Kosta_Prokopiu1
Adobe Employee
Kosta_Prokopiu1Adobe Employee
Adobe Employee
April 19, 2021
Hi @meem23, if you can PM me a link to google-drive or similar giving me the XDP I will have a look at it. It is a lot of work to try and replicate things, especially for your problem #2
Kosta_Prokopiu1
Adobe Employee
Kosta_Prokopiu1Adobe EmployeeAccepted solution
Adobe Employee
April 22, 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.

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

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.

 

 

    Terms & ConditionsAccessibility statement

    Loading footer...