Subtitles of the Movie

Now FileMaker Advanced can also create Runtime solutions. If you're a Developer and you're making Stand Alone Solutions that you want to put up on your website so people can Download them and use them, this is what you want. It binds uh, limited copy of FileMaker Pro to your Solutions. So that people don't even have to know it's FileMaker Pro, they download it, it works just like it does in FileMaker Pro but without it. So this is a great little feature to have if you want to make a living off of selling Contact Managers and other solutions. So what you do is you come up here and go to Develop Your Utilities and here's where all this happens. Now we're going to go over this more extensively later so I'm not going to go over everything but there are a lot of features in here for setting up how your runtime solution works. And the best thing about it is the royalty free, license free, you have to do nothing. You can distribute them and not pay anybody anything. Another great feature is Custom Functions. What a Custom Function is, is an ability to create your own Function. Just like you would see in a Manage Database and we'll go there. You might see a calculation, we'll do a test one here. And you might see like that the ABS Function or the ACOS or we'll go down farther and look at one you might be more familiar with like is empty or left, let's look at the Text Functions, those are always good. You've got Filter, you've got Length, Left, Middle, Right, Lower. All these functions call on C++ code within FileMaker. But you can make your own Custom Functions. What this allows you to do is create a calculation, a very complicated calculation and call upon it with a Simple Syntax. So it makes it easier to call upon that Custom Function no matter where you are inside your FileMaker Solution. Not only that, if you've used that Custom Function, refer to it 10 times in your Database, then all you have to do if you need to make a change to the code is go to one place, make the change and it flows out to wherever it was inside your Solution. So it's really a great feature. And then of course you have the Database Design Report or DDR. This is really a great feature. Essentially what it allows you to do is create a cross-reference of your Database. For instance, let's say you want to go ahead and find out if this Field is used anywhere in your Solution. You can't remember what it's for, you're having trouble remembering if it was something that you made and forgot about. Well you could go to Define Fields, look at every calculation and then go into ScriptMaker and look in there and then you could go over to Value Lists and try to track it down where it might be used or you could create your DDR. What this will allow you to do is do an HTML or XML Report that opens up in a web browser so you can see where this field is used, every layout, every value list, every script, everything where it's used so you can go ÒOh yeah, that's where it's used.Ó Or it's used nowhere I can delete it. And this does with Layouts; you can look at your Layouts and see what's on there. It just makes things so much easier by all this cross-referencing. So I highly recommend getting FileMaker 10 Advanced, it'll really help you out in your development.