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

Question

Question

Forms 9.1 Database Lookup causing slow loading

Forms
Updated March 25, 2014
asked on March 12, 2014

I have a rather large database i am pulling from for lookup fields in forms 9.1. It is pulling the data and populating a drop down in my form with a scrolling wheel. This is causing a very long delay in a person being able to type i the box. This delaying is causing this form to be unsuable, and script errors. 

 

How can i have the lookup only pull data once the user is finished typing?

Capture.PNG
Capture.PNG (21.44 KB)
Download
0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on March 13, 2014 • Show version history

In 9.1.1, you can disable the "auto-suggest" feature for lookup rules for your Forms Server.  See this KB article for more information.

0 0
View 2 previous replies
replied on March 13, 2014

So this feature can only be turned on or off at the server level? Will there be a way in the future to be able to enable or disable on a per form basis?

0 0
replied on March 13, 2014

When performing the steps in the KB Article, does it then make it behave like 9.0 did where the drop-down lists still auto-populate, but just not the single line fields?

0 0
replied on March 13, 2014

Hi Blake,

 

After adding the DisableAutoPopulateIn91 and set value to True, it will disable both drop-down list auto-populate and single line auto-suggest, so it'll be different from 9.0. KB article has been updated with more detail information.

 

Best wishes,

Abby

0 0
replied on March 13, 2014

Feature will be turned on and off at server level. You can use a Fill only lookup rule to achieve the auto-suggest behavior for individual form.

 

0 0
replied on March 25, 2014

This has helped a bit. it is still looking for data. I am hoping there is a way so it is like QuickFields lookup that once you tab out of the box then it pulls data, not with every keystroke. Is this possible?

0 0

Replies

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

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...