"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




The Philosophy of FileMaker recommends PCI!


Quick Tip:

Creeping Labels
Does the information on your labels creep up or down such that the last labels on the page are at the top of the label? The most-likely reason the labels are creeping is due to the Body part being too big or too small. However, let's start with the first row of labels. Does the first row of labels hit exactly where you want it to? If the labels are too low, decrease the size of the Header part. If they are too high, increase the size of the Header part. Once you have your first row printing correctly, move on to the rest of the rows. If they are creeping up, you need to make the Body part bigger. If they are creeping down, you need to make the Body part smaller. When you change the size of the Body part, any change is multiplied over the number of rows of labels you have. Change the Body size as much as the difference in position between the first and second rows of labels and all the labels should adjust correctly. It may take a few tries.



Create a FileMaker Calendar


Fun Stuff:

Claris Commercial
Few people know that Claris produced a commercial and it aired on national television. It was one of those favor things so it only played once. I'm not saying it's anywhere close to the impact of the Apple Super Bowl commercial but it's fun to have a look. Download the Claris commercial



Document Management Videos







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