Learning Claris FileMaker

How many times do your customers ask for a portal showing sales or purchasing history of a product?

Or maybe an invoice history for a customer. In most of these situations, they want the portal sorted newest to oldest.

If there will only be a few dozen related records, then the fix is simple, just configure the portal to sort descending based on a field like Creation Timestamp or Serial ID.

However, when there are hundreds or even thousands of related records this can become very problematic and a real performance dog.

The same can be true of list views, or even sorted relationships.

Sorting is certainly always a red flag when it comes to performance as the data set grows.

This is even more pertinent with a WAN-first methodology.

Sorting module for Filemaker Pro
 
QuickSort is a small module for Filemaker Pro, which simplifies the sorting of tables.

It can be used in all those instances where simple table views must be sorted quickly to any field of that table.

Look for more on the blog post

With FileMaker 16, we no longer have to rely on custom functions to get SortValues and UniqueValues.

Learn the in's and out's of these two new functions.