Newsletter #10
Saving A Found Set of Records
(Using a Script)

One of my clients recently asked me how to save a complicated found group of records so they can find them again without all the hard work. Here's the lowdown.

Once you have your found set, FileMaker remembers what you just did. (It also remembers the last sort, import and export you performed, too - among other things.) So you should immediately create a script to find that group again.

(The following steps are specific to FileMaker 9, but you will find that most of it applies to versions way back. The main differences are how you close the various script windows.)

1) Go to the Scripts menu and choose ScriptMaker.
2) Click the "New" button.
3) Give your script a name that will mean something to you 6 months from now.
4) Scroll down on the left until you see the "Found Sets" heading. Double-click the "Perform Find" step to send it over to the right.
5) In the lower right corner, click the Specify button. The Specify Find Requests dialog will show you the find you just ran. You don't need to do anything here except click OK.
6) Click the X to close the window. FileMaker may ask you if you want to Save the script - and you sure do!
7) Make sure your script has a checkmark to the right of it in the list.
8) Click the X to close the Manage Scripts window.

Now whenever you want to get your complicated find back, just go to the Scripts menu and choose that script.

But what if you want to make some small changes to your find each time? For example, let's say you were looking for a group of sales records in a specific date range. Each time you run the script, you might want to choose a different date range.

1) Run your script.
2) Go to the Records menu and choose "Modify Last Find."
3) Make your changes to the find and click the "Find" button on the left (or type the Enter key on your keyboard).

There you go! A complicated find performed easily with small changes whenever needed.

If you make changes to your find that you want to make permanent, just create a new script following steps 1-8 above.

Keep in mind that trying to find data in a portal may not provide the expected results. For the details on that go to my website at http://datadesignpros.com/news.htm and click on Newsletter #3.

Hope this inspires you to start using ScriptMaker to do more of your work for you. That's what this technology stuff is all about!

UPDATE:
Technology marches forward doesn't it? FileMaker 11 introduced an interesting feature called Snapshot Link. With it you can save a little file and send it to anyone who has access to your database and it will return you or them to the exact set of records on the same layout you were looking at when you saved the snapshot.

Once you have the set of records you want, go to the File menu and choose Save/Send Records As > Snapshot Link. In the next dialog you'll be asked what you want to name the file and where you should save it. I recommend the desktop where you can find it easily. You'll also notice you have the option to create an email and attach the Snapshot Link file to it. Just keep in mind that the user needs to have access to the file, which must be open and shared when they try to access it. One added feature of Snapshot Link is it will even tell the user if one or more records have been deleted since the snapshot was created.

The disadvantage of Snapshot Link over a script is that the script stays with the FileMaker file and it's always right there under the scripts menu or attached to a button you create for the user. It's easy to lose the Snapshot Link file.


You can get to my other newsletters by clicking here.


*****
Etc...

Of course, the main purpose of this newsletter is to remind you that I'm here to serve your FileMaker needs - development, support, and training.

If you can think of anyone you might refer me to, I offer a 5% "Thank You!" for the first 2 years of billing on referrals.

< Back to In the News

 

 
   
Email us here.