We want to make sure all our readers, customers, and students are aware that, as of September, FileMaker, Inc. will no longer offer support for FileMaker Pro 8/8.5 and FileMaker Server 8. Also, that’s when your eligibility for upgrade pricing expires! If you have any questions regarding upgrading to FileMaker 11 (what the new features can do for you, what to be aware of when upgrading), drop us a line.
The Support Group Blog
Hi, I’m Julien Lafleur, the director of development here at The Support Group. I’ve been working with FileMaker for well over a decade (in fact I just passed my 10 year anniversary with TSG!), and I’m continually surprised by the many little challenges posed by our customers, and the many creative ways they can be solved.
Way back at the 2001 FileMaker Developer Conference, Rich Coulombre presented a session on integrating FileMaker Pro with all sorts of devices and methods of communication. Then to prove the point, he hooked Bill Bass, the talking fish, up to a FileMaker database.
Yes, it was crazy. But it was unforgettable.
Ever wanted to display event records in a calendar format? Of course you have! And FileMaker Pro 11 makes this so much easier with filtered portals.
FileMaker Pro 11’s new OnObjectValidate script trigger provides us with the ability to control and massage data in ways we couldn’t before. While this trigger is often thought of as a way of adding additional limitations and restrictions on data entry beyond the built-in validation options, you can also use it to ease and allow more flexible data entry.
It’s official: Certification and the FileMaker Training Series are now available for FileMaker 11!
Becoming a FileMaker 11 Certified Developer demonstrates your experience and expertise to employers, clients, and members of the FileMaker community. For us at The Support Group, it’s essential as platinum level members of the FileMaker Business Alliance and Authorized Trainers. FileMaker’s website offers steps to getting certified and a FAQ. Registration and administration of the exam is handled by Prometric.
I’ll admit it: prior to FileMaker Pro 10, I didn’t give much thought to providing users with the ability to view a layout as a table as opposed to a list. List view seemed to have so much more to offer. Formatting was easier to control, you didn’t have to take extra steps to ensure the header and footer would appear, and if, like me, you tend to give your fields arcane “database-y” names like ct_nameFull_lfm instead of Full Name, you didn’t have to worry about those names appearing in the column headers. About the only thing table view had going for it was resizable columns.
If you’ve played with FileMaker Pro 11’s filtered portals at all, you may have discovered its biggest stumbling block: aggregate functions and related data. All of your calculations summarizing related records no longer reflect what appears in the filtered portal. Various solutions have been proposed using script triggers and merge variables, but they can require some foresight and maintenance. Fortunately, there’s an even easier solution for the majority of cases where you need to total up related records.
One of the things I find I need to do frequently is create a variable using a calculated name. For example, I can use the FieldNames function to get the list of fields on a layout. I might want to then declare a number of variables that have the same names as the fields, and then populate them with those fields’ values. Later, I can loop through the fields again, perhaps updating them with a Set Field By Name step, and reference the variable with the similar name.
With keyboard shortcuts for both Mac and Windows users, this convenient reference sheet can help you navigate faster through your FileMaker application. It’s perfect for keeping on your desk, attached to your monitor, or on your wall. It provides all the keyboard shortcuts for browsing, navigation, finding, changing modes, files, editing, formatting, and layouts.