User manual
Table Of Contents
- Preface Learning how to use FileMakerPro
- Chapter 1 FileMaker Pro basics
- Chapter 2 Adding and viewing data
- Chapter 3 Finding and sorting information
- Finding records
- Finding text and characters
- Finding exact matches in text fields
- Finding numbers, dates, and times
- Finding ranges of information
- Finding data in related fields
- Finding records that match multiple criteria
- Finding empty or non-empty fields
- Finding duplicates
- Finding all records except those matching criteria
- Hiding records from a found set and viewing hidden records
- Viewing, repeating, or changing the last find
- Sorting records
- Finding records
- Chapter 4 Previewing and printing information
- Chapter 5 Creating a database
- Chapter 6 Creating and managing layouts and reports
- Chapter 7 Customizing layouts
- Chapter 8 Working with related files
- Chapter 9 Protecting databases with passwords and groups
- Chapter 10 Creating scripts to automate tasks
- About scripts
- Creating scripts: an overview
- About ScriptMaker steps
- Control script steps
- Navigation script steps
- Sort, find, and print script steps
- Editing script steps
- Fields script steps
- Records script steps
- Windows script steps
- Files script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Changing scripts
- Duplicating, renaming, or deleting scripts
- Importing scripts
- Listing scripts in the Scripts menu
- Using buttons with scripts
- Example of a ScriptMaker script
- Chapter 11 Using formulas and functions
- Chapter 12 Importing and exporting data
- Chapter 13 Sharing databases on a network
- Chapter 14 Publishing databases on the Web
- About publishing databases on the Web
- How users work with databases on the Web
- What you need to publish databasesontheWeb
- Publishing databases on the Web: an overview
- Enabling FileMaker Pro Web Companion
- Configuring FileMaker Pro WebCompanion
- Enabling Web Companion sharing
- Setting up browser views
- Testing your published database
- About browser views for web publishing
- Chapter 15 Using ODBC with FileMakerPro
- Appendix A Customizing FileMaker Pro
- Appendix B Backing up and recovering files
- Appendix C FileMaker Pro Quick Reference (Windows)
- Appendix D FileMaker Pro Quick Reference (Mac OS)
- Index
10-2
FileMaker Pro User’s Guide
1 importing data from the same source
1 dialing phone numbers
You can perform additional scripts, called subscripts, within a script.
Subscripts make it easy to break a complex task into small tasks. For
example, you can find customers with a balance due with one script,
and then print form letters requesting payment with another script.
The first script contains a command that performs the second script
(the subscript). If a subscript is in a different file, it’s called an
external script.
With FileMaker Pro, you can:
1 define a script that pauses to let you do unscripted tasks, like
entering data. When you resume the script, FileMaker Pro performs
the remaining script commands.
1 save settings, like find requests and sort orders, in a script.
1 print the commands and settings that make up a script. (See
chapter 4, “Previewing and printing information,” for additional
information on printing from FileMaker Pro.)
1 define passwords that prevent other users from defining or
changing scripts. (See “Defining passwords,” on page 9-1.)
1 perform a startup script, a script that runs when you open a
FileMaker Pro file. For example, a startup script can switch to a data
entry layout whenever you open a customer order database.
FileMaker Pro can also perform a shutdown script every time you
close a file. (See “Setting document preferences,” on page A-5.)
1 send Internet mail using a separate email client (this requires an
email account).
1 launch Web browser software and have it display a specified URL
(Web address—this requires an account with an Internet service
provider).
The files you work with may already have scripts and buttons that
you can use. For example, the template files included with
FileMaker Pro have buttons that make using the file easier.
Note You can’t stop a script that contains the Allow User Abort
[Off] step.
For a description of the various types of scripts you can perform, see
“About ScriptMaker steps,” on page 10-6.
To Do this
Perform a script from the
Script menu
Choose the script name from the Script menu.
Perform a script from the
Define Scripts dialog box
Choose Script menu > ScriptMaker. Select the script
name, and then click Perform.
Perform a script using a
keyboard shortcut
Type the keyboard shortcut that’s listed next to the
script in the Script menu. (See “Listing scripts in
the Scripts menu,” on page 10-11.)
Perform a script from a
button
Switch to a layout that contains a button for the
script. In Browse or Find mode, click the button.
Perform a script when
opening or closing a
FileMaker Pro file
In the Document Preferences dialog box, set the
option to perform a startup or shutdown script. See
“Setting document preferences,” on page A-5.
Continue a script after it
pauses
Click Continue in the status area, or press Enter or
Return. If you switch layouts while a script is
paused and then continue the script, the remaining
script steps occur in the new layout.
Stop a paused script Click Cancel in the status area, switch to another
mode, close the active window, or quit
FileMaker Pro.
Stop a script (except when
it is paused)
Press Esc (Windows) or Command+Period
(Mac OS), hide or close the active window, or exit
out of FileMaker Pro. If the script contains a Close
or Toggle Window step that hides the active
window, FileMaker Pro stops the current script and
returns to the script that called it (if there is one).