jaseabra Calculating status...
-
-
-
The form contains a table called 'costs' containing 5 rows. Since the row is called 'row' it is automatically indexed [0]..[4]. 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[0] since the index is zero-based, the expression looks like this...
// form.page1.budget.costs.row[0].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.
Steve
| -
-
-
-
-
-
- 10 points awarded for Correct Answers
- 5 points awarded for
-
10,000+ points
-
1,001-10,000 points
-
501-1,000 points
-
5-500 points
-
