Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Disable Script Error window

Avatar

Avatar
Validate 10
Level 1
shawnFMU
Level 1

Like

1 like

Total Posts

38 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 10
Level 1
shawnFMU
Level 1

Like

1 like

Total Posts

38 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 1
Affirm 1
View profile
shawnFMU
Level 1

23-10-2017

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!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

24-10-2017

Ah that makes sense now. The only suggestion would be to re-write it as a JavaScript

Answers (7)

Answers (7)

Avatar

Avatar
Level 1
TomBeesley
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
TomBeesley
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile
TomBeesley
Level 1

26-10-2017

Hey shawnFMU​, Here is the code to do a simple sum of table column values: (you will need to change the path)

[Calculate Event]

$.rawValue = Sum(FORM.Page1.Body.PaymentTable.MultiPaymentRow[*].AmountPaid);

Here is the code to sum multiple fields:

[Calculate Event]

$.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.

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

25-10-2017

I can help you get it converted from FormCalc to JS. Can you send me an email at mousland@gmail.com and I will be able to help you.

Avatar

Avatar
Validate 10
Level 1
shawnFMU
Level 1

Like

1 like

Total Posts

38 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 10
Level 1
shawnFMU
Level 1

Like

1 like

Total Posts

38 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 1
Affirm 1
View profile
shawnFMU
Level 1

25-10-2017

I guess it's reasonable to say Designer just process FormCalc differently than JavaScript.. which leads to limitations.

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"

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

24-10-2017

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.

Avatar

Avatar
Validate 10
Level 1
shawnFMU
Level 1

Like

1 like

Total Posts

38 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 10
Level 1
shawnFMU
Level 1

Like

1 like

Total Posts

38 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 1
Affirm 1
View profile
shawnFMU
Level 1

24-10-2017

Having it be in JavaScript would be better than in FormCalc?

I guess the question would be, why would FormCalc trigger an error/alert message?

Avatar

Avatar
Validate 10
Level 1
shawnFMU
Level 1

Like

1 like

Total Posts

38 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 10
Level 1
shawnFMU
Level 1

Like

1 like

Total Posts

38 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 1
Affirm 1
View profile
shawnFMU
Level 1

24-10-2017

ScreenCap.pngHere's a screen cap.
I understand the error...

but... I through it would be

easier to just hide the error window.

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

24-10-2017

can you upload a screen shot of the error message?