ISO FileMaker Magazine

Working with dates can seem like a confusing endeavor at first. But after you know which pieces to go after, you can easily put together your own calendar application or any other solution that requires date based calculations.

This video article covers the essential parts to working with dates and making the calculations work within the realm of user-friendly features. Learn how to date-shift a work week and how to turn a popup day value into a number needed by date calculations.

This video article is a short walk through of a useful technique that shows you how to use key combinations to quickly increment and decrement the values in a date field.

The technique also exposes you to a universal approach to scripting, where one script will function in multiple situations. Learn the power of creating a universal script.

Because a database typically contains information about a wide variety of elements, it's not uncommon to need to interact with other files, and sometimes applications, outside of FileMaker Pro. Prior to Version 6 this required the use of a third party plug-in.

If you're using FileMaker Pro 6 then you have access to a new function called Status(CurrentFilePath). In this video I take a look at maximizing this feature and providing the whole range of services that can be used. You can launch a local file, a file from a shared file server, another FileMaker Pro file on a FileMaker Server, a URL or even open another application or folder. This powerful solution is extremely useful if you need to interact with any other files stored outside of FileMaker Pro.

It's the age old question most commonly asked about a database that manages data from multiple sources. "How do I remove duplicates?"

As always, there's more than one road into Rome, and you can tag duplicates using a script or by disallowing them into the database upon import. But when you need to visually see the duplicates and compare records based on the most recent then you need the easiest and best way possible. That's where this article solves the problem. Watch this video and use the technique file to see how it's done.

FileMaker Pro can only go so far when pushing the limits of creating that true "custom software" look and feel. The Replace menu option is the bane of every developer who forgets to disable it.

In this video and text article I take a look at two powerful plugins that allow you to customize your FileMaker Pro user interface to the level of professional applications. You can create your own menus with MenuControl and associate them to your own scripts and you can use SimpleHelp to add the equivalent functionality of Tool Tips.