Subtitles of the Movie

[00:00:00.0] So really you have a fully functional solution here that we're really going to create this whole thing. In fact, we'll even go so far as to create all the reports; reports by products, reports by invoice. Here's a letter section. All this stuff is going to be done and you'll know how to do this if you go through all three tutorials. And we also want to show you another product that we'll be using throughout. So let's move on. The second demonstration shows you the FileMaker Reference. Now I'll be using this throughout the creation of this database. This solution is also not unlocked. What we'll be doing is grabbing scripts, calculations and graphics from this FileMaker Reference. Why is it not unlocked? Well I'm going to give you whatever we grab out of it. Ok. It's going to be in there. I'm just not going to give you the whole solution but it's an easy way to show you how to grab it quickly out of a database. I can store all of my graphics in there and just simply drag them in there. But I will give you all of those graphics, all those calculations. Nothing will be kept from you. You just don't get the whole entire reference. So let's take a look at it real quickly. You'll see on the home page for the FileMaker Reference you have all these sections; calculations, scripts, shortcuts, graphics is down here, new features. There are all kinds of areas. We're going to be mostly in the calculations area, scripts area and really probably 90% of the time just getting graphics. So let's go ahead and look at the graphics here. And you can see what I have is a whole bunch of graphic container fields. And I have these pieces stored in here. And you can see that they correspond to what you see up here. And if you walk through it you'll see that all these pieces are here. There's even a 3D look that goes around the side. All these are built like legos. And so I'll be dragging this out of the FileMaker Reference and into the invoice solution that we'll be working on. And to get back to the home page just simply click this and you can go into the calculations section where we'll most likely be going into here as into the examples section. And we'll be searching for different examples because that way instead of me just simply typing out the whole formula, I can grab it, copy it and paste it. And it can save us some time because you can always pause the tutorial and look at the formula and copy it down. There's no reason why I have to spend so much time typing it out. And that way we can actually go over more material that way. So hopefully this will help you out in understanding that these two different solutions are not included inside the tutorial. They are there but they are not unlocked. Now let's talk about the work files. Each chapter has work files. For instance, the slides we're working on right now looking through in chapter one here: they are all included in the work files so you can look at them yourself. They're all file maker files so they are easy to open up. But there are also other kinds of work files like I might provide some graphics in a Jpeg file. I might have a table that you might want to import. Or I might actually have a solution that's being created in there. So in fact every single chapter will have the solution that we're creating. They'll be a Start folder and an End folder in each chapter, well except for the first one in the beginner. There won't be a start because we're starting from scratch. But everyone after that will have a start and an end. And so the start will contain the actual invoice solution, which will start out as a contact manager in the beginner. That will be stored in the start so you have the actual file if you let's say want to start on chapter five. Well you have the file that's been built up through chapters one through four. And so you have the beginning of chapter five. So if you just want to review chapter five you have that file there. And in fact you also have the end. If you want to review your work or something like that, you will have a folder in each chapter called N, which will have the same invoicing solution in it that's built up through that chapter. So you really have both ends, the beginning and ending of that chapter, that file so you can start anywhere in the tutorial you want. Again I recommend you go from beginning to end but it's very easy for me to provide this and could be useful for you if you want to go back and review what you've done.