"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:

Freeze Window
The Freeze Window script step can speed up looping scripts by as much as 10 times. For instance, in a script that loops through records, each record refreshes the screen. Over hundreds or thousands of records, this can add up and slow down the processing of your script. Using the Freeze Window step once before entering the loop will eliminate the redraw and speed up the loop significantly.



Tips & Tricks Videos


Fun Stuff:

Claris Commercial
Few people know that Claris produced a commercial and it aired on national television. It was one of those favor things so it only played once. I'm not saying it's anywhere close to the impact of the Apple Super Bowl commercial but it's fun to have a look. Download the Claris commercial



RSS Feed
Search Results for : All
Saving a Found Set
Level: Intermediate
Category: Scripting
02/13/2018
Found sets are what make a database a database. Without found sets, a database wouldn't be much more than a relational spreadsheet. Found sets determine which records print, sort, export and preview. Practically all features in FileMaker are structured by the found set. The found set, along with the current r.
Read More
The original TechInfo article Darren Terry published way back in 1996!
Preserving Found Sets
Level: Intermediate
Category: Scripting
01/30/2018
Imagining a database without found sets is like picturing a bird without feathers. It just doesn't make sense. Found sets are the essence of a database. If there were no found sets, you would need to sort your entire list of records and scroll to find a record. To say the least, this would be an inefficient p.
Read More
The Status Toolbar in FileMaker always displays the current record, found set and total records for the current table.
Multi-User Contradistinction
Level: Intermediate
Category: General
01/16/2018
How you design a FileMaker solution often depends on how it will be accessed. Is it a single-user solution running off the local hard drive? Is it a multi-user database with all users accessing from the LAN? Maybe there is a occasional remote access from someone at home? What if the company is distributed acr.
Read More
FileMaker can share to a variety of platforms including Windows, Macintosh, iOS and Web.
Reconciling Record Locking
Level: Intermediate
Category: Scripting
01/02/2018
One of the most important concepts to grasp hold of tightly, when moving from the design of single-user to multi-user FileMaker solutions, is record locking. It's a fairly simple concept to understand. It just prevents two people from editing the same record at the same time. The complex part of record lockin.
Read More
A padlock representing record locking in FileMaker.
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.


  Next 10