Ultimate Find / Find Layout
Subtitles of the Movie
Before we start creating our find script, we need to create a find layout. I like to use a find layout because it gives me a lot of options as far as the number of fields and additional buttons I can put on the layout. You could also use a Show Custom Dialog to save time so you don't have to create that layout, but it does limit you to three input fields. So you can use Show Custom Dialog with this technique, but I'm going to use the layout because it gives me more options. So, we're going to go into Layout Mode and we're going to duplicate a layout and we're going to duplicate the separator layout, so we'll go to layout before it, move to it, and we'll duplicate it, then we'll go into Layout setup, we're going to type in customers, underscore find, very critical that you name this exactly the same thing as I'm doing, and then make sure we're showing records from customers. Now we can get rid of our logo, get rid of this text, and it's probably important at this point to set the layout order. I like to get these layouts organized, so I put customers find up with the rest of the customers' layouts. Now we can change this, so we'll double click on this and change it to Customers Find, oops. I've got the caps lock key there. And this is really nice because it tells them right when they get here that they're on a Find Layout, not just a regular customer's layout. And I'll select All, Copy, and then we want that 3D look, so I'm going to double-click on it; sometimes it's hard to get that double-clicked on, there we go. Get it all selected, and then I'm going to Option, Paste. So, I'm going to hold down the Option key, or if you're on Windows, the Shift key, so that I don't lose that gray text, otherwise we're pasting black text. So, we've kept our 3D look there, and what we also want to do is change this bar color. It's reminiscent of Browse mode, or where you do data entry. So, let's take it out, and we're going to go to the FileMaker reference and we're going to borrow this graphic. See if I can get him there. There we go, drag it into there, get rid of that. Now, this graphic will be in the work files, so if you don't have the FileMaker reference you still have this graphic because it's on the end work file for the solution for Chapter 2. So move that in there. Just right. Looks good. Duplicate it. Use our Smart Duplicate, so 1, 2, 3, 4, 5, 6; we don't want to de-select it. Get it right in there, and then I'll use the keyboard command for duplicate. Move it right on over, one more, and then move it back again. And we have completed the interface. So, that looks great. Now, this red color really tells them they're in Find mode. Now, we're going to add some fields in here and I'm going to go back to Customer's form and I'm going to select these three fields. Now you can select any number of fiends you want, because you can put any number of fields on there, but I don't want all the fields. You want to interview your customer, your client; whether you're a commercial developer or whether you're developing something for your company, and find out what they really need to do. Do they really need every single field on there? And you really want to focus your find on what they're trying to do. So I'm going to just copy these ones; you may do more, you may do less, it really won't make a difference as far as the script. Then we'll paste. Position them in there. That looks good. And, I also like to add some instructions in here, so we'll click and we'll type in instructions, hit the return, and we'll put in Enter your find criteria, and type the Enter key, or click the Continue button. There we go. Make that a little bit smaller, so we'll drag it down here, and we'll come in here and we'll line-text the top, change the text color back to, well, let's not choose black, let's choose this gray right here. Go to Style, take the Bold off, go to size; let's try 10 point. Make this a little bit smaller. And to really make these instructions stand out we're going to duplicate this, 1, 2, 3, 4, 5; 1, 2, 3, 4, 5, we'll change the text color to white, and then we'll Send it to Back. So what you get here is this engraved look. We can position right in there, and if you do this, people are going to get used to looking for this engraved look for any kind of Help instructions on layout. Be consistent and cross all your layouts, and be able to get that Interface key and understand that, Oh, that's the engraved look. That must be instructions. And you can even remove the word instructions here if you want to. So, now we're ready to write our script so we'll start by going back to Customer's form, we'll go into ScriptMaker, we'll make our find script called The Ultimate Find. It's not really ultimate yet, but it will be soon. And we need to start off by going to the right layout, which is our Customer's find. We can then enter Find mode. We want the pause because we want the script to pause so people can enter in what they want to Find on. Then we'll find Perform Find, not Perform Find Replace, make sure you get the right one; we don't want any Specify Find requests here, and then once they've performed the find then we can go to Layout, Original Layout. Now, Original Layout goes back to Layout where you click the button; remember that, it's important. So no matter how many layouts you visit in your script, if you say go back to Original Layout, it goes back to where you clicked that button. And this is nice because it makes the script dynamic so it goes back to whatever Customer layout you started on. It shows the results of the find in that layout. So we'll save that, uncheck that, double-click on our Find here, Perform Script, Ultimate Find, and of course, you'll have to change this on several other layouts; you have it on the Notes as well. Let's go to Browse mode and let's try it out. We go to this nice Customer's Find layout. We can type in John and then we can hit the enter key or the continue button, whatever you want.
Tutorial Information
| Course: | FileMaker Pro 9: Advanced |
| Author: | John Mark Osborne |
| SKU: | 33824 |
| ISBN: | 1-934743-32-1 |
| Release Date: | 2007-11-21 |
| Duration: | 10 hrs / 115 lessons |
| Work Files: |
Yes |
| Captions: | For Online University members only |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 98,729 Video Tutorials (23,265 free)
- Video Available as Flash or QuickTime
- Over 1026 Courses
- $30 for One Month Access
- Multi-User Discounts Available
United States 