This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical "how to" course by FileMaker expert John Mark Osborne, starts from advanced level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10 and 11 features and techniques including the Ultimate Find, saving a found set of records for future retrieval, saving find criteria for future use, text parsing to create features, making new requests easier for users, parsing web form generated emails, five methods for deleting duplicates, recursive phone filter, creating preferences in a single-user and multi-user scenario, web-like back and forward buttons, conditional buttons, custom form letters, changing text attributes with scripts, script triggers and many more techniques with an emphasis on adaptive scripting and calculations. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning.
Hi. My name is John Mark Osborne and I want to tell you a little bit about myself so you know an expert is teaching you about FileMaker. I want you to feel confident the techniques taught in this tutorial will help you become a successful FileMaker developer. So let's take a look at some slides. I've been developing and training exclusively with FileMaker Pro for two decades. I'm currently certified for FileMaker 7, 8, 9 and 10 and it's a rigorous test developed by FileMaker Incorporated to show whether you're a good developer or not. So anybody passing this has passed a rigorous test. It's hundreds of questions on all kinds of things from FileMaker Server to FileMaker Pro to scripting to relationships and all that stuff. At the time of this recording, though, there was no FileMaker 11 Certification Exam but I'm sure I'll take it when it comes available and hopefully I'll pass it. I started out my FileMaker career working at Claris Technical Support. Claris is the company who owned FileMaker before FileMaker Incorporated. They had other products like MacProject, MacPaint, MacDraw, which you may be familiar with. When they decided to focus in on the FileMaker product line, they dropped the rest of the products, sold them off and renamed their company to reflect that change. I worked in Claris Technical Support for five years and I was the technical lead for FileMaker Pro for several of those years working with development and other support representatives. I also run a popular website called Database Pros. It's one of the most popular FileMaker websites on the Internet. There are hundreds of free tips, tricks, articles and techniques you can download. I get over 35,000 hits per day and you simply go to DatabasePros.com. I co-authored a book called Scriptology. This is very popular. It was written about ten years ago. You probably won't find a copy these days, although some are selling on eBay and things like that but it was very popular because it covered scripting and calculations exclusively at an intermediate to advanced level. I won the 1999 Excellent Award from FileMaker Incorporated. This was for developing outstanding technical resources. I'm also an authorized trainer. I'm one of 16 trainers in North America authorized to teach the professional training courses, which are now called the FileMaker Training Series. I'm one of four original authorized trainers. I'm also a chairperson and presenter for the MacWorld Power Tools Conference for FileMaker for the past 12 years. It's a two-day FileMaker Pro only conference at the MacWorld Expo. I'm also technical editor for the popular tips column in FileMaker Adviser Magazine as well as helping with topic selection, editing articles and deciding on future directions of the magazine. And last but not least, I'm a Platinum Level FBA member. There's thousands of FBA members or FileMaker Business Alliance members world-wide but there's only 25 firms who are platinum level, helping FileMaker Incorporated with their most important customers. So hopefully I've given you an idea. I have a long resume; I've been in the market for a long time. I've been working with FileMaker exclusively so you can trust that what I'm going to teach you in this tutorial will be the honest truth; the real way to work with FileMaker and to program it.