Newbie needs help translating error message

Avatar

04-10-2008

I'm a new user, and I've designed an order form with two tables and a calculated subtotal for the two tables.



The tables are identical except for the values in drop down lists. I'm trying to sum the values for the ExtPrice field, which the script editor shows as named this:



----- form1.#subform[0].Table1[0].Row1[0].ExtPrice::calculate: - (FormCalc, client) ----------------



So using that information, I summed the values in all six rows of both tables using this formula:



sum(Table1[*].Row1[*].ExtPrice[*])



When I switch to preview pdf, the field calculates just like I expect it to, however I get this message when switching to preview mode:



"Script failed (language is formcalc; context is

xfa[0].form[0].form1[o].#subform[0].Table1[1])

script=sum(table1[0]Row1[*].ExtPrice

Error Syntax error near token 'Row1' on line 1 column 17"



Yeesh. the tables are named "Table1[0]" and "Table1[1]" and I tried summing the field on just one table and still get the same error (but the form works).



Can anyone help me translate this so I can fix the form before distributing it to users?



Dave in Michigan

Replies

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

07-10-2008

Looks like you are missing a dot between the table1[0] and the Row1[*]. I t=hink it should read:



sum(table1[0].Row1[*].ExtPrice)



This command will effrectively all all of the fields called Extprice in all occurances of the Row1 subform in the Table1.