"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

Planning
Planning

Subsummary Sandwich
Subsummary Sandwich

Window Naming
Window Naming

The Front Door
The Front Door

Modular Scripting
Modular Scripting




$10.00 Beginner Video Training


Quick Tip:

Set Field Peculiarities
Maybe everyone else knew this, but I just discovered it: If you don't specify a target field with Set Field then it will set the calculation to the currently selected field. I always knew this to be true with Insert Calculated Result, but I had just assumed that Set Field had to have a field reference to work.



Tips & Tricks Videos


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 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.



RSS Feed
Search Results for : All
FileMaker vs Web
Level: Intermediate
Category: General
04/25/2017
One of the most common FileMaker fallacies is a web browser client will save money. I hear it almost weekly from the people who contact me directly. I get it. Everyone wants to save money. But, just because a web browser is free doesn't mean it saves you money. Yes, FileMaker clients require the p.
Read More
Scripting Primer
Level: Beginner
Category: Scripting
04/18/2017
What is FileMaker Pro scripting? It can be defined as automation, a macro and even a programming language. FileMaker Pro scripting has elements of all these definitions. The original purpose of scripting was to automate the mundane task of printing a report. Since it repeats most of the items under the menus.
Read More
This scripting primer covers important considerations before you ever write your first FileMaker script.
Finding FileMaker Talent
Level: N/A
Category: General
04/11/2017
Back in February, Productive Computing's CEO, Marc Larochelle, was invited to speak to the Association for Computing Machinery (ACM) club at California State University San Marcos. During his talk, Marc showcased the FileMaker platform, including the numerous connection points to other database sy.
Read More
KISS
Level: N/A
Category: General
04/06/2017
In the last few years, I've subscribed to the KISS methodology (Keep It Simple Stupid). Call it wisdom or humility, I'm not sure which. All I know is, after over two decades in the FileMaker market, I've discovered the simplest solution is most often best for my clients. It costs less and performs better, in.
Read More
Keep it Simple Stupid!
Ultimate Find
Level: Intermediate
Category: Scripting
03/28/2017
When I first started teaching FileMaker scripting, I went through the entire list of script steps and provided a simple example of each one. By the end of the third day, we had covered every script step but with no depth. More questions remained than were answered. That’s when I decided to focus on the most i.
Read More
Creating a search script is a must for any professional FileMaker solution.
Robust FileMaker Design
Level: Expert
Category: General
03/21/2017
Have you ever inherited a system built by someone else, changed a field’s name and everything stopped working? The issue, hardcoded names used in indirection, makes the system fragile. FileMaker provides developers many methods to add flexibility using indirection. However when these instances of indirection.
Read More
Dynamic or Adaptive programming creates a robust FileMaker solution.
Phone Filter Part Two
Level: Advanced
Category: Calculations
03/14/2017
This is part 2 of the phone filtering solution. If you haven't read part 1 then it's a good idea to start there. Even if you are familiar with filtering phone numbers already and just want to read about the recursive version, it's still best to read part 1 to familiarize yourself with the approach. And, y.
Read More
Phone Filter Part One
Level: Intermediate
Category: Calculations
03/07/2017
Phone formatting is one of my favorite techniques because it teaches so many important concepts. The interaction between a complex formula, auto-entry and validation is fascinating to me. There are so many possibilities, as well as potential hazards, when combining different components. When you get the hang.
Read More
Phone formats come in a variety of styles that can make a list view look scrambled.
Trigger Tightrope
Level: Advanced
Category: Scripting
02/28/2017
Script Triggers are one of the most fascinating features in FileMaker. Triggers augment existing features like auto-enter and validation as well as introduce completely new functionality not available through button driven scripting alone. The ability to define a script to execute based on a defined event fil.
Read More
Field Forestry
Level: Beginner
Category: General
02/22/2017
It’s easier to type in all your fields at one sitting and never enter Manage Database again. However, most people can’t plan a solution that extensively and frankly, it really isn’t necessary. FileMaker is very forgiving and will let you add, change or delete fields and automatically update all references or.
Read More
Housekeeping fields track changes to records that can be helpful tracking down data entry issues.


  Previous 10 | Next 10