Meta-consulting is a service Database Pros offers to help other developers
over programming hurdles via GoToMeeting. Email John Mark Osborne or call John Mark at (909) 393-4664 to find out more about this service.
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.
Level: N/A Version: FileMaker 19 Category: General Tuesday, September 14, 2021
Michael Rocharde and I started the Fireside FileMaker podcast way back in 2019. We've recorded 45 episodes along with our good friend Marc Larochelle. But, all things come to an end... at some point. I'm proud of the work I've done on the Podcast so I want to share some of my favorite episodes. There will also be a listing of all the Podcasts in case you are just discovering the show. Thanks for your support and Happy FileMaking!
Intro If you haven't every listened to an episode of Fireside FileMaker, I think the best way to start off our Podcast is by listening to our fifteen minute intro. It'll give you an idea about how we think about FileMaker and what to expect in our shows.
The Calculation Dependency Tree I've known Darren Terry since my days in Claris Technical Support. I've always admired him for his vast FileMaker knowledge and enthusiasm to share. He's also very humble so he doesn't make any claims to his expertise... but, I will! In this Podcast, we asked Darren to discuss the calculation dependency tree. In other words, what makes the different types of calculation types decide to update? It's a complicated subject matter, given the number of places a calculation function can reside, but Darren covers the subject matter with the deft of a virtuoso. He even gets into tangent discussions which I found incredibly interesting.
Alexei Folger I guess we didn't have a better title than to just list Alexei's name but trust me, she knows her FileMaker stuff! I also met Alexei in technical support when she was hired to support the new version of FileMaker for Windows. She went on to support enterprise Claris clients in her capacity as a Systems Engineer and now works as an independent FileMaker developer. Her knowledge of the recovery process in FileMaker including how files become corrupt, how they can be fixed and how to minimize corruption are second to none.
A Knight in Shining Armor David Knight, aka Speedy, is one of those rare individuals who succeeds without trampling on others. I would trust him wholeheartedly with my FileMaker project and you should too. One of the reasons you can trust me on this is because I've known Dave for over twenty years. I met him at a Developer Conference and have enjoyed exchanging ideas with him at every DevCon I attended. We talk about all kinds of things in this Podcast but the subject that stands out for me is how he treats his employees. I can't do it justice here so you'll just have to listen.
Punishing Performance Wim Decorte is one of the smartest developers in the FileMaker market. Is there anything he doesn't know? While he specializes in FileMaker Server, he can enter any FileMaker conversation and keep up his end and likely, and kindly, get your respect. That's why I hand selected him to teach courses on FileMaker Server. If you haven't listened to Wim Decorte, you really are missing out.
Going Vertical If you've listened to any of the Fireside FileMaker episodes, you've probably heard Marc Larochelle. I don't have an exact count of the episodes he participated in but it's easily half of them. Why, you ask? Marc knows so much about the FileMaker market, having started his own development firm, recorded seemingly endless videos discussing FileMaker and is in the running for having attended the most DevCons ever. What I picked out for this blog article is an episode where we interviewed him for his experience in creating and marketing vertical market FileMaker solutions.
A Conversation with Claris When's the last time you heard of a product manager staying with a company for two decades? It rarely happens but Rick Kalman believes in FileMaker and this Podcast will demonstrate just how committed to the platform he is. Along with his trusted colleague, Robert Holsey, Rick's team pushes FileMaker to the limit not just by working overtime but by thinking about the best way to achieve a desired end. These two gentleman don't hold anything back and give us great insight into the future of FileMaker.
Other FileMaker Podcasts The most active PodCast (other than ours) is The Context Podcast. Our two PodCasts couldn't be more different but they provide solid information to which you can be sure will help you in your FileMaker career. The only other active PodCast is FileMaker Talk Podcast by Matt Petrowsky and Matt Navarre. They haven't released anything for a year so I hope they are just taking a hiatus.
Feel Free In an effort to educate as much of the FileMaker community as possible, feel free to publish these Podcasts anywhere you'd like. Just drop me, John Mark Osborne, a note so I can check it out. Thanks.