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

The Leading Filemaker Developer Tools

MasterDetail 2.0 on Modular FileMaker – FileMaker Today

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


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

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