You are viewing limited content. For full access, please sign in.

Question

Question

LFF0337 error

Forms
Updated May 24, 2018
asked on May 9, 2018 • Show version history

Good Day,

The formula below was working in Laserfiche Forms 10.2.1 in a table:

=PRODUCT(INDEX(Activity_Items.Quantity, ROW()), INDEX(Activity_Items.Unit_Price, ROW()))

However, since the upgrade to Laserfiche Forms 10.3.1 the following error is generated upon submission of the form:

Thanks,

Simon

3 0

Replies

replied on May 10, 2018

Been working with support for a couple weeks trying to figure this one out. We are stuck on 3 major problems.

We can't seem to determine how many arguments it is expecting.

There is no indication of which field it is upset about (if you are calling the same function more than once)

Why does it prevent submitting the form, it is just a helpful calculation after all, no different than a javascript calculation.

0 0
View 7 previous replies
replied on May 10, 2018

Hi Chad,

The formulas were working in LF Forms 10.2.1, and stopped working in 10.3.1. What version of forms are you using? 

Thanks,

Simon

0 0
replied on May 10, 2018

10.3.1 and it is the same issue, the formulas existed without change but after the upgrade to 10.3.1 this problem started. We have been trying to track it down since. The real problem is that it prevents them from submitting the form and does not save what they had previously filled out. The calculations actually still work as expected.

1 0
replied on May 10, 2018

That is the same issue we are seeing. The formulas still work, but on submission the form errors out. We have three tables that have similar product formulas. We removed formulas from each table, and then added each formula back one at a time. The first two tables worked, and we were able to submit the forms in each case. However, once we added the product formula to the third table it reverted back to the initial error that we received upon submission. We tried deleting the field that holds the formula and creating a new field, but that was to no avail. We have not been able to determine why it is failing on the third table. Even after we delete the formula from the third table the first two tables that worked now fail.

0 0
replied on May 10, 2018 • Show version history

That is interesting that it works with 2 tables. This form we are troubleshooting is the same setup where it uses more than 2 tables. I wish I could test the concept out but field calculations have never worked for me when trying to input fields as parameters. I always get an error that doesn't specify what the problem is. I can only work with static values.

 

In any case if you open a support case you may want to reference ours so the person working it doesnt start from scratch. They have been working on it for awhile now. #194363

0 0
replied on May 10, 2018

Thanks for the information! I tried the MULT function as well and had no luck with that it.

0 0
replied on May 10, 2018

MULT is the same thing except it ONLY accepts 2 parameters. I guess it is more efficient either in speed and or garbage collection because it knows an array is not required.

0 0
replied on May 10, 2018

I got the same error you received when I tried the MULT function.

0 0
replied on May 15, 2018

Any luck on this. I have not had any solution other than to remove all field calculations.

0 0
replied on May 15, 2018

After we removed all the formulas we performed the calculations using java. We thought we had it working then certain paths in our Forms' process started producing this error below on submission:

Laserfiche Forms has encountered a problem.

The function 'SUB' was given an invalid number of arguments. [LFF1006-InvalidArgumentCount]

However, we do not have any SUB functions on the forms. We are trying to determine why this error is occurring. 

0 0
replied on May 15, 2018

When you backup a form by downloading it from the manage screen it downloads as an XML file. You can open that in notepad and search for "SUB(" to find it.

0 0
replied on May 15, 2018

Filed a bug for this where calculations are throwing errors when the fields it is based on are empty. 

0 0
View 2 previous replies
replied on May 16, 2018

Just to clarify. In order to resolve the problem we just need to set the default value of all fields referenced for parameters to "0"?

1 0
replied on May 16, 2018

I tried that and so far it works. Still testing to verify no other issues are coming up.

0 0
replied on May 16, 2018

Very cool, thanks for confirming! I still can't get calculations to work at all in my dev environment so I can't do any testing on my end.

0 0
replied on May 16, 2018

I had to ensure that every number and currency field that was being used in the Product formula has a default value of zero. With all the testing done so far everything seems to be working at this moment.

0 0
replied on May 24, 2018
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...