"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below or becoming a patron!



Document Management Videos



Become a patron of this FREE web site!


Recent Blogs:

Window Locking
Window Locking

Everything Changes
Everything Changes

Subsummary Unique Count
Subsummary Unique Count

Scripted Change Log
Scripted Change Log

Abstracted Log
Abstracted Log


Meta-Consulting
Meta-consulting is a service Database Pros offers to help other developers over programming hurdles via GoToMeeting. Email John Mark Osborne or call John Mark at (909) 393-4664 to find out more about this service.


Document Management Videos


Quick Tip:

Accurate Placement
To accurately position an object on a layout, select the item by clicking once on it and move it one point at a time using the arrow keys on the keyboard. The arrow keys will also override the Grid feature. In FileMaker 13 and later, Dynamic Guides will also assist you when maneuvering with the arrow keys.



The Philosophy of FileMaker recommends PCI!


Fun Stuff:

FileMaker, Inc.
FileMaker, Inc. or FMI is a wholly owned subsidiary of Apple, Inc. It was once named Claris when it also sold MacWrite, MacPaint, Claris Emailer, ClarisWorks, etc. but changed it's name in 1998 when it focused on FileMaker. FileMaker started out as a DOS application called Nutshell but was shaped into the powerhouse it is today by Claris and FMI.



Create a Complete Contact Manager







RSS Feed
Search Results for : All
Window Locking
Level: Intermediate
Category: Scripting
01/05/2024
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
A simple one-to-many relationship between Companies and contacts.
Everything Changes
Level: N/A
Category: General
09/14/2021
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
The Fireside FileMaker Podcast logo.
Subsummary Unique Count
Level: Advanced
Category: Reporting
08/24/2021
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
Counting the unique subsummaries can be done dynamically with a little ingenuity.
Scripted Change Log
Level: Intermediate
Category: Scripting
07/13/2021
Scripting a change 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. We'll start...
Read More
Scripting a change log can be done many ways but there's only one right way!
Abstracted Log
Level: Advanced
Category: Calculations
05/11/2021
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
Logging changes at the field level can help track down erroneous data changes.
Decluttering
Level: Intermediate
Category: General
04/14/2021
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
Decluttering Manage Database is crucial for professionally designed FileMaker solutions.
Multilingual Solutions
Level: Intermediate
Category: Calculations
03/18/2021
I've talked to other developers, read articles and even attended presentations on how to create multilingual FileMaker solutions. I've always thought to myself... "I'll never have to do this myself" so I only half listened. Now I have a client who needs multilingual field labels, titles, button text, tooltips...
Read More
Multilingual FileMaker solutions require due diligence by the developer to keep performance under wraps.
Why then How
Level: Intermediate
Category: General
02/16/2021
I once asked someone on the forums why they wanted a particular solution. I did this because they were asking for a technique that seemed like a lot of unnecessary work. I was attempting to provide a better answer that met their true needs within the abilities of FileMaker. In other words, why give a man a fi...
Read More
Don't be shortsighted or blinded to other emthods for programming.
Twenty-Twenty in Review
Level: Intermediate
Category: General
01/05/2021
A lot has happened in 2020 but I'm not hear to preach about the pandemic, the presidential race or George Floyd. A ton has transpired in the FileMaker market too! Probably the biggest news is JavaScript and FileMaker living in perfect harmony. But, I'll also pontificate about quarterly releases, Claris Engage...
Read More
2020 in Review!
SVG Ready
Level: Advanced
Category: User Interface
12/08/2020
The SVG button icons that come included with FileMaker are great but there are so many holes in the library. Lately, I've been scouring the internet for free icons to meet the needs of some more complicated client interfaces. When I find a good one, it usually isn't in SVG format so I have to convert it and t...
Read More
SVG


  Next 10