"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

Robust FileMaker Design
Robust FileMaker Design

Phone Filter Part Two
Phone Filter Part Two

Phone Filter Part One
Phone Filter Part One

Trigger Tightrope
Trigger Tightrope

Field Forestry
Field Forestry




FREE Beginner Video Training


Quick Tip:

Globals and Record Locking
Global fields do not cause record-locking when they’re used in a multi-user scenario. In other words, you can click into a global field while someone else is clicked into the same or another global field on the same record. However, selecting a global field does cause record-locking for regular fields on the current record. If a guest is clicked into a global field, then nobody else on that same record can edit a regular field.



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
Robust FileMaker Design 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.
View Blog Entry
Dynamic or Adaptive programming creates a robust FileMaker solution.
Phone Filter Part Two 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.
View Blog Entry
Phone Filter Part One 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.
View Blog Entry
Phone formats come in a variety of styles that can make a list view look scrambled.
Trigger Tightrope 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.
View Blog Entry
Field Forestry 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.
View Blog Entry
Housekeeping fields track changes to records that can be helpful tracking down data entry issues.
To Separate or Not 02/16/2017
Thanks to Steven Blackwell and Colleen Hammersley for sharing their separation model expertise. Without it, this blog entry would not have been possible. Professional developers pay attention to the number of files in their FileMaker solutions because it’s a cru.
View Blog Entry
Should you split your data and interface into separate files or stick with traditional one file design?
In Depth Index 02/14/2017
Indexes make finds fast! But, indexes also support a bevy of other features such as relationships, value lists and validation. This blog entry will explore the definition of an index from a FileMaker point of view as well how it is used throughout the application. The best way to define indexing is by way of.
View Blog Entry
FileMaker History 02/01/2017
Information regarding the early history of FileMaker is adapted from an interview with Spec Bowers by Glenn C. Koenig. Glenn is a FileMaker developer and generalist who lives and works in Arlington, Massachusetts. His business is Dancing-Data. Recent history is written from my knowledge of the industry. The rolodexes from FileMaker 1.0.
View Blog Entry
Nutshell was the beginning of FileMaker!
Easy Naming Conventions 01/15/2017
Just because you researched your project thoroughly, created an ERD and scrubbed it, doesn’t mean you are ready to start programming. The development process is much smoother when you have conventions to follow. Conventions make your databases easier to manage, especially six months down the line when you nee.
View Blog Entry
Common field naming conventions.
Deployment Considerations 01/01/2017
It’s easy to develop a solution on your own computer and hope it will deploy exactly the same on all devices. While this would be a dream come true, the reality of a solution working the same across different screen resolutions, platforms, FileMaker versions and operating systems is unlikely in this modern ag.
View Blog Entry
FileMaker and operating system screen real estate hogs.
Philosophy of FileMaker 01/01/2017
You may be wondering why I named this blog the "Philosophy of FileMaker". Philosophy is defined as the following by Merriam-Webster : 1) the study of ideas about knowledge, truth, the nature and meaning of life, etc. 2) a particular set of ideas about knowledge, truth, the.
View Blog Entry