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

Script failed on Formcalc

Avatar

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
rebeccab1887119
Level 1

08-10-2015

Hello!

I have created a total sum calculation in a table using formcalc, which works when the pdf is open in reader. The issue is that an error message occurs upon opening the document & when entering the numbers. However, all the tables calcuate the sum correctly...

Here is the error message:

Capture.JPG

Is there a way to identify the location of the error? or is this something that requires rewriting the script?

I am not familiar with writing script.. so I was heavily relying on FormCalc..

Thank you for any advice!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile
_Bruce_Robertson
MVP

09-10-2015

Hi,

The object xfa.form.forml.Page3.tblProjRev has the script in your initial image above and this has a reference to DCA15 in the second line;

Row4.COS14=Row2.DCA14+ Row3.CityDep14

Row4.COS15=Row2.DCA15+Row3.CityDept15

Is that not showing up in the script editor?

There are some other errors as well, since you are getting "Message limit exceeded. Remaining 2 errors not reported." but fixing that show the next message.

Bruce

Answers (7)

Answers (7)

Avatar

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
rebeccab1887119
Level 1

12-10-2015

Thank you!!

I found the error... I was looking on the specific cell, and not on the general page for the script editor. I also was looking at the xml source for the error... oops. I am new to livecycle and don't know code...

I was able to remove all the incorrect formulas.

Thanks for your patience & replies!

Avatar

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
rebeccab1887119
Level 1

09-10-2015

Yeah, i know that it lists DCA15 in the error message... still don't understand how to fix the problem.

DCA15 is not listed in the Hierarchy, I don't list it in the calculation, would it be somewhere else? like on the xml source?

any ideas? or should I just provide the document...

Avatar

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct Reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct Reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile
radzmar
MVP

09-10-2015

In line 4 of the error message above you'll find Row2.DCA15 which doesn't exist.

Avatar

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
rebeccab1887119
Level 1

09-10-2015

Right , but the error said "error, accessor 'Row2.DCA15' is unknown... I don't list DCA15 in the caluation... Should I look for this in the a different location? 

I even renamed the DCA14 cell, but the error still occurred..,,

Avatar

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct Reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct Reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile
radzmar
MVP

09-10-2015

The field in Row2 is named DCA14 not DCA15.

Avatar

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
rebeccab1887119
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
rebeccab1887119
Level 1

09-10-2015

Capture_Application.JPG

This is the only row 2...

I am working off an application someone else created... so that's why I don't know..

Thanks Bruce

Avatar

Avatar
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile
_Bruce_Robertson
MVP

08-10-2015

Hi,

There error is trying to say that Row2 doesn't have a field called DCA15.

Maybe a screenshot of the hierarchy palette would help us understand the problem.

Regards

Bruce