"No Holding Back FileMaker Blogging"


Navigation:


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



Tips & Tricks Videos



Become a patron of this FREE web site!


Recent Blogs:

Preventing Duplicates
Preventing Duplicates

Deleting Duplicates
Deleting Duplicates

The Downside of Indexing
The Downside of Indexing

Loss of Focus
Loss of Focus

Naming Standards
Naming Standards




Create a Password Management solution!


Quick Tip:

Indexing
FileMaker Pro indexes every word in a text field so that finds can be performed quickly. Think of the analogy of a book. Rather than trying to locate something by thumbing through each page, you look in the index and find all the pages numbers at once. FileMaker works in the same way. In order to make finds as fast as possible, the first 100 characters of every word is indexed. If you click into a field and type Command-I (Macintosh) or Ctrl-I (Windows), you can view the index of a field. Most characters are indexed but you may be surprised what characters designate a new word other than a space. The index does take up space, so if a field is not going to be searched on or used as a match field in a relationship, set the Storage Options in Manage Database to never index that field.



Create a FileMaker Calendar


Fun Stuff:

DevCon History
Here's a list of the FileMaker Developer Conferences through 2020:
#  Year  Location
23  2020  Nashville, Tennessee
23  2019  Orlando, Florida
23  2018  Grapevine, Texas
22  2017  Phoenix, Arizona
21  2016  Las Vegas, Nevada
20  2015  Las Vegas, Nevada
19  2014  San Antonio, Texas
18  2013  San Diego, California
17  2012  Miami Beach, Florida
16  2011  San Diego, California
15  2010  San Diego, California
14  2009  San Francisco, California
13  2008  Phoenix, Arizona
12  2007  Orlando, Florida
11  2006  Orlando, Florida
10  2005  Phoenix, Arizona
9  2004  Phoenix, Arizona
8  2003  Phoenix, Arizona
7  2002  Palm Desert, California
6  2001  Orlando, Florida
5  2000  Palm Desert, California
4  1999  San Diego, California
3  1998  Monterey, California
2  1997  San Jose, California
1  1996  Santa Clara, California



The Philosophy of FileMaker recommends PCI!







RSS Feed
Search Results for : All
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
Best of FileMaker Eighteen
Level: Intermediate
Category: General
06/11/2019
It took a while to scour the internet but I finally came up with my favorite videos and articles. I personally read each of these blog articles and watched every one of these videos. I've focused on choosing resources that use specific examples, rather than vague general discussions. I wanted to show off auth...
Read More
The new FileMaker 18 sports new features like a revamped import dialog, data file script steps, the While function and much more!


  Next 10