Show Omitted Only
 
Purpose 
Finds the records not in the current found set.
See also 
Hiding records from a found set and viewing hidden records
Creating scripts to automate tasks
Format 
Show Omitted Only
Options 
None.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
Yes 
FileMaker Go 
Yes 
Custom Web Publishing 
Yes 
FileMaker WebDirect 
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 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)
Was this topic helpful? Send feedback.