"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:

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.


The Philosophy of FileMaker recommends PCI!


Quick Tip:

Acronyms
Here's a List of Acronyms that are Handy when Discussing FileMaker Online:
Acronym  Translation
GTRR  Go to Related Record
PS  Perform Script
PSoS  Perform Script on Server
FM  FileMaker
FMP  FileMaker Pro
FMS  FileMaker Server
WD  WebDirect



Document Management Videos


Fun Stuff:

Linux
FileMaker Server briefly ran on the Linux platform but was abandoned when FileMaker 7 was released. People still request Linux support to this day.



Create a Password Management solution!







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