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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

charis_dancer
charis_dancer
Offline

Badges

Badges
9

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
1

Posts

Posts
31

Discussions

Discussions
1

Questions

Questions
30

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by charis_dancer
Customize the badges you want to showcase on your profile
Re: Find sum of two tables; display only if > 0 ? - Adobe LiveCycle 05-02-2014
Thank you for your suggestion. I'm not certain that it addresses my issue, however.The form has two check boxes: giftware, and clothing.If the user checks giftware, the giftware table appears and he/she can enter values. The table is coded such that the footer row does $ = sum(Row[*].Pre-price) to determine the sub-total. The grand total for the table is calculated as the sum of 5% tax added to the sub-total.If the user checks clothing, the clothing chart appears, and the user can enter values. ...

Views

633

Likes

0

Replies

0
Find sum of two tables; display only if > 0 ? - Adobe LiveCycle 04-02-2014
I am presently creating an order form in LiveCycle. Within it are two checkboxes: clothing and giftware.Each checkbox is tied to a table, visible or hidden, depending whether the box is checked. With me so far?The first table allows the user to specify color, style, quantity, list price, logo/insignia location, etc. on clothing. The user can add or delete rows, and the table calculates the total, sales tax and grand total on the fly. No problem.The second table allows the user to specify etching...

Views

985

Likes

0

Replies

2
Re: Autosum totals for amounts in multiple instances of table? - Adobe LiveCycle 24-01-2014
Note that I've renamed the subform:The code for the AmtExclGST is:Sum($.resolveNode("ExpenseInfo").ExpenseDetails[*].Row1.AmtExclGST)And the code for GST is:Sum($.resolveNode("ExpenseInfo").ExpenseDetails[*].Row1.GST)This worked!Thank you very, very, very much!

Views

847

Likes

0

Replies

0
Re: Autosum totals for amounts in multiple instances of table? - Adobe LiveCycle 24-01-2014
If Add row is clicked, add a new instance of ExpenseDetails table. Conversely, if Delete row is clicked, remove current instance of ExpenseDetails table.These actions were built using the Action Builder, not code.Can you let me know where the wildcard, [*], goes?

Views

833

Likes

0

Replies

0
Re: Autosum totals for amounts in multiple instances of table? - Adobe LiveCycle 24-01-2014
This doesn't appear to make a difference.

Views

833

Likes

0

Replies

0
Re: Autosum totals for amounts in multiple instances of table? - Adobe LiveCycle 24-01-2014
Unless I misunderstood your post, I put the line of code provided in the GST cell of the Labels row in the Totals table.This illustrates the table, and that it's configured to be repeatable.As indicated earlier, the Add/Delete buttons add/remove an instance of the entire table.

Views

835

Likes

0

Replies

0
Re: Autosum totals for amounts in multiple instances of table? - Adobe LiveCycle 24-01-2014
Hello, Magus069, and thank you for the reply. As you can see, however, it doesn't achieve the desired result.

Views

827

Likes

0

Replies

0
Autosum totals for amounts in multiple instances of table? - Adobe LiveCycle 24-01-2014
I'm using LiveCycle ES2 to create an expense claim form. I have no trouble calculating the sum of all values in a column in a table with repeatable rows. However, this form is more complex. As you'll see, each item (expense) is a table. Clicking the button adds a new instance of the table. No problem with the calculation for GST, either.Where it gets tricky is trying to dynamically calculate the grand totals for all expenses incurred and for all GST. This is in a different table, as you can see ...

Views

5.1K

Likes

0

Replies

12
Re: Dynamically populate text field based on result of on-the-fly calculation? - Adobe LiveCycle 02-01-2014
It works beautifully!I've kept the two separate: the calculation appears in the numeric field, while I've taken your suggestion and added your code to the text field and replaced the $ with the field name.Thank you so much!

Views

652

Likes

0

Replies

0
Likes from