Question

Showing Action Button Based on Field That Uses Another Field With Calculation Bug

Forms Version 11 Forms Layout Designer

Updated July 19, 2023

asked on April 12, 2023 • Show version history

I have been trying to narrow down this issue for the past couple of hours. I have not been able to replicate the issue outside of a table.

To replicate this issue, I used the following setup. 1 field named Check Amount (currency), a table that has a field named GL Amount (currency), 1 field named Total GL Amount (currency), 1 field outside the table named Total Discrepancy (currency).

Total GL Amount has a calculation of =SUM(GL_Coding.GL_Amount).

Total Discrepancy has a calculation of =SUB(Check_Amount,Total_GL_Amount)

Total Discrepancy has a Field Rule of 'Show Action Button: Submit When any of the following is true: Total Discrepancy is equal to 0'.

When I test the form and get the Total Discrepancy to 0 the Submit button does not show. I have tried adding to the rule of 0.00 and it does not work.

I have replicated the setup outside of a table and it seems to work correctly, so it appears it is related to fields connected to tables somehow. I did however change the field rule to the Total GL Amount field and the action button showed correctly when the value was met. I do not know if it is also affected by a field using a calculation that includes another field that has a calculation or even directly related to the SUB function in the calculation.

Forms version 11.0.2212.30987

UPDATE: I removed the SUB in the calculation and the issue still occured.

0 0

Answers

APPROVED ANSWER

replied on April 12, 2023

This is definitely a bug and I have filed it (ref #422224), the issue seems to be comparing it to "0" in how we handle any number field's value. I do have a workaround for you in the meantime though.

Change your rule to "Show Action Button: Submit > when any of the following is true: Check Amount is equal to Total GL Amount

When we compare two currency fields to each other the rule runs properly. Similarly you could have a hidden "$0" currency field and compare Total Discrepancy to that, but that adds an unnecessary field to your form.

0 0

View 1 previous reply

replied on April 13, 2023

In the rule, instead of comparing to 0 compare the Check Amount field with the Total GL Amount variable

0 0

replied on April 13, 2023

Right, I was referring to your last paragraph as you said "When we compare two currency fields to each other the rule runs properly.".

0 0

replied on April 13, 2023

When a rule is comparing two currency fields to each other the rule runs properly. When the rule is compared to the static value 0 in this case, it does not run properly.

1 0

SELECTED ANSWER

replied on July 19, 2023

Hi, This bug has been fixed on Forms 11 Update 4: Layout field rules handles input types intuitively now

You can see other changes from:

List of Changes for Laserfiche Forms 11 Update 4 - Knowledge Base

Get Forms 11 Update 4 from Laserfiche 11 package:

Software versions and fixes included in the Laserfiche 11 Download Package - Knowledge Base

0 0

Question

Question

Showing Action Button Based on Field That Uses Another Field With Calculation Bug

Answers

Replies

Sign in to reply to this post.