"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

Planning
Planning

Subsummary Sandwich
Subsummary Sandwich

Window Naming
Window Naming

The Front Door
The Front Door

Modular Scripting
Modular Scripting




$10.00 Beginner Video Training


Quick Tip:

Date with Current Year
If you want to enter a date without typing the year, here is a cool little technique. Enter your date in the following manner:

1/10

When you type the Tab or Enter key, FileMaker Pro will automatically enter the current 4 digit year for you.



Tips & Tricks Videos


Fun Stuff:

FileMaker Developer Worthiness
Top 10 ways you know your developer is not worthy:
  1. Spells "FileMaker" with a lowercase "m"
  2. Uses inches or centimeters instead of points in Inspector
  3. Recommend WebDirect deployment over FileMaker Pro
  4. Creates a solution with one file for every table
  5. Doesn't know Claris and FileMaker, Inc. are the same company
  6. Isn't certified for latest version of FileMaker
  7. Isn't an FBA member
  8. Charges less than $100.00 per hour
  9. Uses a rainbow of colors on his interface
  10. Provides a quote without a requirements document



RSS Feed
Search Results for : All
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.
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!


  Next 10