Going Strong For
Where Data & Design Combine, To Increase Your Bottom Line
The collective talent pool here at Excelisys have spent years working with Filemaker Pro, MySQL and various other technologies. Having learned our fair share of tricks of the trade, we sometimes enjoy giving back to the developer & private community at large by sharing some of these quaint little tidbit collections of 1’s and 0’s. So here’s an assortment of various stuff that you can put to use right now as is, or tweak and use in your own solutions. Many of these demos contain embedded PDF white papers explaining their specific technique and useage. Have fun! And let us know if there’s a particular tip you’d like to see posted here! Enjoy!
PLEASE NOTE – THESE ARE “AS–IS” – PLEASE USE AT OWN RISK, WE DO NOT PROVIDE ANY WARRANTIES OR SUPPORT!
Drag–and–Drop in FileMaker Pro 10
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
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
“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
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
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
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
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.
Designing Pop-up Menus
Authored by Geoff Ryle.
Excelisys.com