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

Question

Question

Auto fill at a specific time

asked on December 6, 2017

I have a lookup that contains several inputs. I would like to hide the auto fill button. When I do this, the form becomes essentially useless because it is so slow. I see that when I hide the auto fill button, the lookup rule is run every time there is a change in a match field from the form. Is there anyway to have the auto fill button pressed only when a specific input is changed?

 

See the image above. There are 9 inputs. The stored procedure takes ~ 1 second to execute in SQL. However, in Forms it takes about 15 seconds every time the user updates a field because it re-runs the procedure every time something is changed, even when all the inputs have not been added yet. Is it possible to run the look up only when the final input is added "(variabl...>Lot Description"

 

What's odd is if I do not hide the auto fill button and actually press it, everything is quick, but the lookup doesn't seem to work. None of the data that it pulls back is filled in. However, if I hide it and have it auto press, the data is returned correctly, it's just too slow to actually use.

0 0

Replies

replied on December 6, 2017

So if you want to control when the lookup is triggered leave the hide autofill unchecked. Add in javascript to hide the field $('.autofill').hide(); then add javascript trigger on the fields you want to trigger the lookup and call $('.autofill').click();

This wont fix the issue of the manual click not filling the output tho. Id recommend addressing that first.

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

Sign in to reply to this post.