Hello,
I have a form with pagination and lots of lookup rules. Is there a way to have rules 1-4 run and have the wait for those to complete? I am currently on Forms 11.
Thanks!
If you have the look up rules dependent upon another field getting populated that would update it. So if you use Lookup Rule 1 to populate field A, use a formula to move that value to field B, then you would then have Lookup Rule 2 use the Field B as part of the conditioning to populate Field C.
That is how I have it set up, but it seems like it is running all of the rules before the field is populating.
For example, I have the user select the last name, based on the last name, the first name field populates with a list. Then when the last name and first name match, it populates date of birth. When the first name, last name, and dob match, it populates the ID. All of the other lookups (35 of them) are based on matching that ID. It just loads very slow and I didn't have this issue prior to Laserfiche 11.
Thanks!
Ok that sounds like it may just the setup. My guess is as soon as the last name is selected and DOB fills, it fills in ID which then fills in everything else at once. 3-35 are all running at the same time. If 5-35 are just ID dependent, could you join to use a stored procedure and fill in the rest of your data from one lookup?