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-8
FileMaker Pro User’s Guide
Records script steps
Windows script steps
Files script steps
Insert Object
(Windows)
Insert an embedded or linked object into a container
field
Update Link
(Windows)
Update an OLE link in a container field
Use this step To
New Record/Request Add a record or find request
Duplicate Record/Request Duplicate a record or find request
Delete Record/Request Permanently delete the current record or find
request
Delete Portal Row Permanently delete the current portal row. Use
Go to Portal Row to specify which is the current
row.
Revert Record/Request Return the current record or find request to the
way it was before you added or changed its data
Exit Record/Request Exit the current record or find request to update
the field data and make no field active
Copy Record Copy the contents of the current record to the
Clipboard
Copy All Records Copy the contents of the found set to the
Clipboard
Delete All Records Permanently delete all records in the current
found set
Replace Change the contents of a field in all records in
the found set
Relookup Update a lookup value in records in the found set
Import Records Bring data from another file into the current file
Export Records Save data in a format you can open in another
application
Use this step To
Use this step To
Freeze Window Stop updating the window (hide actions from users)
Refresh Window Redraw the screen, or resume updating after Freeze
Window
Scroll Window Scroll the window up, down, or to the current
selection
Toggle Window Hide (Mac OS) or change the size of the window
Toggle Status Area Show, hide, or lock the status area
Toggle Text Ruler Show or hide the text ruler
Set Zoom Level Reduce, enlarge, or lock the contents of a window
View As View records individually, in a list, or as a table
Use this step To
New Create a file
Open Open a file. Subsequent steps operate in the file that
contains the script, not the file just opened.
Close Close a file
Change Password Modify the password utilized by the current user
Set Multi-User Set network access for the current file to On, On
(Hidden), or Off
Set Use System
Formats
Use date, time, and number formats saved with the
current file, or use the system formats
Save a Copy as Save a copy of the current file
Recover Recover a file