We are Excelisys! We offer consulting and development services for database and web site applications! Our clients range from individuals and small businesses to large organizations. If you are looking for an exceptional team of problem solvers, you’ve found it. Contact us today for a free initial estimate so we can know more about you and your needs!

Drag–and–Drop in FileMaker Pro 10
(white paper and demo)

With this amazing demonstration file and accompanying white paper, you’ll learn a technique on how to provide familiar and elegant drag–and–drop functionality to your FileMaker Pro solutions! (Requires FileMaker Pro 10)

Portal Sort Extreme
(white paper and demo)

We are reasonably certain that sometime in the future, FileMaker will add a script step called “Sort Portal Rows.” Until then, building a user–controlled variable portal sorting interface involves a couple of fields, a calc or two, and a script. This demo and white paper will show you how.

Recurring Events
(white paper and demo)

“I need a reminder to pop–up every month to close out the books.” “I want our readers to have the option of auto–renewing their subscriptions.” There are lots of reasons to use them. This file, along with the accompanying documentation, demonstrates the steps needed to implement true recurring events in FileMaker Pro.

Hierarchical Portals
(white paper and demo)

This demo and white paper outlines how to create hierarchically organized portals in FileMaker Pro, similar to the Macintosh Finder’s list view or Window’s Explorer view. It utilizes FileMaker 7 features to enhance the interface, but this method can be used with versions as early as FileMaker 4.

Calendar Navigator
(white paper and demo)

One of the staples of many FileMaker solutions is the calendar navigator. It provides a quick, easy and intuitive way to specify dates and date ranges. In previous versions of FileMaker, one had to either create a large number of calculation fields or (more elegantly) use pre–created graphic calendars and link to them with a concatenated key. Since FileMaker 7, all that has changed. Check out this demo and white paper, and find out how!

Audit Log
(white paper and demo)

An oft–requested feature for FileMaker Pro solutions is an audit log – the ability to track relevant changes to a record. This tip, accompanied by a white paper PDF, outlines how to do just that. This method will automatically track each change to the fields the developer specifies, including who made the change, when, what the old value was, and what the new one is.

Recursive Calculations
(white paper and demo)

The ability to create Custom Functions in FileMaker Advanced introduces the possibility of looping calculations, otherwise known as “recursion.” In this demo you’ll see several good examples of recursive calculations in action. A complete white paper covering this topic, which de–constructs the example calculations, is included as a PDF within the file authored by our own Andrew Persons.