Hi,

I need a script to find a category of equipment available during a date range. So I need to find the category then omit those category items with schedules that fall within the specified date range. The category and date range will change every time the script is used.

One way to do it would be to use the "Perform Find" script step but it doesn't seem to allow for variable find criteria (is that right or am I missing something?).

Another approach would be to use "Enter Find Mode" and use "Set Field" to enter the search criteria with multiple "Requests" but with that method there's no way to set a "Request" to Omit (again, am I right about that or is there a way to set Omit?).

Or I could find the equipment category then use the "Constrain Found Set" script step but that uses the same "Edit Find Request" dialog that does NOT allow variable search criteria.

Anyone have any ideas? Thanks.

From the Help file:

Omit Record script step

"When the step is performed in Find mode, it causes the find request to become an Omit request, as if the Omit checkbox had been selected."

Enter Find Mode

New Record Request

Omit Record

Set Field[]

Perform Find

Not sure if it matters if you place the Omit Record step before or after the Set Field step. I'm guessing it doesn't matter.

Thanks very much, that solves my problem and eliminates yet another patch of ignorance from my sorry brain.