New Leaf Data

One of the many great new features in FileMaker Pro 12 is modal windows. In this screencast I demonstrate how to use a modal window to add and edit a record. The same layout is used for adding and editing a record and the technique requires two scripts. There is a caveat to this technique and this is the real purpose of the screencast. The second script uses the Revert Record script step which will delete a newly created record as well as undo any changes to an existing record. However, if the user commits the record then the record cannot be reverted. Fortunately, this is easy to solve.

FileMaker Pro 12's new grid tool allows developers to create layouts similar to using a CSS framework such as 960 Grid. John Mathewson of Kyo Logic, LLC does an excellent job of demonstrating the new grid tool in his FileMaker Academy webinar "Layout Mode Enhancements". This file is meant to compliment the grid demonstration in that webinar.

As FileMaker Pro developers we are often required to take a flat file and normalize it. Here are the steps that I take to normalize a database in FileMaker Pro 11.

Sometimes we need to put our FileMaker data on the web. However, it doesn't always require user interaction. Enter DataTables - a jQuery plugin!

Once a user has limited access to the database, it is best to restrict their navigation. To accomplish this, we create a dynamic navigation bar that changes with the user login.

Sometimes individuals and organizations can be the object of an entity. For example, a membership database might have a person (e.g. Jane Doe) as well as an organization (e.g. Doe Technologies, Inc.) listed as members.
The party model is a logical model that offers flexibility in such instances. Implimenting the party model in FileMaker Pro 11 can be a little tricky. Here is my version.

Displaying or hiding data based on user login is a common feature to many applications. Here is one way to accomplish this in FileMaker Pro 11. The initial login username: "Abigail". No password.