Prevent database lookup on forms load

asked on December 12, 2018

Hi, I have a form where users select multiple drop downs in a collection to validate a GL code from database lookup. Each drop down is populated through database lookup as well. When the form is assigned to a user task, assigned user is able to reselect the drop downs as well.

When you have more than 20-30 lines in a collection, the forms takes 2-5 min to load the forms in user task. This is due to the lookup being triggered on the forms load again.

Is there a way to prevent database lookup on the forms load. Only do the lookups when the fields are changed?

Please let me know if there is a workaround or Java Script for this.

Thanks!

3 0

replied on December 19, 2018

Thanks for the feature request. I've linked this post to the feature ticket and we'll look into implementing this feature in a future release.

5 0

replied on December 19, 2018 • Show version history

I'd like to second this request.

Maybe a good way to implement this would be similar to the button that was added to enable/disable lookups.

I'm thinking there could be a similar button or checkbox labeled "run on form load" or something along those lines.

This way, we could selectively run lookups on form load without it firing off everything for much better efficiency on complicated forms; although it should probably still trigger the "on load = disabled" lookups if the trigger field is populated via URL parameters.

4 0

Question

Question

Prevent database lookup on forms load

Replies

Sign in to reply to this post.