Omits the current record from the found set, or switches the current find request between finding and omitting records.
Finding records except those matching criteria
None.
Product | Supported |
FileMaker Pro Advanced | Yes |
FileMaker Go | Yes |
FileMaker WebDirect | Yes |
FileMaker Server | Yes |
FileMaker Cloud products | Yes |
FileMaker Data API | Yes |
Custom Web Publishing | Yes |
Runtime solution | Yes |
FileMaker Pro 6.0 or earlier
This script step omits (temporarily hides) the current record from the found set and makes the next record in the table the current record.
Omit Record only operates in Browse mode and Find mode. When this script step is performed in Find mode, it switches the current find request between including records and omitting records.
Omits the current record from the found set if it was created before the current date.
If [Invoices::Date Created < Get ( CurrentDate )]
Omit Record
End If