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-11
Importing scripts 
FileMaker Pro allows you to import scripts from other 
FileMaker Pro databases. 
Many scripts reference fields (local and related), layouts, records, 
and other scripts (local and in external files). In addition, some script 
steps, such as Set Field, Insert Calculated Result, Replace, etc., may 
have field references embedded in calculations. While these 
references may be valid in the original file, it is possible that they will 
be invalid in the file into which they are being imported. 
To minimize the loss of information, FileMaker Pro attempts to map 
field, relationships, scripts, and layout references based on their 
names. Fields, relationships, scripts and layouts that cannot be 
mapped are marked as unknown, and should be edited and corrected 
before the script is performed.
When you import a script, you might need to edit the script to make 
sure that all references are valid and appear as intended. Always 
review your imported script prior to performing it for the first time.
To import a script
1. Open the file into which the script will be imported.
2. Choose Scripts menu > ScriptMaker.
3. Click the Import button.
4. Open the file that contains the script(s) you want to import.
5. In the Import Scripts dialog box, place a check mark next to the 
script(s) you want to import.
6. Click OK, then click OK again.
Keep these points in mind:
1 During script import, the match for field and layout names is case 
sensitive. If no match can be found, the word <unknown> will appear 
in place of the missing field and/or layout name.
1 When importing a script that references a relationship, 
FileMaker Pro assumes that 
1 the names of the relationships are the same
1 the keys of the relationships are the same
1 the base fields’ names, types and keys are the same
If all of these conditions are not met, the unmatched items will have 
the word <unknown> appended to them within the script.
1 When importing script steps that contain calculations (for 
example, If, Set Field, and Insert Calculated Result), FileMaker Pro 
matches field name and field type. If a match is not found, the word 
<unknown> will appear in place of the missing field.
1 Information stored in scripts (for example, Find requests, Sort 
order, Import field order, and Export field order) will attempt to be 
mapped to original fields using the above rules. If no original 
matching field can be found, the unmapped fields will be replaced 
with the word <unknown>.
1 When importing scripts that contain the Perform Script step, the 
link between scripts will be retained only if the linked scripts are 
imported at the same time. If a script with the same name is already 
present in the target file, no attempt will be made to link between the 
two scripts. If the Perform Script step references an external script, 
the imported script will also reference the external script.
Listing scripts in the Scripts menu
FileMaker Pro lists scripts in the Script menu and assigns keyboard 
shortcuts, like Ctrl+1 (Windows) or Command+1 (Mac OS), to the 
first ten scripts. 
To change the order of scripts in the Scripts menu:
1. Choose Scripts menu > ScriptMaker.
2. In the Define Scripts dialog box, drag the double arrow to the left 
of the script name to a new position.










