I have a form that I made up in Adobe Pro 9. However, I needed to do some stuff to it that only livecycle would allow me to do. Long story short it is now in livecycle. Here is my problem, in adobe acrobat I could easily set auto sum for fields that I wanted to calculate. However I cannot figure out how to do this in livecycle. Can anyone tell me how to do this?
The table does what I want my form to do, however I still dont know how to do it. Is there any way you can tell me how to do this so I can do it on my form? I thought this would have been just as easy as when I do it in adobe acrobat, but am quickly being proven wrong.... LOL
The form contains a table called 'costs' containing 5 rows. Since the row is called 'row' it is automatically indexed ... Each row contains the columns as depicted below.
Take a look at the object 'total'. For each row the calculate event uses a FormCalc expression to total the value of the objects 'beer', 'food' and 'other'. For row one, row since the index is zero-based, the expression looks like this...
// form.page1.budget.costs.row.total::calculate - (FormCalc, client)
$.rawValue = beer + food + other
FormCalc is smart enough to associate the objects 'beer', 'food' and 'other' from the current row, add them together and assign the sum to
'$.rawValue' which is the FormCalc equivalent of saying this value.
The column totals use the FormCalc expression sum and the notation 'row[*]' to indicate all rows. For the column 'beer' the expression is then 'row[*].beer' for the object 'beer' in every row.
// form.page1.budget.totalCosts.totals.beer::calculate - (FormCalc, client)
$.rawValue = sum(form.page1.budget.costs.row[*].beer);
I hope that helps.
Call me dense, but Im still not understanding. I tried but could not figure this out. Here is what im working on, tell me where I went wrong. In this form you will see I have two rows on the left. One that says regular time and the other OT. I need them to calculate under Total reg hours and total OT. Maybe if you tell me where im going wrong, the light bulb will finally go on in my head.
I saw this post and I was happy that it's possible to add this in pdf but I could not figure it out the same with jaseabra could you help me please Steve... I've attached the file it's in pdf and doc format.. also.. there's an image at the back of the document... if your having difficulty placing the script you can remove the background.
Thank you in advanced!
The solution is very simple.
$ = Sum(Row1[*].amount) //in your pdf maybe $ = Sum(Row1[*].iznos)
If you create instances of the amont field you have to write
$ = Sum(amount[*])
Hope it will help,
Europe, Middle East and Africa