Subtitles of the Movie

Now the Advanced tutorial is the finishing Solution. By the end of the Intermediate Tutorial, you actually have almost a completely fully functional invoices solution. But the Advanced Solution is really going to cover those Advanced Techniques that really makes it cool. And, you know, you really need to understand the Beginner and especially Intermediate to go on to Advanced. We'll cover things like the Ultimate Find and really it is Ultimate Find, I've been working on it for 10 years and it does just about everything. We'll do a back and forward button like a web browser. We'll show you how to save a Found Set many different ways. So in other words if somebody wants to say I want this Found Set, we're going to show you how to save it so the person can come back to it later. And we'll discuss the ins and outs of each method that we use. We'll use Recursive Custom Functions to do a Phone Filter. We'll do Custom Form Letters, now this is actually a very complex technique that's very, very useful, I use it almost every Solution I do. We'll manipulate text styles with calculations and scripts. We'll also create a script that allows you to make new requests for the user without them even knowing that they're making the request because most users are using your solution, and won't understand what a new request is and it's your job as a Developer to make sure they don't have to learn your solution it should just make sense. So, this script allows new requests to be made without the user even knowing. We'll discuss cross-tab reports, filter portals, script triggers which is the big new FileMaker 10 feature. We'll have a whole chapter on that. We'll also discuss change logs, how to make a history, there's quite a few ways to do this. And even deployment considerations. Now throughout this tutorial we'll be using FileMaker Pro 10 Advanced. That doesn't mean you have to have FileMaker Pro 10 Advanced but it'll be very helpful. I would say that about 90 percent of the techniques or even as high as 95 percent of the stuff that is covered in here won't require FileMaker Pro 10 Advanced. I'm going to try to convince you to get it if you don't have it already because it'll make life easier. We're gonna several times go into uh, Managed Database and copy some tables and some fields. Well with FileMaker Pro 10, you'll have to do those manually. Whereas the people with FileMaker Pro 10 Advanced, it's going to save them a lot of time. So it's not that you can't do this stuff, it just makes it harder with the regular version of FileMaker Pro. So again most tasks in here can be substituted. There are a few that can't be and we'll discuss those and work arounds and things you can do when it's not, so it'll be fine if you have FileMaker Pro 10, you can't convince your boss to get it, don't worry about that. So, if you have FileMaker Pro 10, you don't need FileMaker Pro 10 Advanced but you'll see that once you get through this whole tutorial, you will definitely want it. Now let's talk about FileMaker Pro 7, 8, 8.5 and 9 as compared to FileMaker 10. Most of the techniques inside these tutorials are applicable to FileMaker 7, 8, 8.5 and 9. I'd say about 90 percent, so if you're not quite up to FileMaker 10 yet, you're just working with FileMaker 9, you can still use these tutorials. It'll be noted when we come across a technique that doesn't work in FileMaker 9 or 8 or 8.5 or something like that. That'll be noted that the other work arounds, other ways to accomplish this task. It may be as simple as substituting a Global Field for a Variable. Or it may be a in a completely different method for doing this. One thing you need to realize, FileMaker 7, 8, 8.5 and 9 all have the same file format. So, all of the Work Files will open in any version of FileMaker that has a .fp7 at the end. So no worries on the Work Files, those will all work for you. It's just that specific features in FileMaker 10 will not work in FileMaker 9, such as Script Triggers or specific features in FileMaker 9 will not work in earlier versions such as Conditional Formatting. So, not to worry, if you don't have the most current version of FileMaker you'll be all right. You'll still learn a ton because the basic good programming techniques that have been there are still there. And that's 90 of what you need to learn anyhow. I also recommend that you build it. What do I mean by this? A lot of people like to watch the videos and then either when they get done with the videos or even maybe after their first couple of chapters they start working on their solution. You need to watchin the videos and either at the same time that you're watching them, build them or watch them and then go through them a second time and actually build it. If you don't, you're not going to be able to imbibe the techniques as well. I've, I've talked to many peoples over the years I've been doing these tutorials, I can tell you for sure, people get excited and they want to go ahead and watch it and then build something. You have to be patient and you actually have to build the solution. Build it exactly as you see it on the screen, exactly, make everything work and believe me when you go to work on your project you'll know how to do everything much better than if you just watch it.