"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

File Freedom
File Freedom

FLF
FLF

Stuff Ya Oughta Know
Stuff Ya Oughta Know

Alternatives to Serial Numbers
Alternatives to Serial Numbers

Collecting Unique Values
Collecting Unique Values




$10.00 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
Wrangling Relationships
Level: Intermediate
Category: Relationships
11/07/2017
The relationship tab in Manage Database is not an ERD (Entity-Relationship Diagram). Sometimes it looks a lot like an ERD but it is so much more. An ERD represents the structure of your solution while the relationship graph contains structure as well as what I like to call techniques. Techniques are relations.
Read More
Wrangling relationships!
Preferences and Options
Level: Advanced
Category: Calculations
10/24/2017
I'm no SQL expert but I know when, and when NOT, to use the ExcecuteSQL function. ExecuteSQL is not for creating replicas of portals, despite the numerous examples floating around the internet. It's also not designed to replace the built-in FileMaker find feature, even though it seems to replicate the search.
Read More
If you aren't familiar with SQL, it's an acronym for "structured query language". Many database applications use SQL to perform finds, analyze relationships and create, edit and delete records.
Becoming Certified
Level: Intermediate
Category: General
10/10/2017
The most common non-technical question I get is, "how do I become certified" or "how do I study for the certification test"? It's a good question. If you're taking the test seriously then you need to study, right? Not only does it cost a few hundred bucks to sign up but it's an important milestone in your Fil.
Read More
The official FileMaker 16 certification logo I display proudly on my web site.
Logically Speaking
Level: Beginner
Category: Calculations
09/26/2017
Logical functions are some of the most important and widely used functions. Think of decision making when considering logical functions. They enable you to decide if a formula will return one result or another. Which fork in the road will the formula take? Testing for true or false is often referred to as boo.
Read More
Spock is a logical guy, just like logical functions in FileMaker.
Efficiency
Level: Intermediate
Category: General
09/12/2017
The old saying that time is money is more than just a saying. The faster you can develop a project, the more money you can make as a commercial developer or, the more time you can devote to other projects as an in-house developer. Being as efficient as possible is the key to success. That's the primary differ.
Read More
Efficiency is the key to making money for a commercial developer and crucial for in-house developers to make time to do their "real" job.
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!


  Previous 10 | Next 10