"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

FileMaker vs Web
FileMaker vs Web

Scripting Primer
Scripting Primer

Finding FileMaker Talent
Finding FileMaker Talent

KISS
KISS

Ultimate Find
Ultimate Find




FREE Beginner Video Training


Quick Tip:

Recovering Files
For some reason, many FileMaker developers think you can recover a file and continue using it. Well, you can if you want to live your life dangerously. Recover is a great tool when used properly. The proper use of the Recover feature is to recover a file and then import the recovered data into a backup of the file which is not damaged. In other words, the Recover feature is for recovering your data not your schema. Even with the new recovery features in FileMaker 10, always remember that FileMaker assumes you are recovering a file because you have no other choice. Therefore, the Recover feature will remove any suspect scripts, fields, layouts and other features it believes could be causing the problem. While the Recover feature could completely fix your file, it's also possible it may not remove all corruption even though the file appears to be functioning properly. For more information on recovery, see the white paper titled "Demystifying FIleMaker Pro File Recovery" by Steven Blackwell, available in the Resources area of the Database Pros web site.



Tips & Tricks Videos


Fun Stuff:

Jaymo
David Knight started calling me JoMo years ago and it kinda stuck. It's evolved from JMO to the current Jaymo but you can call me anything as long as you are friendly. Other nicknames include Hoss, n2 and Wiz.



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.


  Next 10