These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Duplicate Data from newly created Subform to a Text/Numeric Cell

JOHNBUNDY3000
Registered: Sep 23 2009
Posts: 2

I am new to LCD and very new to Javascripting. I have used the base form created by Sue Whitehead named Springfield Purchase Order to create an invoice. The invoice is a manual invoice that uses the " Add Line" feature to add a new line item to the invoice.

One of the fields in the Subform that is created is named CONTRACT. It contains the contract # for that line item.

At the bottom of the invoice page and on each subsequent page is an invoice summary table. That table should contain the CONTRACT # entered by the user, and Current Due, Past Due, and Total Due ( Current Due + Past Due ). All of this Summary data should be exactly what the end user entered in at the Subform "ItemSet" level. It just needs to show the same data.

Thanks to Sue I have this working on one item, and I think it is because that item is visible, and is the first subform.

Can anyone take a look at the doc and give me a hand please>? I am 5 days into this now, and cannot seem to find the answer. I've included a link to the doc on Google Docs below. You should be able to download it and take a look at the monster I've turned this into.

Any input is appreciated!

JB

http://docs.google.com/fileview?id=0ByzEIdGetnElZGViNGU3MWUtZDY0ZC00NGI0LTgxODAtNzU3YzlmMTE4MTQ1&hl=en

"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe." - Einstein

"It takes more than a bald head to be like Michael Jordan anyway! " - Sheneneh ( 1992 Martin Sitcom )

My Product Information:
LiveCycle Designer, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
You have an issue with the way you are doing this form. The contract# is in a repeated subform, but the summary data is not repeated. So if there are multiple lines, then which contract# is going to show in the summary data?

FormCalc or JavaScript is used to copy data from one location to another, usually from a calculation script in the recieving field. The issue is being able to identify the locations, which is a problem on a repeated subform. i.e.Which instance of the subform is being copied from/to?

This video discusses issues surounding repeated subforms, such as identifying the path to a specific instance.

https://admin.adobe.acrobat.com/_a200985228/p87746471/

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Then most important JavaScript Development tool in Acrobat
[url=http://www.pdfscripting.com/public/34.cfm#JSIntro][b]The Console Window (Video tutorial)[/b][/url]
[url=http://www.acrobatusers.com/tutorials/2006/javascript_console][b]The Console Window(article)[/b][/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script