I have a formCalc scripts referencing in a subform instance that's set at zero and remains "hidden" on initial opening of the file.
Script debugger windows kicks in when the file is open saying there's an error cause there's not instance of it yet...
Can I disable the script debugger window?
Thanks in advanace!
Hey shawnFMU, Here is the code to do a simple sum of table column values: (you will need to change the path)
$.rawValue = Sum(FORM.Page1.Body.PaymentTable.MultiPaymentRow[*].AmountPaid);
Here is the code to sum multiple fields:
$.rawValue = InitialAmount.Totalprice - PaymentTable.Footer.AmountPaidTotal;//You can also use '+'
Both are form calc, put the code on the calculate event for the object that you want to set.
Hope that helps.
I can help you get it converted from FormCalc to JS. Can you send me an email at firstname.lastname@example.org and I will be able to help you.
With that said, does anyone know a good place to learn a crash course on how to write up a sum script in JS.
Sounds like I need to know Var and ++i++ and real programing stuff.
All I need is two examples.
Field A needs to add up table column values from fields "aa" and "bb"
Field B just needs to add up table column values from "cc"
Designer tries to process the FormCalc. There may be a way to bypass the error but I am not sure how. It will basically ignore the JS error and continue to work.
I guess the question would be, why would FormCalc trigger an error/alert message?
Here's a screen cap.I understand the error...
but... I through it would be
easier to just hide the error window.
can you upload a screen shot of the error message?