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
Creating scripts to automate tasks
10-7
Sort, find, and print script steps
Editing script steps
Fields script steps
Go to Previous Field Move to the previous field on the current layout
Enter Browse Mode Switch to Browse mode
Enter Find Mode Switch to Find mode
Enter Preview Mode Switch to Preview mode
Use this step To
Sort Order records in the found set
Unsort Restore records to the order in which they were
created
Show All Records Show all records in the file
Show Omitted Show records that aren’t in the found set
Omit Record Leave the current record out of the found set
Omit Multiple Leave a number of records, starting from the current
record, out of the found set
Perform Find Find records that match the current find request(s)
Modify Last Find Change the last find request(s)
Print Setup (Windows)
Page Setup (Mac OS)
Set Print Setup (Windows)or Page Setup (Mac OS)
options for printing, like horizontal or vertical
orientation
Print Print information from the current file
Use this step To
Undo Undo the last action
Cut Delete the contents of a field and put them in the Clipboard
Copy Copy the contents of a field, or a page in Preview mode,
to the Clipboard
Use this step To
Paste Paste the contents of the Clipboard into a field
Clear Delete the contents of a field without copying the contents to
the Clipboard
Select All Select the entire contents of a field
Use this step To
Set Field Replace the contents of a field with the result of a
calculation. The field doesn’t have to appear on the
current layout.
Insert Text Insert a text string into a field
Insert Calculated
Result
Insert the results of a calculation into another field on the
current layout
Insert from Index Insert a value from the index into a field
Insert from Last
Record
Insert data from a field in the last active record into the
same field in the current record or find request. (The last
record to contain an insertion point in a field is the active
record.)
Insert Current Date Insert the current system date into a field
Insert Current Time Insert the current system time into a field
Insert Current User
Name
Insert the name of the current user into a field. (The user
name is specified in the application’s general
preferences.)
Insert Picture Insert a picture into a container field. (To insert the
picture the container field must be active when the step
is executed.)
Insert QuickTime
(Windows)
Insert Movie
(Mac OS)
Insert a QuickTime movie into a container field. (To
insert the movie the container field must be active when
the step is executed.)
Use this step To