"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

Subsummary Sandwich
Subsummary Sandwich

Window Naming
Window Naming

The Front Door
The Front Door

Modular Scripting
Modular Scripting

FileMaker Videos
FileMaker Videos




FREE Beginner Video Training


Quick Tip:

Record Locking
In FileMaker 6 and earlier versions, record locking occurred when a guest on the network clicked into a field. That's was all that was required to prevent others from changing the record. Unfortunately, this also prevented other guests from copying data from a locked record and other basic features. FileMaker 7 has changed how record locking works. In order for a guest on the network to lock a record, he must actually modify a field, allowing user to work with a record without locking it. However, the most important change is when scripting for record locking. You don't want to test if the record is locked by setting a field to a value. FileMaker 7 introduces the Open Record/Request script step which attempts to lock a record without modifying it. If the record is locked, an error of 301 will be returned. If the record is not locked, this script will lock it until the Guest exits the record manually or the Commit Record/Request script step is intiated.



Tips & Tricks Videos


Fun Stuff:

The Wedge
Claris Corporation and the FileMaker, Inc. have been housed in a building called the wedge in Santa Clara, California since they spun off from Apple, Inc. The building is nicknamed the wedge because it looks like a wedge. For some years they had an adjacent building called the interstitial but it was let go when the company downsized to focus on FileMaker products.

The Wedge



RSS Feed
Search Results for : All
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.
FileMaker and the Real World
Level: Beginner
Category: General
05/02/2017
FileMaker is an incredibly versatile and scalable platform, but it is genuinely unique in the way it allows you to solve real world problems quickly, efficiently and super cost effectively. I work for a company that manufactures water softeners (the best ones actually) and I was asked to solve a p.
Read More
FileMaker is a versatile and scalable platform!
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


  Next 10