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
精彩评论