This is a quickie: If you were using the beta release of the PHP API for FileMaker, there are some things you should know.
Month: September 2007
FileMaker Dictionary Functions
Since many people were impressed with my named parameters article, I decided to write up another post about the dictionary functions. Actually in all fairness I think three people actually liked it. Vincenzo Menanno, Chris Wack and Sam Barnum this post’s for you!
The Secret Life of Find Mode: Omit
Today’s Find mode article is short-and-sweet. If you ever feel it would be easier to tell FileMaker what you *don’t* want it to find, the Omit checkbox is your friend. In fact, you can use this esoteric Find mode widget to create incredibly complex queries that target exactly what you want.
Importing Records to a Backup – Brute Force
Your FileMaker Server loses power. All your files have crashed. What do you do now? The safest practice is to go to a backup. Sure, this sounds like a daunting task, but it is surprisingly manageable. The best part is that you won’t lose any sleep worrying about how long your baling wire and bubble gum files will last.
Limiting Checkbox and Radio Button Choices
Did you know that if you shift-click on a field formatted as radio buttons, you can select more than one choice? Even if *you* don’t know this, chances are some day some *user* will figure it out. Yuck. Here’s a short-but-sweet technique to deal with the problem. And you’ll see how to apply the same concept to do some cool stuff.
Detecting Related Records
If you have a relational database (one with several connected tables) and you do any scripting at all, you’ll almost certainly ask yourself a question at some point: How can I tell if the record I’m on has related records? This article explains the scenarios you may run in to, and how *best* to deal with them.