Log in
Hot & Trending on FMT

MasterDetail 2.0 on Modular FileMaker

Featured MasterDetail 2.0 on Modular FileMaker

I want to start out by saying that if you are a FileMaker developer and have not visited ModularFileMaker you owe it to yourself to do so now. There is such a growing list of great potential tools there including...MasterDetail detects the number of records in the MasterDetailRows table, and constrains the found set based on that number.  If there are 1000 records in that table then a max 1000 records will be found.  There is intelligent messaging displayed to the user about the state of the found set.

Gathers up to 5 Fields in the Found Set

MasterDetail 1.0 only captured the primary ID of the all the records in the found set. As a result, any other data you wanted to display had to be pulled from a related table.  MasterDetail 2.0 can gather up to 5 fields. That means that for most cases you will not have to pull related data into the portal.  You can capture other fields along with the ID, and have the virtual list parse them out into fields.

Virtual Trigger “Before Capture Found Set”

MasterDetail now has a Virtual Trigger that runs just before the found set.  This give you the chance to do things like sort, or further modify the found set before it is captured.  You can learn more about Virtual Triggers in this video.

Use Case

MasterDetail was designed with one main use case in mind.  I wanted the current found set of records to be displayed in the portal in the order that they appeared in the found set. I wanted to have it behave as much as possible like regular old FileMaker,  just display the found set in  portal.  I think it does that pretty well.

However there are some limitations. Its not going to perform well on large found sets when the file is hosted on a remote server.  Anything more than a few thousand records is going to bog down.  Thats why I added the feature to automatically constrain the found set.

Some people may want to use Perform Script On Server (PSOS) to get around this issue. But it won’t work.  The found set is local to the client, not the server. When you call a script with PSOS, it won’t know anything about the local clients found set.

You could certainly extend Master Detail to use other record gathering techniques like SQL, or PSOS, but they would require more work and not be as generally applicable as it is out of the box.

Video

There is a video on all the new features and implementation at geistinteractive.com. Go check it out !

Version History

2.0.2 released 12.22.24

Download

MasterDetail2_0_2.fmp12

Keefer Rogers

Got FileMaker questions...get answers at the ORIGINAL FileMaker Forum with over 42,000 active members!

Whats with all the banner ads you ask! They really help us keep our site online...That's a hint and a reminder!

Website: www.filemakertoday.com/com/forum.php