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 to intermediate and advanced because really to create a solution one tutorial is 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 will be little tidbits of knowledge that you'll gain. Plus, it will 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 tutorial separately. Basically we include the work file 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 will 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 what we'll 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 and one for data entry. We'll show you how to do all that stuff. Importing, Exporting we'll work with templates, a little bit of scripting, a little bit of calculations, and even reporting. So, quite a bit to do in the beginner tutorial. We'll start off slow and we'll kind of ramp it up toward 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 would 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 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 the ultimate find, doing a back and forward 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 so 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 a layout. We're talking about form letters that can be modified by the user in browse mode, so a very, very advanced technique. We'll talk about text style 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 the 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 solutions, so if they're comfortable with it, they can actually do complex things like new requests or multiple requests without knowing that they're actually doing them and get the benefits from them. We'll talk about cross-tab reports, filter 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.