I have a client that (for the sake of this question) has a template that has PO# & Vendor #. They want to be able to type a PO # (out of their 250,000+ open PO's) and it fill in the vendor # in real time.
The first option I tried was creating standard dynamic dropdowns (knowing this would take forever to load) and after 10 minutes waiting for the PO# dynamic field to load I passed on that.
Next I updated the MaxDropDownLength attribute (via help from this post https://answers.laserfiche.com/questions/55871/lookup-list-length) to where the dropdown was limited to 100 rows. This sped up the process to taking around 24 seconds to load the PO # dynamic field so it was considerably faster but not fast enough.
I then switched it around to where they entered the Vendor # first (8,000+ of those for those open PO's) and that cut it down to 8 seconds to load but they do not know the vendor #'s at data entry time.
Finally, I looked into a stored procedure but it appears that the old method for creating dynamic dropdowns (covered here https://answers.laserfiche.com/questions/80332/how-can-I-run-a-stored-procedure-in-dynamic-Fields) does not allow you to pass in values from one field when it runs for another.
Without writing a custom app/button that fills in that data, does anyone know of a way that allows the user at scan/snapshot time to quickly:
- Type the PO #
- Fill the corresponding vendor # in real time (without saving, putting it through Workflow, Forms, or QuickFields)