"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below!



Beginner, Intermediate and Advanced Video Training


Recent Blogs:

Context & Relationships
Context & Relationships

Parsing for Features
Parsing for Features

Parsing A Web Form
Parsing A Web Form

Data Parsing
Data Parsing

Anatomy of a Calculation
Anatomy of a Calculation




$10.00 Beginner Video Training


Quick Tip:

IsEmpty
I have seen many people, even expert FileMaker developers, check for an empty field by comparing it to to double quotes (""). While this method may work some of the time, it can fail in some situations. Always use the IsEmpty function.



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



FREE FileMaker 17 Videos



Document Management Videos



Create a Complete Contact Manager







RSS Feed
Search Results for : All
Stuff Ya Oughta Know
Level: Intermediate
Category: General
03/28/2018
Some things in FileMaker require an entire article to explain thoroughly. Others are just a paragraph of description but are no less important to your FileMaker professional career. Some people call them tips but I like to think of them as nuggets of truth. The stuff in this article was hand picked by myself.
Read More
Here's a bunch of tips I think are really important to any FileMaker career.
Alternatives to Serial Numbers
Level: Advanced
Category: Scripting
03/13/2018
In this final article from a series of four articles, I want to cover alternatives to restoring records using serial numbers and relationships. The first method I will cover uses the Snapshot Link feature and is fairly straightforward. Just a few issues with interface to overcome. The second is a script to sa.
Read More
Alternative approaches to restoring records with serial numbers and relationships in FileMaker.
Collecting Unique Values
Level: Intermediate
Category: Scripting
02/27/2018
Since Darren Terry published his infamous article on saving found sets for future retrieval in 1996, a lot has changed in FileMaker. The additions from the last thirteen versions of FileMaker offer many alternatives for amassing unique identifiers. The differences in collection methods mostly come down to spe.
Read More
Alternative methods to collecting unique FileMaker values.
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.


  Previous 10 | Next 10