Reference > Script steps reference > Found Sets script steps > Show Omitted Only
 

Show Omitted Only

Finds the records not in the current found set.

See also 

Options 

None.

Compatibility 

 

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 

Originated in 

FileMaker Pro 6.0 or earlier

Description 

Use this script step in Browse mode or Preview mode. If you perform this script step in Find mode or Layout mode, FileMaker Pro Advanced switches to Browse mode after the records have been found.

Example 1 

Shows all omitted records.

Show Custom Dialog ["Show omitted records?"]
If [Get ( LastMessageChoice ) = 1]
Show Omitted Only
End If

Example 2 

Demonstrates that using the Find Matching Records script step instead of Show Omitted Only can be a simpler way to create a found set of only the current record.

#With Show Omitted Only, multiple steps are necessary
#to create a new found set, omit the current record,
#and show only the omitted record.
Show All Records
Omit Record
Show Omitted Only
#A single Find Matching Records script step can perform the same task
#when a field with unique values, such as an Invoice ID field, is specified.
Find Matching Records [Replace; Invoices::Invoice ID]

Related topics 

Script steps reference (alphabetical list)

Script steps reference (category list)