ISO FileMaker Magazine: FileMaker Video Tutorials, Templates, Help & More

by Matt Petrowsky

Article options

• Watch Preview Video
• Watch Full Version
• Download Technique File
• Download Movie File

Little by little, newer versions of FileMaker have been making it easier to accomplish tasks which typically required "workarounds" to provide certain features.

When it comes to filtering portals, the previous method was to use a dedicated relationship in order to filter out related data - which is still valid in a variety of situations. However, with the release of FileMaker 11, the new filter portal option, presented as a check box on the portal settings dialog, offers a much easier method for filtering portals.

Initially, there were some harsh critics, as the filter was a "display only" feature and did not adjust calculations which used the same relationship. Enter a few pieces of critical know-how and you get the exact feature you were expecting with all the bells and whistles.

This video showcases how to fully leverage the new filtered portal option within FileMaker 11. The example shown is one of the most common, where filtering is done on both a first and last name where either part contains a sequence of characters. If you're seeking that ultimate degree of filtered portal polish, then look no further than this video!