Question

Lookups don't work properly in tables with fixed number of rows

Forms Version 10

Updated March 9, 2017

asked on January 30, 2017 • Show version history

Forms 10.2 (also used to happen in 9.2)

Imagine a table with two single-line fields: Field A and Field B.

There is also a database with corresponding columns: Column A and Column B.

Configure lookup rules as such:

1. Fill Field A with Column A

2. When Field A matches Column A, fill Field B with the matching value from Column B.

This works fine in dynamic length tables where users have to add lines one by one. However, if you make the table fixed length, the second lookup rule stops working. All the Field A's get filled properly, but don't perform their lookups to fill their corresponding Field B's.

This issue also seems to happen if the table is dynamic and the user adds a bunch of rows in quick succession by repeatedly clicking the Add button of the table. But that one is a bit more difficult to reproduce.

0 0

Replies

replied on February 6, 2017

A case was opened with Laserfiche Support for this; ultimately the issue was a large number of requests to lookup because of a behavior where multiple requests are sent to lookup for rules with multiple Match conditions in a table with multiple rows. Thus the response payload was unavailable and it seemed that the lookups were not functioning. When these requests had completed, however, the lookups behaved as expected. SCR 154255 has been filed to evaluate this behavior.

0 0

replied on March 9, 2017

Hi,

Forms 10.2 Update 1 has been released and this problem is fixed in this update.

You can get the patch for this at https://support.laserfiche.com/kb/1013834/list-of-changes-for-laserfiche-forms-10-2-update-1-

Thanks.

0 0

You are not allowed to follow up in this post.

Question

Question

Lookups don't work properly in tables with fixed number of rows

Replies

Sign in to reply to this post.