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.Table1.Row1.ExtPrice::calculate: - (FormCalc, client) ----------------
So using that information, I summed the values in all six rows of both tables using this formula:
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
Error Syntax error near token 'Row1' on line 1 column 17"
Yeesh. the tables are named "Table1" and "Table1" 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