|
|
|
Search Results for : All
|
|
|
|
It's pretty easy to format a number field as currency, especially if it's a standard field. Once you enter the realm of merge fields, formatting a number can sometimes become difficult when multiple merge values need to display in a different format. For example, you might need a single text block to display... |
|
Read More
|
|
|
|
|
|
|
In a relationally sound FileMaker database solution, you will definitely need portals. When you have a one-to-many relationship, the most common way to display the many related records from a layout based on the parent is to employ a portal. But portals don't always do what we want. Sometimes you need to enha... |
|
Read More
|
|
|
|
|
|
|
I've been using pickers in customer solutions for years but always as a single choice interface. It dawned on me, after reading a post in a forum, that it's often advantageous to make multiple selections, instead of having to keep clicking the picker buttons for multiple single choices. In this article, I'll... |
|
Read More
|
|
|
|
|
|
|
Consistent data entry is one of the hallmarks of a well-designed FileMaker database. It allows a user to run accurate reports and perform reliable sorts and finds, just to name a few important features. Popups and Pickers can assist in the integrity of your data, allowing you to control how users enter data... |
|
Read More
|
|
|
|
|
|
|
Window locking is akin to record locking and is considered the same error when it comes to the Script Debugger (301). Essentially they are the same except that window locking doesn't require the FileMaker solution to be hosted on a server to reek havoc with scripting and manual editing of records. In other wo... |
|
Read More
|
|
|
|
|
|
|
Michael Rocharde and I started the Fireside FileMaker podcast way back in 2019. We've recorded 45 episodes along with our good friend Marc Larochelle. But, all things come to an end... at some point. I'm proud of the work I've done on the Podcast so I want to share some of my favorite episodes. There will als... |
|
Read More
|
|
|
|
|
|
|
Over the years, clients have asked me for a variety of reporting features that aren't easily created with standard subsummary and summary tools. A lot of them, including this technique, use the GetSummary function. I remember having such a hard time wrapping my head around the GetSummary logic when I was work... |
|
Read More
|
|
|
|
|
|
|
Scripting a change log (Audit Log) table has been around since script triggers were introduced in FileMaker 10. But, do you know the right way to script a field modification log? I've been programming them for years and have gone through every version of them and have settled on what I'm going to cover today... |
|
Read More
|
|
|
|
|
|
|
A long, long time ago, in a far away land, Bob Cusick, of Clickware, sent me a tip file that used a single field to log changes to fields in a table. Through the years I modified it and released it many times but here’s the latest version. This version is so abstracted, all you need is a single custom functio... |
|
Read More
|
|
|
|
|
|
|
FileMaker, Inc. and Claris have been waging a war against Manage Database clutter for over two decades. In the early days of FileMaker, let's say FileMaker 3.0, there was no need to worry about packing too much into Manage Database because people weren't designing complex solutions like they do today. These d... |
|
Read More
|
|
|
|
|
|
Next 10
|
