Subtitles of the Movie

Let's talk about the family of FileMaker Products. It can be a little bit confusing when we see them all lined up. Which ones do you need? What do you need to program FileMaker? What do you need to ploy FileMaker? It can be a little confusing so let's get an overview of these and then go into each one in depth so you can get an idea of what their feature set is. So the first product is FileMaker Pro 10, it's your workhorse, it does just about everything. You can develop a solution, a fully functional solution in FileMaker Pro 10 and you can even deploy with FileMaker Pro 10 making your solution available to a network of people. FileMaker Pro 10 Advanced is exactly the same product as FileMaker Pro 10 but it has additional advanced features. Those would be advanced features for developers. Makes it a little bit easier for a developer to create a solution. FileMaker Server 10 and FileMaker Server 10 Advanced allow you to deploy, you can't program in them, only deploy and deploy to a larger audience. They also have administrative tools which we'll go over. Now you noticed that FileMaker Mobile is not listed here if you're familiar with the product. It has been discontinued, it's no longer available, there's no alternative from FileMaker at this moment. The closest alternative is a third party product called FM Touch, I've used it, it's great, it works on the I phone, so it doesn't work with a variety of devices that FileMaker Mobile does. But it's a good alternative and you may want to check it out. So let's talk more in depth about FileMaker Pro 10. FileMaker Pro 10 allows you to create fully customized relational databases systems. You can use calculations, scripts, validation auto enter, web viewers, all the features that FileMaker is known for are in FileMaker Pro 10. You can even share with up to 9 simultaneous users over a LAN or win with FileMaker Pro Clients or 5 simultaneous users over LAN or win with a web browser client and instant web publishing or IWP. So it's a great product, you can do a lot with it but let's find out what FileMaker Pro 10 Advanced can do in addition to FileMaker Pro 10. Now in this tutorial we'll be using FileMaker Pro 10 Advanced. And so I recommend it, it's not that can't go through this tutorial and get a lot out of it. Ninety-five percent of what we cover will be applicable to the regular FileMaker Pro 10. Uh, in fact even where we use FileMaker Pro 10 Advanced is you'll see in these features, it's not required to create a complete solution. But let's go over the specific features. First of all it has everything that FileMaker Pro 10 has. Everything listed on the previous slide. In addition it can create run time solutions. These are stand-alone solutions, in fact what you do is you bind a copy of FileMaker that doesn't allow you to go into define database or Script Maker or create calculations or fields but allows someone to use your solution. And you can distribute it royalty free, license free, there's no additional cost. So you can put a copy of your wonderful Contact Manager on a website, have people download it and use it royalty free. I don't use it much for runtime solutions but a lot of people do but my favorite features are the debugging and troubleshooting tools. FileMaker Pro 10 Advanced has a script debugger. This allows you to slow down your script so you can see them run one step at a time and we'll be using this throughout the tutorial so you can get an idea how to use it but I want you to know an overview of what you get with FileMaker Pro 10 Advanced. It's great, the script debugger will allow you to pinpoint because when you're walking thought he scripts step by step instead of really quickly, you can see what's happening in the background. You can see all the data changing, the layout changing, all that kind of stuff. This really helps you pinpoint where a problem in your script is. And then my favorite feature by far is the Data Viewer. It does many things, you'll want to go ahead and pigeon hole it, it's got a lot of uh, a lot of ability. So one thing it does is it can run with the script debugger to show you stuff. So if you're walking through a script and you don't happen to have a field that's referenced inside the script on the current layout because you just don't need to see it, well the data viewer can show you the data that's going to that field. It can also show you variables, you can write in calculations. In fact, writing in calculations is one of my favorite things to do. In fact you don't even use it with a debugger. You just go in and you open up the Data Viewer and you go to the section where you can write your calculations and what I like to do is use it as a scratch pad or a cocktail napkin, where you write your calculation instead of going in your script, writing in the calculation, running the script which might be a hundred lines long and seeing that the, the calculation didn't work you can debug it inside the Data Viewer, not have to go in and out of ScriptMaker or even manage database and perfect it and then Copy and Paste it to your script and it should work just fine.