"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

Eating Your Own Dog Food
Eating Your Own Dog Food

Wrangling Relationships
Wrangling Relationships

Preferences and Options
Preferences and Options

Becoming Certified
Becoming Certified

Logically Speaking
Logically Speaking




$10.00 Beginner Video Training


Quick Tip:

Dangers Of The Find/Replace Feature
The Find And Replace feature has a serious a downside. I don’t want to be dramatic but I remember when I had seen it introduced at a FileMaker developer meeting in Seattle, I was shocked more by the dangers than the benefits. Imagine users being able to find and replace across all the fields on a layout in the found set without being able to to undo. Yikes!



Tips & Tricks Videos


Fun Stuff:

FileMaker, Inc.
FileMaker, Inc. or FMI is a wholly owned subsidiary of Apple, Inc. It was once named Claris when it also sold MacWrite, MacPaint, Claris Emailer, ClarisWorks, etc. but changed it's name when it focused on FileMaker. FileMaker started out as a DOS application called Nutshell but was shaped into the powerhouse it is today by Claris and FMI.



RSS Feed
Search Results for : All
Eating Your Own Dog Food
Level: Intermediate
Category: Web Enabling
12/05/2017
I took a different technology approach than every other person out in cyber land writing FileMaker blogs. I actually created my own FileMaker database to manage my content. Go figure! I could have taken the easy way out and used canned blog software but FileMaker is perfect for this job. Besides, I'm a firm b.
Read More
The three online databases running on the Database Pros web server.
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.


  Next 10