On vacation, waking up to a dreary Pennsylvania morning…
I found myself staring at the OS X Address Book and wondering, “how did they do this?” I couldn’t help compare this little application to the many FileMaker-based contact management solutions I have seen, and concluding, a bit sadly, Apple’s is nicer.
Continue reading “Inspired by Address Book – Part I: Hiding portal scroll bars”
As you may know FileMaker DevCon 2011 is just around the corner. In honor of 2011…and FileMaker Pro 11, here’s our list of Top 11 Tips for DevCon ’11:
1. Bring a sweater
Those hotels are known for cranking up the A/C. Take a comfortable layer that you can slip on and off easily to ward off the shivers as you’re sitting all morning.
Continue reading “11 Tips for #FileMakerDevCon ’11”
If you’re like most power FileMaker users, you’ve discovered that it’s a great tool for managing collections of things or for gathering disparate data sources for reporting. So you’ve probably wanted at some point to do one or more of these actions:
- Get a list of files on your computer
- Import a batch of files
- Move files on your computer
- Read the text of a file that doesn’t import correctly (e.g., HTML)
Continue reading “Managing Files with AppleScript”
Color is one of the most important tools available to you when designing user interfaces. Using a little color can turn a drab wall of text into something attractive and readable.
Continue reading “Unleashing Mac OS X’s Color Picker in FileMaker”
The attached file demonstrates a technique for opening/closing areas of a record, allowing a user to hide the information they don’t want to see.
FileMaker File: DisclosureAreas2.fp7
Continue reading “Area Disclosure in FileMaker Using Sub-Summary Parts”
Neither I nor my client can anticipate every chart that the solution’s users might want to see. A user’s desire to view a high-level visual representation of their data can be spontaneous and idiosyncratic. This technique allows for the user to create an ad hoc chart, albeit within narrow parameters (i.e. the chart is simple, presents only counts of values, and is pre-formatted).
FileMaker File: ChartActiveField.fp7
Continue reading “Charting from the Active Field”
I recently needed to total up some records in a found set in a FileMaker solution, but I wanted to keep all the revisions within the scripts so that I could easily migrate the changes from the development system to production. This solution also already had quite a few “special case” calcs and fields, and I didn’t want to add any more clutter to the schema.
Continue reading “Use Replace Field to total found set”
If you have a FileMaker system and you need to script the processing of adding or removing files on the server, the first problem you are going to come across is: how do I stop the server from a script?
You may already be familiar with the fmsadmin command. This is present on both Mac OS and Windows installs of FileMaker server. You can simply run the following command in Terminal to stop the server:
fmsadmin stop server
Continue reading “Stop FileMaker server from script”
FileMaker 11 is here! Are you ready for the next generation of the world’s most widely used, easy-to-use database?
As Platinum members of the FileMaker Business Alliance and long-term beta testers with FileMaker, we’ve been testing the new version of FileMaker for a while now and wanted to share some of what we’ve learned.
Continue reading “Top four FileMaker 11 features that improve the user experience”
Most FileMaker Server setups on OSX that I have seen are using the default permissions as set by the FilerMaker Server (FMS) installer. When viewed in the Terminal, they look like this:
drwxrwxr-x 11 fmserver fmsadmin 374 Jul 16 12:54 Databases
Continue reading “Setting permissions for FileMaker Server’s Database folder”
Today we are making bBox, our toolbox of external functions for FileMaker, freely available to all FileMaker developers. Use it to extend the reach of your FileMaker solutions to resources outside of FileMaker by launching and communicating with other programs, utilizing the powerful commands built-in to Mac OS X, and easily creating, processing, and managing files.
Continue reading “bBox FileMaker plug-in: Easily add AppleScript, Shell, Grep, and more to your FileMaker projects”
[Authored by Ian]
In my last post, I described my preferred methodology for integrating Rails and FMP. In this post, I’ll discuss an alternative technique using FMP’s external SQL sources functionality. Since IANAFMPD (I am not a FileMaker Pro Developer), I’ll skip the implementation details and just cut to when it’s an appropriate solution.
Continue reading “Alternative FMP/Rails Integration: External SQL sources”