The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

New! Found Set Portals in #FileMaker 17

Get real time updates directly on you device, subscribe now.

The new Found Set Portals (Master-Design Layouts) feature in FileMaker 17 allows you to merge form and list view to create incredible new interfaces.

Now, this feature is a doozy and likely to spawn tips and tricks for years to come. The new feature allows a portal to show records from the current found set. That’s right, no self-join relationship necessary! So, how is this useful? Imagine merging a form and list view. There’s no need to click back and forth between a separate form and list view layout. Just click on a portal row and the context of the Body part is changed to the selected row.

Seventeen is Prime

SIDE TIP: You don’t need found set portals to merge form and list view. Just create a list view layout and place the form view fields in the header or footer. The only drawback is the form information is always at the top or bottom of the screen. With a portal and FileMaker 17, the location of the form information is back to the body and the portal showing the list can be placed anywhere in the body part, allowing for more interface flexibility.

Found set portals will also enhance pickers or choosers. If you’ve ever created a picker, as a replacement for popup menus, you know what a pain they are to create from scratch. With found set portals, there is no longer a need to create relationships, calculation filters, complicated compound keys or sophisticated scripts to support pickers. Just create a layout with a portal, choose the current table and use a scripted find to change the found set (which will in turn change the content of the portal). Just add a simple button on the portal row to select the ID and you can place the ID from any portal row in any foreign key you want. How easy and cool is that! Say goodbye Selector Connector and say hello to proper use of the Anchor Buoy relational paradigm.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More