"No Holding Back FileMaker Blogging"


Navigation:


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



Beginner, Intermediate and Advanced Video Training



Become a patron of this FREE web site!


Recent Blogs:

Everything Changes
Everything Changes

Subsummary Unique Count
Subsummary Unique Count

Scripted Change Log
Scripted Change Log

Abstracted Log
Abstracted Log

Decluttering
Decluttering


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.


Beginner, Intermediate and Advanced Video Training


Quick Tip:

Nudge 10 Pixels/Points
One of my favorite new features in FileMaker Pro Advanced 18 is the ability to nudge objects in layout mode 10 pixels/points at a time. You've always been able to move objects one pixel/point at a time using the arrow keys on the keyboard but now you can throw in the Shift key and nudge them 10 pixels/points at a time. I use it when I want to object to move in one direction horizontally or vertically. The mouse is just not accurate enough and often ends up moving the object both horizonally and vertically.



Document Management Videos


Fun Stuff:

Dull Boy
FileMaker files were stored in clear text prior to FileMaker 7 so, if you opened a FileMaker file in a text editor, you could see the phrase "All work and no play makes Jack a dull boy" in the header repeated over and over. No, it's not a virus! My understanding is the developers just needed to take up some space in the header and that's what they came up with. Today, modern FileMaker files are stored in Unicode so I'm not sure if the phrase is still there.



Beginner, Intermediate and Advanced Video Training







RSS Feed
Search Results for : All
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
Removing Text Formatting
Level: Beginner
Category: Calculations
11/03/2020
Almost every single solution I develop requires a method for dealing with text in fields that is purposely or accidentally formatted in browse mode. For better or worse, FileMaker allows users to change text formatting in browse mode via the Format menu. FileMaker also doesn't automatically remove formatting...
Read More
Formatting text in browse mode overrides layout settings.


  Next 10