"No Holding Back FileMaker Blogging"


Navigation:


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



$10.00 Beginner Video Training



Become a patron of this FREE web site!


Recent Blogs:

Twenty Nineteen in Review
Twenty Nineteen in Review

Preventing Duplicates
Preventing Duplicates

Deleting Duplicates
Deleting Duplicates

The Downside of Indexing
The Downside of Indexing

Loss of Focus
Loss of Focus




Create a FileMaker Calendar


Quick Tip:

IsEmpty
I have seen many people, even expert FileMaker developers, check for an empty field by comparing it to to double quotes (""). While this method may work some of the time, it can fail in some situations. Always use the IsEmpty function.



$10.00 Beginner Video Training


Fun Stuff:

FileMaker Developer Worthiness
Top 10 ways you know your developer is NOT worthy:
  1. Spells "FileMaker" with a lowercase "m"
  2. Uses inches or centimeters instead of points in Inspector
  3. Recommends WebDirect deployment over FileMaker Pro
  4. Creates a solution with one file for every table
  5. Doesn't know Claris and FileMaker, Inc. are the same company
  6. Isn't certified for latest version of FileMaker
  7. Isn't an FBA member
  8. Charges less than $100.00 per hour
  9. Uses a rainbow of colors on his interface
  10. Provides a quote without a requirements document



Create a FileMaker Calendar







RSS Feed
Search Results for : All
Twenty Nineteen in Review
Level: Intermediate
Category: General
02/04/2020
I just looked over what happened in the FileMaker world in 2019 and I'm stunned! Doesn't seem like much happened till you consider everything at once. Truly, this has been an eventful and pivotal year for the FileMaker industry. In this article, I'm going to review what happened and what is going to happen at...
Read More
2019 was a eventful and pivotal year for Claris!
Preventing Duplicates
Level: Intermediate
Category: General
01/14/2020
Preventing duplicates from ever being entered in the first place is my personal preference. Sometimes we don't have a choice and have to remove them after the fact. But, if you can stop them from ever being entered, it's going to make your life much easier. In this article, we'll discuss a variety of techniqu...
Read More
Preventing the entry of duplicate records is often the best solution.
Deleting Duplicates
Level: Beginner
Category: Calculations
12/10/2019
Database administrators have nightmares about duplicate data entry. There are tons of solutions out there. Which direction do you go? Do you try to prevent duplicate record entry with validation or scripting? Do you let the duplicates get entered and delete the periodically? And, what about merging two record...
Read More
Duplicates are a nightmare for any database adminstrator.
The Downside of Indexing
Level: Intermediate
Category: General
11/05/2019
Most people don't think about indexing when designing a solution. FileMaker automatically turns on indexing when needed so why should they? Indexing can only be good, right? I mean, it makes finds faster. Well, in most situations, indexing is nothing to worry about. But, under certain circumstances, indexing...
Read More
Indexing makes searches fast but what are the hidden downsides? BTW, this is the first page of the index from the book I co-authored, "Scriptology - FileMaker Pro Demystified".
Loss of Focus
Level: Intermediate
Category: Scripting
10/15/2019
I hear it over and over on the forums, "my Tab Control changes to the default tab when I run a script". What initially seems like an innocent little script that adds a new related record by setting a variable to a primary key, switching layouts, creating a record, setting the foreign key and returning to the...
Read More
FileMaker Tab Control objects lose focus when switching layouts. This article discusses methods for overcoming this problem.
Naming Standards
Level: Intermediate
Category: General
09/24/2019
Just about every serious FileMaker developer has their own personal naming standards for fields, scripts, tables, layouts and anything else that can be named. There's really no correct naming standard. It's all about what works for you and your development style. Still, you need somewhere to start. I'm not ju...
Read More
Naming conventions are standards are an import part of the FileMaker development process.
Restoring Find Criteria
Level: Advanced
Category: Scripting
09/03/2019
Let me start by saying, this is the most complex technique in the series of five articles covering the restoration of found sets. The sequence started with an explanation of why it's important to save found sets, followed by simple solutions like creating new windows and collecting serial numbers. I even cove...
Read More
Restoring search or find criteria is the hardest technique in this 5 part article series.
Snapshot Saves
Level: Intermediate
Category: Scripting
08/13/2019
According to the FileMaker online help, the Snapshot Link feature saves a found set of records. But, it saves so much more including the current record, layout, sort order and the mode. The basic idea is to save a Snapshot Link and send it to a colleague via email so they can see what you are viewing. So much...
Read More
The Snapshot Link feature in FileMaker is designed to share found sets with colleagues.
One-Trick Pony
Level: Intermediate
Category: General
07/23/2019
Don't be a one-trick pony and apply the same FileMaker feature to solve every problem. That's like wearing a tool belt and only putting one tool on it. FileMaker has many options, each with it's own unique advantages and disadvantages. Over-relying on a single tool will result in a subpar solution. Try to lea...
Read More
A "One-Trick Pony" is defined as a person or thing with only one special feature, talent or area of expertise.
Forum Etiquette
Level: Beginner
Category: General
07/02/2019
Forums are a great way to get technical advice for FileMaker but for some reason, many people don't think they have to be nice in the electronic world. I was raised to say "please" and "thank you" and that has translated over to the internet for me. But, other folks think the anonymity of cyberspace is an exc...
Read More
Forum etiquette


  Next 10