Sub Totals and Separation
A number of users in various online forums have observed that when one uses the separation model, relational aggregates do not always update in a timely manner. This demo provides some work arounds.

Zip

Counting Unique Entries
Five methods for counting unique entries under a variety of circumstances.

Conditional Sub-Summaries
This one makes perfect sense when you see it, but is a mouthful to try to explain. Say you have sales data, and you want to run a summary report by sales status and sales person, but for one particular status, you want to additionally summarize by sub-status. This demo, co-authored with Mark Rubenstein, shows a technique to accomplish this (cleanly) within a single summary report.

Zip

Preserving/Restoring found sets
A simple technique for preserving and restoring found sets.

Zip

Simple "Fast Summaries"
Based on the ground-breaking "Fast Summary" techniques of Mikhail Edoshin -- this demo shows how to very quickly generate a summary report in a text field without ever leaving browse mode.

Zip

FM 8 or higher required.

Auto Format Child Data in Portal based on Parent
This demo was created in response to a challenge on one of the lists: for a given contact record, in a portal show all other records from the same state, but bold the records that are from the same county -- no scripting allowed. I don't think this would have been possible prior to FM 8, but $$ variables make it a piece of cake.

Rev: 8/22/06 -- Mac-incompatabilities now resolved and  portal redraws now improved thanks to tips from Jason DeLooze & C. J. Weigand.

Zip

FM 8 or higher required

Dynamic Replace
Have you ever wished you could easily transform a bunch of fields in your database without either having to do it manually or by having to "hard code" a bunch of script steps? This demo shows how a script can walk its way through all the fields on a dedicated layout, apply a desired transformation, and then stop once all the fields have been processed. Requires FileMaker 8v3 or higher.

Zip

FM 8v3 or higher required.

Simple Filtered Portals
Some basic ways to filter portals, using multipredicate relationships and "theta joins" (joins where the relational operator is something other than "=").

Zip

Household Mail Labels
It's a common problem: You have multiple contact records per household, but you don't want to send multiple pieces of mail to that household -- furthermore, you'd like all contact names to appear on the one mail label that you do generate. Here is one approach that avoids self-join relationships, and therefore is "found-set friendly." Requires FileMaker 8 or later.

Zip

FM 8 or higher required

Linear List from Values in a Repeating Field
Two methods to accomplish this -- one using ValueListItems() and the other using a recursive custom function.

Zip

Absolute Layout References
Wouldn't it be nice if there were some way to target a layout by its internal ID? This demo includes two custom functions -- one to get the layout ID, and one to translate it to the current layout number so your scripts can "go" to it.

Zip

International Addressing
This demo shows an approach to dealing with the "interational addressing" conundrum -- namely, how to correctly format mail labels to be acceptable to non-U.S. post offices. Thanks to the Evaluate function, it's not as complicated as you might think.

Zip

Repeating Lookups -- co-authored with Bruce Robertson
Three simple, but progressively more complex, examples of things you can do with repeating fields and lookups. Thanks to Ugo Di Luca for suggesting the calculated self-join aggregate in the child table.

Zip

My School -- courtesy of Jimmy Jones
A nice example of, among other things, a) how a single "people" table can accommodate multiple roles, and b) scripted navigation within a FileMaker 7/8 file

Zip

State-Awareness
Buttons that grey-out, and/or change text, depending on the "state" of your solution... plus a way to make it really obvious to your users when they're in Find mode.

Zip

Contact Locator
Locate and navigate to matching records via a filtered portal... includes "clickable sortable" column headers and sort indicators, for both portal and list views.

Zip

Restart Running Total at Subsummary Break
Created in a response to a challenge posted on one of the lists.

Zip

Flexible Naming
Two techniques to allow your users to specify which comes first in a concatenated name field: the business or the individual.

Zip

Portal Sorting
Utilizes a number of new-to-FM7 features, including multipredicate relationships, script parameters, and a global calculation.

Zip

Strange Arguments
Zero and/or negative numbers can be used as arguments for a number of FileMaker functions. This demo also shows how the Floor and Ceiling functions can be coerced into accepting a precision argument.

Zip

FMP: 5/6/7/8

Zip