Managing Lookup Execution: How to Disable Lookups on Load

Introduction: Lookups are incredibly useful in Laserfiche Forms, but there are times when you only want them to run under certain conditions. If a lookup depends on another field’s value, it may not make sense for it to fire the moment the form loads. In this example, we use a small JavaScript check to cancel the lookup on load when it isn’t needed yet.

Test Version: Tested in Laserfiche Forms Professional Version 12.0.2503.10388

Setup: Download codes from Bait and Tackle.

Cancel lookups upon form load - Modern Designer

1. Add a Table to your form.

This table will display data returned from a lookup.

2. Add the fields to the table that will be populated from the lookup source.

Ensure the fields align with the columns returned by the lookup table or stored procedure.

3. Configure the Lookup Rule for the table.

With a field in the table selected, select Rules → Lookup Rules, then select the Table/View or Stored Procedure used to populate the table.

4. Add a Single Line field to act as the lookup trigger.

This field controls when the table lookup runs.

5. Insert the Day 22 JavaScript from the Bait and Tackle library into the form’s JavaScript editor.

6. Update the script configuration.

Adjust the trigger field ID, the controlValue used to stop the lookup from running, and the Lookup Rule ID to match your form.