Subtitles of the Movie

FileMaker Pro 10 Advanced also has a database design report. Imagine 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 and go into ScriptMaker and try to find every script that references it or go into Define Value List and all over the place and see if anything is using it. This can 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 could 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 and 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, if you happen to need to change that Custom Function and you used it ten 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 yourselves. 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. And one of my other favorite features is being able to Copy and Paste schema. Schema is things like fields, scripts, script steps, tables, thing like that. You can easily copy and paste these things from one table to another. Let's say you had a field and you want 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. 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 to 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 ten users, you're going to get better performance than you will the regular FileMaker Pro. It also has automation tools for backups and other administrative tasks. For instance, in regular FileMaker Pro you have to quit FileMaker, make the backup because you can't make the backup while the file's running and then launch it again. Well, FileMaker Server can make a backup as the file is actually running and 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 want to give you an idea how this works, how FileMaker Server, what its 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 ten people. Now, what is FileMaker Server 10 Advanced? It has all 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 had just the 250 limit. Now it goes up to almost a thousand. It also supports ODBC and JDBC data sources. This is different than ESS and it supports instant web publishing with up to 100 simultaneous users.