Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In FileMaker Pro 11 Essential Training, Cris Ippolite demonstrates the principal features and functions of this popular database software, including creating tables and relationships, managing fields and records, and working with layouts. The course shows FileMaker developers how to find, sort, and share data as well as how to create reports, calculations, and scripts. It also covers brand new features in FileMaker Pro 11 such as the Inspector tool, charting, and portal filtering. Exercise files accompany the course.
Probably the most exciting new feature in the recent release of FileMaker, more specifically FileMaker 10, which is the previous version to this one, was the support for something that's called a Script Trigger. Now what is a Script Trigger? Well, we've already discussed creating scripts, and that helps you automate the process within your FileMaker database, but creating this script is really just half the battle, because in order for this Script to run, it needs to be triggered. Since triggering the script is necessary for them to run, it's a good idea to get familiar with all the different ways that you can do so. We've already discussed how when you are in Layout mode, you can attach a script to a layout object, which I've gotten here.
I've done that twice. And you can see under Button Setup, we've attached a Script step to this button, and in this case, right-click or Ctrl+Click on Button Setup and we see Perform Script, and we can attach another script to it. So in this case when a user presses this button, it will trigger the script. So that's a very common way to execute a script. Also, you'll notice, under the Scripts menu, that all of the Scripts are listed that have a blue check box next to them.
Of course, see one of them isn't listed there. So I can trigger a script by simply running one of these by selecting it under the Scripts menu. And also under the File menu, you've got File Options, and you can select to run a script when a file opens or when a file closes. We'll talk more about that in a later movie, but all of these are ways that you can trigger a script, and these have all been in FileMaker for many versions, but then back in FileMaker 10, several new Script Triggers were introduced, and they are broken up, really, into two categories.
One is object-based triggers, meaning that if you modify an object or select an object or different things you can do with an object will then trigger the script to fire. And then there is a layout-based triggers, which means when you land on a layout, you can trigger a script, or when something changes on a layout, or you change modes or something like that, all those can trigger scripts. So, really this is a game-changer. It opens things up pretty considerably, and the best way to approach these things is to get to know what all the different script triggers are. So in the upcoming movies in the rest of this chapter, we are going to talk about them based on their groups.
We are going to talk about object-based triggers and layout-based triggers, and then file-based triggers, and I am going to show you examples of each. So you already know how to write a script; now it's going to be all about how you can trigger those scripts, and the combination of those two things is really going to help you robustly automate the FileMaker database that you are creating.
Find answers to the most frequently asked questions about FileMaker Pro 11 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.