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 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.
Level: N/A Category: General Sunday, January 1, 2017
You may be wondering why I named this blog the "Philosophy of FileMaker". Philosophy is defined as the following by Merriam-Webster :
1) the study of ideas about knowledge, truth, the nature and meaning of life, etc. 2) a particular set of ideas about knowledge, truth, the nature and meaning of life, etc. 3) a set of ideas about how to do something or how to live
The Philosophy of FileMaker The Philosophy of FileMaker aims to teach you how to think about FileMaker in a meaningful way and not just regurgitate techniques. Too many developers blindly follow what they read on a blog or an article or a book without thinking about whether there is a better approach. With FileMaker there are always multiple approaches. The goal of this book is to teach you how to think on your own so you can solve your own unique problems using the best solutions available.
“Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.” - Anne Isabella Thackeray Ritchie
The Reader It’s easy to say an educational resource is designed for intermediate or advanced or expert level FileMaker developers. But, what does that really mean? How is an advanced developer gauged? What makes someone an intermediate developer? It’s pretty easy to determine a beginner since they just recently started their FileMaker journey. An expert developer is also easy to recognize as they have been working exclusively with FileMaker for a decade or more and have probably passed all the FileMaker certification tests. It’s all the in-between that’s tough to figure out.
My guess is you, the reader, fall into this undefinable black hole of knowledge seeking. Most people are not experts. Others don’t want to go beyond the basics. That’s not who I’m writing to in this blog. I’m writing to all the aspiring FileMaker developers who want become professionals. You might be a hobbyist, an in-house developers or even a full time FileMaker consultant. Whoever you are, this blog aims at teaching this widely diverse audience to the best of my ability.
If you have a passion to be better than the average developer then read on and enjoy!