Subtitles of the Movie

Let's talk a little bit about how these tutorials are organized so you can make the most out of your experience watching them. First of all, the tutorials are divided into three: one's for beginner, one's for intermediate and one's for advanced. However, they are all connected with one solution. We will be creating an invoicing solution which really starts out as a contact manager in the beginner and that will translate over into intermediate and advanced because really, to create a solution, one tutorial's not enough. You really need to go through beginner, intermediate and advanced. And so even if you're an intermediate user, you really want to watch the beginner because there's a whole bunch of stuff that's covered there. Even if you know most of it, I'm sure there'll be little tidbits of knowledge that you'll gain. Plus it'll set up what we're going to do in the intermediate and advanced tutorials. So we've chosen to use one solution so that everything is connected together so you can not only see what all the techniques are, but how they tie together to create a whole solution. You can view the tutorials separately. Basically we include the work files after each chapter so if we go through four or five tutorials for a chapter, what we've done in those four or five tutorials will be saved in a file so that you can come into any one of the chapters and review something or even just start there and have what we've done before in the previous tutorials. So this can be really helpful, given that we've chosen to make it one solution throughout and not just a bunch of techniques. So you can actually, if you want, I don't necessarily recommend it, but you can go and pick and choose which chapters you want to watch and you will have the example work file that goes along with that. Let's talk a little bit about what the beginner tutorial covers. Essentially we're going to create a fully-functional solution starting from the beginning. So we're going to start from scratch. There'll be nothing there and we'll create everything. And while we're going to be ultimately creating an invoicing solution, in the beginner tutorial we'll start off with a contact manager and that will be integrated into the invoicing solution. And we will be covering in the beginner data entry, how to create fields, how to create tables, how to create layouts, all the things that go along with layouts. We'll cover all the different modes like find and browse and preview and layout mode. We'll cover all the menus so you're familiar with just about every single choice under the menus. We'll cover value lists so you can make pop-up menus and radio buttons. We'll talk about auto-enter, validating. We'll work with some container fields to import pictures and pdf documents. We'll print, obviously making a layout for printing, one for data entry. We'll show you how to do all that stuff. Importing, exporting. We'll work with templates. Little bit of scripting, little bit of calculations and even reporting. So quite a bit to do in the beginner tutorial. We'll start of slow and we'll kind of ramp it up towards the end. But if you've never worked with FileMaker before, the beginner tutorial is designed for you to start with no knowledge at all and come up to an intermediate level so you can continue on with the tutorial series. When you get on to the intermediate tutorial, we will continue with the solution covering intermediate tasks. Well, those will be interface design. You know, something more spectacular than what you can just do with the FileMaker tools. We'll start creating relationships so that means we'll have multiple tables, which means we'll have multiple table occurrences. We'll work with security; you know, accounts, privileges, extended privileges. We'll talk about multi-user stuff like record locking and how to work with it in a multi-user scenario. We'll take a stab at custom functions and inside custom functions we'll even go into recursive custom functions. We'll talk about finding overdue invoices, which is writing a script; very cool thing. We'll work with a script debugger, the database design report, plug-ins, deleting duplicates, dynamic scripting and advanced validations and, of course, much more stuff that can be actually listed here, all in the context of an invoicing solution. So by the time you get done with the beginner, intermediate, you'll almost have a complete invoicing solution. Once you get done with the advanced, which we're going to next, you will have a complete invoicing solution; just about everything you'd want in there. So the advanced tutorial completes the invoicing solution. And we'll cover things like ultimate find, doing a back and fore button, much like a web browser, we'll talk about how to save a found set of records for future retrieval and also allow users an easy interface they can choose which found set they want to retrieve and restore into their database. We'll do recursive phone filters, custom form letters. Now, these are not the standard form letters that you're used to when you're working with just layout. We're talking about form letter that can be modified by the user in browse mode. So a very, very advanced technique. We'll talk about textile manipulation with scripts and calculations. We'll show how to make it easier for new requests to be made by the user. In fact, they won't even realize they're making a request. So one of the important things about advanced techniques is you're trying to separate the user from having to know FileMaker. You just have to know your solution. So if they're comfortable with it, they can actually do complex things like new request or multiple requests without knowing that they're actually do them and get the benefits from them. We'll talk about cross-tab reports, filtered portals, logging changes to your database in a separate database or inside the same one. Lots of different approaches. And even deployment considerations. Tons of stuff we're going to talk about. We'll get to all that through all these three tutorials and hopefully that will give you all that you need to be a FileMaker developer.