Subtitles of the Movie

So we'll go back into here, the status area, here we go. And one of the great things that they've added are Script Triggers. You've already had Script Triggers on open and close, now you can run Script Triggers in many different places. And we can't go over all of them but this gives you an idea, there's, when you enter an object, when you type a keystroke inside an object, on layouts you can say what a record loads run a Script. I mean these are just tremendous ways to make Scripts run without having to click on a button. Very, very simple so we're going to go into these, there's a whole chapter in the advanced tutorial but I'm going to give you a few examples here. So let's go back over to new example, we'll hide this, resize that, go to Script Triggers and the first one is an Object Script Trigger. And if I come in here and try to type one more letter in the state field, it'll automatically come up right away and tell me. So I have to take that out. Your standard validation would require you to actually exit out of the field and then you have the choice of reverting the field. Here you do have the choice of putting anything inside this dialog you want and running any kind of branches off this you want. So it's very powerful but also realize that there are limitations of data validation through Script Triggers. Realize that it's not field level, it's layout level. So if you set the Script Trigger on this object, you have to go to every layout where that field might be, where with your standard field level validation that you do in manage database, well it's different. No matter where that field appears it'll do it, so you gotta decide the advantages and disadvantages of both approaches. Let's real quickly show you where this is set. We simply go over here to Script Triggers, click on state 2 and we're going to go into View, here we go, set Script Triggers and you'll see that we have on object modify and on object exit. So we have it on both. The one you really saw was on object modify which is whenever you modify it, run a Script and determine if there's more than 2 characters, it's that simple. I don't want to get further into it; we'll get into it further later because we just want to give you an overview here. So now let's also take a look at a different type of Trigger, a different category, these were objects, this is now a layout or record level Script Trigger. And if I go to show this report and we're going to make sure that we're showing all records and then we go ahead and sort it, we'll notice that we have our report. Now if I come in here and unsort it and then go back here and then simply come back, we'll notice that it'll sort it for us already. Now you may think I'm using Script to do that, well the Script that actually does that is this, sort category, that sorts by records by category. And it actually is attached here. So we're going to come in here to layout set-up and we'll view the Script Triggers, and you'll notice it says on layout load, run that Script. So, if that's true, then I don't have to get over here through a Script, so I'm going to prove that. We'll go into sort records, we'll unsort it and now we're going to switch manually here so I'm going to show the status area, switch to our form view and then simply switch back to our live sub summary and that Script Trigger ran and sorted it. Now if I change the data that's maintain sort order, that's a whole different thing. But the mere fact that it wasn't sorted was run by a Script Trigger so this is great thing to do on a live sub summary report is to sort it like that. So, anyhow, there are many more examples we'll cover in the advance section on this. And also along with that are the Script Trigger and tool tip icons. Because tool tips have been moved into FileMaker Pro 10, there used to be only in FileMaker Advanced but now they're in FileMaker Pro 10. So if you go in there and we just happen to have some Script Triggers here, so we'll hit done, look at this, uh, we'll go into Layout Mode. And what we need to do is View, Show, Script Triggers. And you'll see this little red asterisk and you'll see a similar icon when you view and show your tool tips as well. So we'll go back to our slides here and there have been some Scripting UI changes and we want to cover those briefly. Um, we'll cover those in the next section here so we're going to stop for a second so you can take a breather and we'll cover Scripting UI changes next.