"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

Saving a Found Set
Saving a Found Set

Preserving Found Sets
Preserving Found Sets

Multi-User Contradistinction
Multi-User Contradistinction

Reconciling Record Locking
Reconciling Record Locking

Eating Your Own Dog Food
Eating Your Own Dog Food




$10.00 Beginner Video Training


Quick Tip:

File Maintenance
FileMaker has three methods for optimizing files. The Save A Copy As feature is available in FileMaker Pro, Developer and Advanced. This feature allows you to save a compacted copy but not like WinZip or Stuffit. A compacted copy is a duplication of the file compacted and optimized. FileMaker stores data in blocks and, when information is deleted, those blocks may become partially full. Compacting a file merges partial blocks, so there are fewer and fuller blocks -- thus creating a smaller file. Optimizing a file is a lot like optimizing your hard drive. Blocks are swapped so that data in records are grouped together. Scripts, Fields and other areas of FileMaker are also optimized to increase performance by allowing similar data to be accessed sequentially. The File Maintenance feature in FileMaker Developer 7 and FileMaker 8 Advanced simply splits these two tasks into separate features. The big difference is that the File Maintenance feature works on the current file, so you don't have to swap out the old copy for the new one.



Tips & Tricks Videos


Fun Stuff:

Dull Boy
FileMaker files were stored in clear text prior to FileMaker 7 so, if you opened a FileMaker file in a text editor, you could see the phrase "All work and no play makes Jack a dull boy" in the header repeated over and over. No, it's not a virus! My understanding is the developers just needed to take up some space in the header and that's what they came up with. Today, modern FileMaker files are stored in Unicode so I'm not sure if the phrase is still there.



RSS Feed
Search Results for : All
Keeping the Faith
Level: N/A
Category: General
08/29/2017
Steven Blackwell almost always starts a phone call with "greetings and salutations" and often ends with another famous quote, "keep the faith". I've never asked what he means but I'm pretty sure it's not religious. Steven Blackwell loves the FileMaker platform and he likes other people who feel the same as he.
Read More
The illustrious Steven H. Blackwell.
Planning
Level: Intermediate
Category: General
08/08/2017
I've seen a lot of databases in my twenty plus year FileMaker career. I like to call them the good, the bad and the ugly. Some are so beautiful, I am instantly inspired by their brilliant interface and subtle programming. Others are ugly inside and out. Some trick you by looking good on the outside but are so.
Read More
The basic invoicing solution ERD showing the join table.
Subsummary Sandwich
Level: Beginner
Category: Reporting
07/25/2017
The biggest mistake I see amateur developers make is using relationships and calculations to create reports. They work great in single-user mode with test records. Put that same solution in a multi-user environment with thousands of records and performance starts to grind to a halt. Add a WAN into the mix and.
Read More
An example report using subsummary parts and summary fields.
Window Naming
Level: Advanced
Category: Scripting
07/11/2017
So, what's wrong with the default window name given by FileMaker? Imagine a user of your solution has multiple windows spawned on a small screen and goes to the Window menu to select the desired window. Without good window management, all he sees is "CONTACTS", "CONTACTS - 2", "CONTACTS - 3" and so on. With g.
Read More
Good window naming management can make it easier for users to locate the window they want.
The Front Door
Level: Intermediate
Category: Scripting
06/20/2017
Even before Script Triggers were officially named, there were Open and Close scripts. Only till object and layout Script Triggers were introduced did Open and Close scripts get labeled as File Script Triggers. For the most part, all that's changed is how they are specified. To set a script to run on opening o.
Read More
An opening door!
Modular Scripting
Level: Intermediate
Category: Scripting
06/06/2017
When you start writing scripts for the first time, they are fairly simple and can be understood quickly. Even weeks or months down the line, the name of the script should be enough to identify the functionality. As your scripts increase in complexity, you need to consider modular scripting. Modular scripting.
Read More
Legos are a good analogy for modular scripting in FileMaker.
FileMaker Videos
Level: Intermediate
Category: General
05/30/2017
I normally don't like to directly advertise products and services on this blog but there is real FREE content here. What I'm going to do is provide inline videos from part one of my new FileMaker 16 three part video series. I'll discuss why the lessons are important and provide some insight as to how they fit.
Read More
FileMaker 16 videos covering scripting, calculations, reporting and relational design.
Compare and Contrast
Level: Intermediate
Category: Scripting
05/23/2017
In this article, multiple scripts will be created to accomplish the same task. This may seem silly at first but, it's an important exercise to learn the best approach to a problem. If you are new to this concept, you should actually build the different scripts to cement the concept in your mind. I've been usi.
Read More
Comparing and contrasting different solutions to a problem is essential to good programming!
FileMaker by Beginner
Level: Beginner
Category: General
05/16/2017
I was asked to write an article about my experiences, troubles, pitfalls and recommendations to those starting out with FileMaker. I find many times, and this applies to any industry, when experts help beginners, the experts forget what it was like to be a beginner. While the expert is generous with his or he.
Read More
Advice from someone who can remember what it's like to be a FileMaker beginner.
Sweet Sixteen
Level: Intermediate
Category: General
05/09/2017
The new release schedule, designed to get fresh versions of FileMaker to the public faster, is in full swing with the release of FileMaker 16. It took the FileMaker 16 development team just one year to program a fully featured upgrade with changes to Pro, Go, Server and WebDirect. A truly amazing feat. While.
Read More
FileMaker 16 Advanced splash screen.


  Previous 10 | Next 10