Subtitles of the Movie

Ok we'll go onto the next slide here enhance toolbar: very minor changes; Save as PDF, Save as Excel and New Alignment Controls are available there. Real simple if you go back to the example here, we go to Browse Mode. We can see that under View we have Toolbar Standard and when we hold over these ones here you'll see that as we go across we now have Save Records as PDF and Save Records as Excel. And if we go to Layout Mode you now have a new option of toolbars here and Align is one of the new options. So all the alignment tools are now available under there. So I'm going to turn these off real quick because I don't want them on. And we're ready to go back here. Ok. Let's go onto the next slide here, enhance ScriptMaker, a lot of changes here. They're mostly cosmetic but these cosmetic changes make a big difference. And you'll notice it right when you go in there. If we go to ScriptMaker it looks really different now. You'll see these little icons here. Well, let me just demonstrate how it works now. You can create a new script if you want. Of course, but don't see an Ok or Cancel. You get out of it this way. And you can also create a new separator. Ok, these little dashes and we'll cover more about what separators do if you don't know what they already do. But you can also create a new group. We'll call that Tip. And you can see this little folder icon so instead of having to make these empty scripts that are basically delineators between different groups of scripts. I can now take these, grab them by this icon and put them in here. And notice that it's a little indented there. If I move down a little bit farther - see how it goes not inside the folder. This is inside the folder, not inside the folder. So we do that, its inside the folder and we can take several of these and put them in there. And we can close and open that; very, very, great, little feature here. We can also filter: so we can type in N, and we only see the scripts that have N in them. So these are great little features that you can use. Not only do you have these organizational features, you can also come in here and open multiple scripts. So in other words the script dialogs are not mobile anymore. In fact, we can even go back here and you'll see that if we want to get back to that edit script, it's right there. If we want to get back to the other ones, they're all right there under the Window menu. So we can close them and open them, do whatever we want with them. So I'm just going to clean things up. So, great features for script organization and the multiple Edit windows are not modal are great. And there's a little bit of interface change and you'll get used to that after a while. I think it's generally a better change. Product Activation. Don't be surprised after you've installed FileMaker, entered your registration number and your name that when you launch it, it asks you to activate it. It's an additional step after you install the software to cut down on piracy. You must activate FileMaker on every computer where it is installed. You can transfer the activation or deactivate it. You'll see choices under here. You can see I can deactivate mine right now. Essentially what happens is, when you activate it, it checks to see how many times you've activated for that registration number and makes sure that you don't activate, you know, let's say a 1,000 of them. It's just making sure to cut down on piracy. So you must have an Internet connection to activate or they do have an option for calling customer service. And last but not least there's a few new calculation functions; Get Temporary Path, it's a path to the folder where temporary FileMakers are stored. I really don't quite understand how this can be helpful because you really should play around with the temporary files that FileMaker makes. But you have access there now. You have Get Host Application version. You might have Server 90V1 or FileMaker Pro 9.0V2, any of those things can be returned when you do this. So it just allows you to know what version your host is. That can often help you out with what you're trying to do with calculations that might be not FileMaker 7 compatible. One of my favorite features though is Self and I'm going to show you an example, real quick example of this. We go over here into Define Database. And we take a look at our Phone field. Go into Options. We'll notice that we have a pretty basic, not to basic, but pretty basic formula that formats your phone number. It filters out and keeps only the numbers and then adds in your formatting. Now we're going to go over this quick extensively in later tutorials so you don't have to completely understand this. But realize that here's the reference to the Phone field. We're in the Phone field referencing itself. Now what if you want to take the same formula and put it on a bunch of Phone fields. You have Phone1, Phone 2 and Phone 3 and maybe several tables. Well, then you have to keep changing this. And the Let Function does help so you don't have to reference it here, in here and here. But what if you could put in the function Self here. Now it says Refer to Itself. Click ok. Click ok. Go to our Calculations and get into Browse Mode here. So we look at that. We'll delete all that information then type in 909-393-4664 and when we exit, that Auto-Enter Calculation formatted the data in there: put in all of those separators for us and it did it without a reference to the actual phone field, so very cool. I'm going to really use this function a lot, to make your calculations more dynamic, more abstracted. You can just copy-and-paste them anywhere you want without any amount of modification. Then you also have a few mathematical functions like Asin and Acos but we're not going to cover those very much here at all. And that's about it for FileMaker Pro 9.