Show All Records, Omit Record, and Omit Multiple Records in FileMaker

Beginner

Found set management beyond Perform Find: learn how to restore the full found set, omit individual records, and build an inverse found set by omitting a subset.

What you'll learn

  • How Show All Records restores the full found set
  • How Omit Record removes a single record from the found set
  • How to combine a find and omit for inverse filtering

Show All Records resets the found set to every record in the table; Omit Record and Omit Multiple Records remove specific records from the current found set — enabling filtering patterns that Perform Find cannot achieve alone.

1/3
1

Reset the found set with Show All Records

Show All Records places every record in the current table into the found set and unsorts the records. Use it to start fresh before a new find.

FileMaker Script
Show All Records

# Get(FoundCount) now equals Get(TotalRecordCount)
Set Variable [ $total ; Value: Get ( TotalRecordCount ) ]
Commit Records/Requests: when and how to commit in FileMaker scriptsDesigning FileMaker scripts for Data API calls

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo