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

Discussion

Discussion

Forms Feature Request: Loading Lookup Results with Pagination

posted on January 22, 2019

Browsers can hang for seconds if not minutes depending on the number of rows returned by your lookup rules / stored procedures.  While this is mostly due to the fact that browsers aren't suited for loading hundreds of rows of data, it doesn't change the fact that user experience is impacted.

Perhaps, we can avoid this loading issue by paginating the results like below rather than loading everything at once. Having something like this out-of-the-box would be ideal. 

Right now, I am getting around this loading issue by restricting the number of rows returned in my stored procedure. However, this is not an ideal solution because there may be situations where you want to see all the rows returned by your query. 

On a side note, just to make sure I don't misinform anybody, I still experienced delays in my design because I am merely copying the results from a lookup table which is hidden in the background into a custom html table with the dataTables plugin applied. I wasn't sure how I can apply this kind of pagination to the default Forms table but if anybody knows how to do this, I'd greatly appreciate your input. I'd also be curious if anyone succeeded in applying the dataTables plugin to the default Forms table. 

2 0
replied on January 6, 2023

Table and collection support pagination using new form designer with Forms 11 Update 3.

You can see other changes of Forms 11 Update 3 from  https://support.laserfiche.com/kb/1014413/list-of-changes-for-laserfiche-forms-11-update-3 and get Forms 11 Update 3 from Laserfiche 11 package  https://support.laserfiche.com/kb/1014263/software-versions-and-fixes-included-in-the-laserfiche-11-download-package.  

0 0
replied on July 3, 2020

For everyone looking for this functionality, I have shared a simplified version of my solution here: https://answers.laserfiche.com/questions/175151/Limiting-LookUp-Results

0 0
replied on June 12, 2020

Any update on this request? This is sorely needed.

0 0
replied on June 15, 2020

No updates at this time. We have been working on bringing lookups over to the new form layout designer (along with field rules, formulas...), so won't be able to add additional functionality to those features until that is complete. 

1 0
replied on September 5, 2019

Hey Kentaro,

  So I was looking to do something similar to what you have posted here. Do you still have this done with your table? Do you think you could share how you got it done? Here's the link to my post sort of asking for what you have set-up here. Thanks.

0 0
replied on March 8, 2019

Thanks for the feature idea. I've included this idea in our Forms feature ingestion portal for review.

Did the workaround Chad suggested work? 

0 0
replied on August 2, 2019

Hi Jared,

 

Yes his idea worked. Sorry for the late reply.

 

Ken

0 0
replied on January 22, 2019

Could you add your own pagination by having a show next 10 button, which increments a trigger field by 10. The trigger field being tied to your stored procedure call which returns the next 10 records based on the trigger value.

Then add a previous 10 button with decrements the trigger field.

 

 

2 0
replied on January 22, 2019

Hi Chad,

Thank you for the suggestion. That might work.

I will give it a shot when I have the time.

I still think this type of feature would benefit a lot of users if it's offered out of the box. 

Ken

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

Sign in to reply to this post.