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

Preventing Access to Fields
FileMaker Pro has a feature in the Inspector under the Data tab that allows you to prevent entry into a field. However, scripts can still enter a protected field. Just use the Go to Field or any other script step that places the cursor in a field to allow users into a field only when you want them. By the way, attaching a Go to Field step directly to a button will not override the Inspector settings. A script from Manage Scripts is required.



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
File Freedom
Level:
Category: General
04/24/2018
In my two decade career, I've only seen corrupt files while working in technical support. I was in technical support for five long years but even then it was not a common occurrence. Rarely have I encountered a corrupt file while working with a client or in my own personal FileMaker solutions. With good file.
Read More
Good file management practices are the best way to deal with corrupt FileMaker files.
FLF
Level: Intermediate
Category: General
04/10/2018
I've mentioned FLF (Find-List-Form) in several other articles on this web site but I think it's so important that I wanted to devote an entire article to the subject. So many developers have moved so far away from the roots of FileMaker that they almost don't even know what they are. Then they teach other bud.
Read More
FLF (Find, List, Form) is about getting back to the basics of FileMaker.
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.


  Next 10