FileMaker Pro 9: Advanced Course

My name is John Mark Osborne, and I'll be your instructor for this tutorial. I want to tell you a little bit about myself so you know an expert it teaching you. I want you to feel confident that the techniques you learn in this tutorial will help you to create a very, very successful FileMaker solution. I've been developing and training exclusively with FileMaker Pro for the last 17 years. I'm a FileMaker 7 and 8 certified developer; in other words, I passed the test that FileMaker Inc. gave. At the recording of this tutorial, at the time we did it, there was no 8 point 5 or FileMaker 9 certification test. I started out my FileMaker career working at Claris Technical Support. Now Claris is a company who owned FileMaker before FileMaker incorporated owned it. It was the same company, actually. It's just that Claris had a whole bunch of products and they dropped them to focus on the FileMaker product line and therefore they changed their name. I worked at Claris Technical Support for five years and eventually became the technical lead for FileMaker Pro and this involved working with the development team, handling issues, escalation issues from the phones; I was the go-to person in the department for FileMaker Pro issues. When I left Claris I started a company called Database Pros. Database Pros is one of the most popular FileMaker Websites on the Internet. One of the reasons why is there are hundreds of free tips, tricks, articles and techniques. You can just go there and download to your heart's desire. There's probably too much information to download at any one time and it is updated every month. For that reason we get about 35,000 hits per day and if you want to visit yourself, just go to databasepros dot com. A long time ago, about 10 years ago, I had co-authored a popular book called Scriptology. A lot of people still ask for it but it is 10 years old. It was covering FileMaker 3, 4, and 5, but it was so popular it became a developer handbook, in fact, people still ask for it today. It covered scripting and calculations in intermediate to advanced levels, so this is really my forte. I love scripts and calculations and these tutorials will focus on them, but we'll also cover relational design, calculations, auto enter; everything gets covered in here, so you can create your own solution. In 1999, FileMaker Inc. gave me an award. It was a prestigious award for developing outstanding technical resources. They don't give many of them away and I got one a long time ago; one of the first ones that was ever given out. Currently I am an authorized trainer, that's one of 12 trainers in North America, and I've been authorized since the beginning for Series 1, 2, and 3. So, FileMaker Incorporated chose me to be one of the trainers in North America to teach their specialized training course that they developed. For the last 10 years I've also been the Chairperson and Presenter for the Mac World Power Tools Conference. This is a two-day FileMaker Pro-only conference at the Mac World Expo. I'm also the technical editor for FileMaker Advisor Magazine. One thing I do there is I am the editor for the popular Tips Column at the back of the magazine. There're usually three or four tips every month that covers FileMaker information. I'm also a technical editor assisting with topic selection, editing, and future directions. I'm also a Platinum Level FBA member. Now, this used to be the FileMaker Solutions lance and I was a partner-level FSA member, but it's been changed to be called the FileMaker Business Alliance, and I am also Platinum Level, the highest level there. There're only approximately 25 members inside the FBA and we basically help FileMaker Incorporated with their most important customers. So there's a little information about me. Hopefully I've convinced you that I have the skill level to teach you to be an outstanding FileMaker developer.  

Download WorkFiles