Subtitles of the Movie

FileMaker Pro 10 Advanced also has a database design report. Imaging this scenario: think about a situation where you have a field and you're going I can't remember what this field is used for. Am I using it at all inside the solution anymore? Well, you could go and try to track it down. You could go into Manage Database and see what calculations reference it, then go into ScriptMaker and try to find every script that references it, or going to Define Value Lists and all over the place and see if anything is using it. This could take a long time. Or you could create your database design report and what this will do is create a report that is viewable in a Web browser and you'll go down to that field and you see, oh, it's used on this layout. It just cross-references everything, makes it easy to locate and find out where each object inside FileMaker is used, so you can look at a field, you could use a layout and see where it's used. I mean, it just has all this cross-referencing that really makes development on larger products really easy. Now, there are many other advanced developer features for customizing solutions. One of my favorites is custom functions. This allows you to create your own functions. Imagine going into the calculation dialog and using one of the existing functions, like the case or the if or the left or the middle or the right. Well, you can make your own left, middle, and right. You go into custom functions and you create that, so what it allows you to do is call on a very complicated formula with a simple syntax like you see inside the standard functions that come with FileMaker. Not only that, but if you happen to need to change that custom function, if you've used it in 10 places throughout your solution, you change it in one spot and it flows through your whole solution and updates it, rather than going to each spot and making the same update. Custom menus is another great feature. What it allows you to do is take the menus, because this slideshow is done in FileMaker, so take any of these menus here and change them. For instance, you could completely remove the Records menu, if you wanted to, or you could change the name. You could change the name of any menu item you want. You can remove it. You can change the keyboard command. You can even make that menu item run your own script. In fact, you can even make a completely new menu and menu items that all run scripts for yourself, so this is a great way, in addition to buttons, to control FileMaker for the user. Now, custom functions and custom menus are still available to people who are in FileMaker Pro 10, the regular version. You have to program them in FileMaker Pro 10 Advanced, but when you deploy your solution, they'll still be there. The custom functions will be usable and the custom menus will also. One of my other favorite features is being able to Copy and Paste Schema. Schema is things like fields, scripts, script steps, tables, things like that. You can easily copy and paste these things from one table to another. Let's say you had a field and you wanted to copy this field from this table over to another one. Well, instead of having to type it in and add all the auto enter and validation things you might have on it, you just Copy and Paste it. It makes life really easy. Let's talk about FileMaker Server 10. It's a high performance server software for teams of FileMaker client guests. You can share with up to 250 people at a time. That's a much larger group than what you can do with the regular FileMaker. It maximizes performance. That means you're going to get the ultimate performance. Even if you have just 10 users, you're going to get better performance than you will with the regular FileMaker Pro. It also has automation tools for back-ups and other administrative tasks. For instance, in regular FileMaker Pro, you have to quit FileMaker, make the back-up, because you can't make the back-up while the file is running, and then launch it again. Well, FileMaker Server can make a back-up as the file is actually running. There's plenty of other stuff that you can do with FileMaker Server 10, but we don't have time to go over it. Our focus in these tutorials is on developing solutions, not deploying, but still, I wanted to give you an idea of how this works, how FileMaker Server, what it's features are. It also has a Log Viewer with email notifications. This is new. It supports XML, XSLT for custom Web publishing. It also supports PHP for custom Web publishing and it supports ESS, or External SQL Data Source. So a great, great product if you're deploying to a great number of people, especially greater than 10 people. Now, what is FileMaker Server 10 Advanced? It has all of the features of FileMaker Server 10, but one of the newest things that's different than FileMaker Server 9 Advanced is it has a maximum of 999 guests on a network with a FileMaker Pro client. This is a big jump. Before, Server 9 Advanced still just had the 250 limit. Now it goes up to almost 1,000. It also supports ODBC and JDBC data sources. This is different from ESS. And it supports Instant Web Publishing with up to 100 simultaneous users.