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.
DevCon 2005 PresentationTip File
My FileMaker Developer Conference Presentation
If you missed the 2005 Developer Conference, you can still view the slides and files I used in my Philosophy of Scripting and Philosophy of Calculations presentations. I covered creating a monthly calendar with one relationship, no scripts, and no calculations. I also showed how to color the portals in a monthly calendar without any overhead in the child file or scripts or calculations. I also demonstrate how to use GetNthRecord to accomplish tasks faster and better. There is a lot of FileMaker 8 material, but a good portion is FileMaker 7-only.
DevCon 2006 PresentationTip File
My Presentation from the 2006 Developer Conference
I gave two presentations at the 2006 Developer Conference but one was for a class so I can't post it. What I can post, however, is the calendar solution I created in my second session. I have included the actual file, which I created in a little over an hour from scratch, in addition to a more complete solution that I used as a guide for the session. I also include an article, an outline and the commercial version of the solution. So, if you are trying to create a calendar solution or to understand how to modify my commercial version of the calendar, this download will really help you.
No StyleTip File
Remove Text Formatting with a Calculation
FileMaker Pro 7 calculations preserve text formatting from referenced fields -- which can be good and bad. Unfortunately, it is not possible to remove all font characteristics using the Text Formatting functions. Here is a simple formula demonstrating how to remove text formatting including font type, size, style and size. This technique is not necessary in FileMaker 8 using the TextFormatRemove function.
Object Script TriggersTip File
A Compilation of Script Trigger Techniques
This technique file is the example I used when creating FileMaker 10 videos for FileMaker, Inc. It includes object script triggers demonstrating navigation, carriage return prevention, validation, history of field level changes and filtering a list view.
Create Multi-User Preferences using ExecuteSQL
This file demonstrates how to create a preferences section for a multi-user scenario with a different set of preferences for each account. Prior to ExecuteSQL, multiple table occurrences were needed to access the information from each source table. This file will show how to reduce the number of table occurrences in your solution using ExecuteSQL.
Web Viewer ExamplesTip File
Many Examples of How to Use the Web Viewer
I created this web viewer example for my video training -- so there are simple, intermediate and advanced examples in this download. Examples include Google maps, web searches on Google, Wikipedia, Wikinews and more, package tracking with web scraping and PDF display from a local hard drive with the choice of PDF coming from a standard FileMaker open dialog.
Add at TopTip File
Allow Addition of Rows to Portal at the Top
Uses Filtered Portal for entry into child table using a relationship with Allow creation of Record. The filter on the portal is set to 0. Which is Always false and will not display any child records. Therefore it always looks like a blank slate to enter in a new entry. Thanks to John A for submitting this technique.
Basic Conditional ListsTip File
A Basic Conditional Value List
A lot of people ask how to create a conditional value list, so I have created a basic file demonstrating the technique. Nothing tricky here: just a simple conditional value list using drop-down lists or pop-up menus. The example demonstrates countries and provinces. Select a country from the first field, and the second field will display only the provinces or states from that particular country. In other words, the first field filters the list in the second field.
Category ColorTip File
Color Text Based on the Category
This tip has been floating around the internet for years, but only for previous versions of FileMaker Pro. With FileMaker Pro 7 features, a much cleaner solution is possible. No extra fields are needed -- just an auto-enter calculation.
Change Log 2Tip File
Track Changes when Exiting a Field
Thanks to Reed Wycuff for reworking my Developer Conference 2004 Change Log solution so fields that are tracked can be listed in a return-separated list rather than a Case statement. This makes for easier updating of the formulas involved. The original solution requires a plug-in which can be downloaded with my 2004 Developer Conference files.