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

Question

Question

Lookup rules taking long time to load

asked on February 7, 2016

my problem is lookup sometimes taking long time to load is there away to prevent the user from pressing submit button until the lookup finishes loading?

0 0

Replies

replied on February 12, 2016

it's a good idea and i'm doing that but the problem if the lookup is fired from drop down list in the first time i choose from the list the lookup fires and fill the field but when i choose another value from the lookup it takes quite some time to get the new data in that case if the user pressed the submit button it will be submitted with the old information before the lookup loads the new info.

1 0
replied on May 9, 2018

Hi Ayman,

Another method is to incorporate a spinner/loader. This blocks the lookup button (and all fields) until the lookup has completed.

See https://answers.laserfiche.com/questions/109401/How-to-Create-a-Spinner-or-Loader-for-Forms#141837 and https://answers.laserfiche.com/questions/108471/Can-we-get-a-lookups-complete-custom-event-listener-please#121241

 

It might not work for the mobile apps because the Submit button exists in a different button bar.


Hope it helps.

-Ben

 

1 0
replied on February 7, 2016

this link contains how you can hide submit button with your specific condition https://answers.laserfiche.com/questions/49708/Can-I-hide-submit-button 

my experience with Lookup rules do not depend on Stored Procedure its better to use Database View and if you need to retrieve data with Parameters you can depend on hidden Field Value then filter View data with this Value.

replied on February 12, 2016

Hi Ayman,

 

You can make one of the fields populated from lookup data required to prevent users from submitting the form until the lookup is complete. And if you haven't already, try applying the latest hotfix for Forms to see if that'll improve lookup latency. Hope that helps!



 

0 0
replied on February 24, 2016

unfortunately, we are using LF 9.2 and we can not upgrade our systems to LF 10 because of some missing features in 10 like custom buttons .

0 0
replied on February 25, 2016

Hi Ayman, have you at least applied the latest hotfix for 9.2.1? This includes many of the updates made for Forms 10, rolled back for version 9.2.1, including the improvements made to handling lookup fields.

0 0
replied on February 25, 2016

I'll give it a try, thanks

0 0
replied on March 3, 2016

unfortunately still so slow. i had to disable these fields for 20 sec to be sure that all information is load. 

it's not the best practice maybe it will take more 20 sec , but until i found a better solution.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.