"No Holding Back FileMaker Blogging"


Navigation:


Support this site by clicking on a sponsor below or becoming a patron!



The Philosophy of FileMaker recommends PCI!



Become a patron of this FREE web site!


Recent Blogs:

Best of FileMaker Eighteen
Best of FileMaker Eighteen

FileMaker Eighteen
FileMaker Eighteen

Set Field Skills
Set Field Skills

Custom Menu Creativity
Custom Menu Creativity

Google Calendar
Google Calendar




Tips & Tricks Videos


Quick Tip:

The Index
Indexes makes finds and other features fast. Think of looking for a word in a book by flipping through each page. It’s much quicker to go to the index where it will tell you each page where the word is contained. This is exactly how an index works, it only stores each word once per field across all records. There are two types of indexing: Minimal and All. Minimal means only one index type has been created while All means two index types have been created. The most commonly used index type is a Word index and can only be created for text fields. Up to 100 characters of each word are indexed. Words are defined most often by spaces but can also be determined by commas, periods, colons and other characters. A word index does not differentiate between uppercase and lowercase. Searching for “FRED” also finds “fred”. A Value index is used for searching number, time and date fields as well as relationship key field matching. Up to 100 characters of each return-separated value are indexed. While searching can be done on partial text in a Word index, only complete values can be searched for in a Value index. When you think about it, why would you want to search for a partial number or date. Indexes are utilized in a variety of features other than finds such as value lists based on the contents of a field and unique validation. Understanding how an index works can help you better design a database.



The Philosophy of FileMaker recommends PCI!


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 in 1998 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.



Create a FileMaker Calendar







RSS Feed
John Mark Osborne

John Mark Osborne of Philosophy of FileMaker

My Passion
The first time I touched FileMaker was when I worked as a graduate assistant at San Jose State University. I was handed a FileMaker database and told to fix the labels. I can't say it was love at first site but it did begin a lifelong love affair with FileMaker. Not until I started working in technical support across from a guy named Michael Whitney did that spark ignite a fire of passion for this unique product. I'm not sure Michael knows how much he meant to my FileMaker career but kudos to you buddy and the fun we had sitting across from each other.

My Career
For the past twenty years, I have been making a living as a database developer at my company Database Pros. This entire web site is driven by FileMaker! I first started working with FileMaker because I really liked the product. I've done just about everything in the FileMaker market from writing a book, recording videos, speaking at the Developer Conference, teaching live classes, editing multiple magazines, running a popular FileMaker web site, speaking at MacWorld and probably a few other things I've forgotten over the years.

Where Am I?
I live in Chino Hills, California with my beautiful wife Aida but I grew up in Silicon Valley. I have two children, Liza and Ryan. Both children have graduated college but still come over often for meals at our house. I also have a food blog so I try my new recipes on my wife and children. If I could make a living cooking, I would but FileMaker enables me to cook all I want. Thanks FileMaker!

Fun
I have a few hobbies. I usually have a nice craft beer while I'm cooking (but, not while I'm developing FileMaker) and I'm also brewing me own beer from time to time. Cooking is my main hobby though and something I do almost daily. I do enjoy the company of my dogs on our early morning walks but the day is mostly devoted to FileMaker. Night time turns my interests towards Anime like Naruto Shippuden, One Piece, Ruruni Kenshin, Bleach, Attack on Titan, YuYu Hakusho, Dragonball Z and so many more that I can't name them all here.

What is the Philosophy of FileMaker?
When I was in college, I was fascinated with philosophy classes and how philosophers think through the subject they are trying to prove or disprove so thoroughly. Philosophers focus on a subject like a laser and attack it from all sides, to a degree that most people consider ridiculous. I have used the philosophical methodology throughout my database development career to reveal advantages and disadvantages in order to choose the best solution for the problem at hand. I'll apply the same approach to writing this blog, never leaving any details out or holding back because it is a trade secret.

Please Support this FREE Web Site!
Please support this free web site by purchasing some of the FileMaker products that are linked from the banners or go directly to the databasepros.com web site and check out the solutions, consulting, training and other options. I also have beginner, intermediate and advanced video training with over 3 hours provided for FREE. Thanks so much!

All FileMaker, All Mac
Instead of taking the easy way out and choosing one of the many plug-and-play blogging platforms out there, I decided a blog about FileMaker had to run on the FileMaker platform. So, I developed my own blog solution, customized to my particular requirements. Not only that, all the beautiful screen shots, custom artwork, late night coding and endless hours of writing are done on a Macintosh. Even the server hosting the FileMaker solution is a Macintosh! I'm proud to support the most innovative technology company in the world!