Coffee cups indicate the complexity of a file, tip or article. One coffee cup is the easiest and three is the most advanced.
To download a file, click on the green arrow icon next to the listing. If there are no coffee cups
or platform icons, the listing may be an article, Quick Tip, Knowledgebase or bonus file.
Steven Blackwell has kindly allowed me to share his white paper on the new security features in FileMaker 11. It covers everything from authorizing and deauthorizing files, interaction with Design functions and the new Calculation functions.
I teach a lot of FileMaker courses and I am always surprised at the tremendous number of experienced developers who don’t consider record locking issues in their development. Usually students have heard about the concept but don’t know how to replicate a record locking issue, let alone test for a record locking error in a script. Understanding all aspects of record locking is extremely important to producing a professional FileMaker solution.
Kieren MacMillan showed me his nifty technique for removing leading and trailing carriage returns from a text field. This is a common technique for correcting data entry errors or constructing return-separated lists.
I wrote this Script Triggers article for the Everything FileMaker Reference but you can also read it in PDF format here. This article covers pre vs post triggers, trigger order, object vs layout triggers and much more using many useful examples.
Version two of this article appears in the Everything FileMaker 4 Reference from FMPUG. It includes a discussion of the new FileMaker 11 script triggers as well previously existing triggers.
Professional developers pay attention to the number of files in their FileMaker solutions because it’s a crucial factor in good database design. Most developers utilize the standard single file structure because it makes development easier. On larger multifaceted projects, a developer might use several files for separate areas of the company. A smaller set of developers like to use the separation model to avoid issues with updates to their solutions and other benefits that will be explored. It’s very important to choose the file structure the best suits your style as well as the project at hand.
Script Triggers are one of the most fascinating features in FileMaker. Triggers augment existing features like auto-enter and validation as well as introduce completely new functionality not available through button driven scripting alone. The ability to define a script to execute based on a defined event fills so many gaps, their power can never be underestimated.
A matrix of compatibility with FileMaker Pro, FileMaker Pro Advanced, FileMaker Server and FileMaker Server Advanced with links to other articles with more detail.
The Allow User Abort script step is essential for locking down or idiot proofing your scripts. If you don’t turn it off then a user can cancel your script before it is complete using Command-Period (Macintosh) or Esc (Windows). Interrupting a script could leave the user on a developer only layout or halfway through a complicated transaction. Most users don’t even know how to cancel a script but many users know how to accidentally type the right keys at the wrong time. Please consider this a warning!