FileMaker Script - How to perform a find and omit certain records
Here's the script I have currently:

To test I created four work order records in the date range I'm using. In this script I'm telling it to omit one of the work orders from the f开发者_JAVA技巧ind, but it still says "4" for the value of gNumRequestOpened.
Am I misunderstanding how to script a find? Is there a better way to do a find an omit records with certain criteria?
The Omit Multiple Records step is meant to be used outside of a find request to omit a certain number of records beginning with the current record. It's not meant to be used within a find request.
You need to use Omit Record. Replace your Omit Multiple Records step with the following:
New Record/Request
Set Field[WorkOrder::_pk_WorkOrder; "42594"]
Omit Record
加载中,请稍侯......
精彩评论