"No Holding Back FileMaker Blogging"


Navigation:


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



Create a Password Management solution!



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.


The Philosophy of FileMaker recommends PCI!


Quick Tip:

Discontiguous Items
You can select multiple script steps to duplicate, including discontiguous ones. On the Macintosh, hold down the Shift while clicking on script steps to select continuous steps. To select discontiguous script steps, hold down the Command while clicking on steps. Under Windows, hold down the Shift or Ctrl key while clicking. You can move the selected steps, duplicate or delete them. You can even control where duplicated steps are placed. Select an additional step further down in the script and the duplicated steps will be inserted immediately after that step. Just delete the last duplicated step and you have placed your duplicated steps exactly where you desire. This process will also work with just about any dialog presenting a list of items such as fields, layouts and value lists.



The Philosophy of FileMaker recommends PCI!


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.



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