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

Question

Question

WebClient Long Loading Lookups

asked on September 3, 2019

Does anyone have any experience of dealing with look ups in the webclient metadata pane that are a little on the heavy side? We have a client that has a list of values in the 10's of thousands that they want to be a look up in the web client (it's already a look up in their forms processes) and whilst it is easy enough to create this as a field, it appears to be causing the web page to become unresponsive when they are selecting more than a few of the files in preparation to start bulk editing.

unresponsive2.png
0 0

Replies

replied on September 5, 2019

Hi Chris, 

 

What version of the Web Client is the customer using?

 

The HTML element used for drop downs can cause the browser to hang if too many values are returned at once. This is probably what's happening to the customer.

 

I recommend using the [Settings]MaxDropDownLength attribute. MaxDropDownLength sets an upper limit on the number of values displayed in the drop down. If the lookup exceed this limit, the user must type to filter until the number of values returned is less than the limit. The attribute can be set to any positive integer.

 

Another useful attribute is the [Settings]CacheFieldValues. When CacheFieldValues is true, the values for the lookup are cached in browser local storage after they first time they're retrieved, offering a slight performance boost. [Settings]CacheFieldValues accepts Booleans (True/False or Yes/No).

2 0
replied on September 3, 2019

Is there any chance of splitting those items up into categories and using dynamic fields? Even if the top level dropdown is something like A-E, F-J, etc...you might be able to speed up the initial load.

1 0
replied on September 6, 2019

I think rather than split it up we're looking at embedded forms with stored procedures doing the heavy lifting to narrow down the look up results at this point, if the other solution doesn't help us out.

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

Sign in to reply to this post.