VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources] - نسخه متنی

Cynthia L. Baron, Daniel Peck

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
ارسال به دوستان
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
جستجو در لغت نامه
بیشتر
لیست موضوعات
توضیحات
افزودن یادداشت جدید











Creating Sub-Scripts


You can create small sub-scripts that do one or two specialized tasks, then combine them with a more generic larger script to execute a variety of actions. These scripts may only contain one step apiece, but they allow you to retain a variety of settings without having to re-search or re-sort each time you want to create a variation on one script idea. For example, if you frequently have to sort your files by last name, you can preset your database with this sort, then create a sub-script that only has a Sort step in the script. Then you can add this sub-script to any other scriptfor updating accounts payable or analyzing account payment patternsas you need it. We use this strategy to create a search script for payments by check.

To create a sub-script to find records



1 .Choose Scripts > ScriptMaker (Control+Shift+S/Command+Shift+S).

2 .When the Define Scripts dialog box appears, click New.

3 .When the Edit Script dialog box appears, type Find Checks in Script Name.

4 .

Scroll down to the Found Sets category in the left window and double-click Perform Find (Figure 7.22).

Figure 7.22. You don't need to have an existing found set in place before you select Perform Find.


5 .In the Script Step Options section, click Specify.

6 .When the Specify Find Requests dialog box appears, click New (Figure 7.23).

Figure 7.23. You can save different find criteria in the Specify Find Requests dialog box, and select the one you need for a specific sub-script.


[View full size image]

7 .When the Edit Find Request dialog box appears, select a table from the "Find records when:" drop-down list.

8 .

Select Payment from the scrolling list of fields (Figure 7.24).

Figure 7.24. To create a new find request, first select a field.


[View full size image]

9 .In the Criteria section, type Check, then click Add (Figure 7.25).

Figure 7.25. This script will find all payments made by check.


[View full size image]

The new criteria will appear in the top section of the dialog box.

10 .

Click OK four times to finish. You now have a script that will just find all of the records that were paid by check.

11 .To create scripts for other types of payment, follow these steps but substitute other payment types in the Criteria section. In our example, we created a total of four small scripts sorted for cash, purchase orders, and credit cards as well as check (Figure 7.26).

Figure 7.26. To build modular master scripts, each sub-script contains only one set of criteria.



To create a sub-script to sort records



1 .Choose Scripts > ScriptMaker (Control+Shift+S/Command+Shift+S).

2 .

When the Define Scripts dialog box appears, click New.

3 .When the Edit Script dialog box appears, type Sort by Last Name in Script Name.

4 .

Scroll down to the Found Sets category in the left window. Double-click Sort to move it to the script-assembly list. Click Specify (Figure 7.27).

Figure 7.27. This sort script has a fixed sort order, so it doesn't require the dialog box.


[View full size image]

5 .When the Sort Records dialog box appears, double-click the Last Name field in the left column (Figure 7.28). Click OK three times to finish.

Figure 7.28. Select the sort criteria for your sub-script in the Sort Records dialog box.


This creates a small sub-script that will sort data by the Last Name field.


Tip

Sub-scripts are a great time-saver when you are still developing your database. You can group all scripts that do a specific joblike scripts that sort or findto locate them easily.


/ 227