User manual
Table Of Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Saving find requests
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 3 Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Defining database fields
- Using supplemental fields
- Setting options for fields
- Defining database tables
- Creating layouts and reports
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with parts on a layout
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing databases on the web
- Chapter 6 Protecting databases with accounts and privilege sets
- Chapter 7 Converting databases from FileMaker Pro 6 and earlier
- Chapter 8 Security measures
- Index
68 | Using databases
Automating tasks with scripts
Scripts can do simple tasks like setting print orientation or complex tasks like
preparing a customized mailing to clients. Scripts can incorporate conditional
decisions (if-else statements) and perform repetitive tasks (loop statements).
You use the Manage Scripts feature in FileMaker Pro to build scripts by
selecting from a list of FileMaker
Pro script steps, specifying options, and
arranging the steps in the correct order to perform the task.
Use scripts to combine and automate tasks like:
1 switching to another layout or mode
1 finding, sorting, and printing records
1 importing data from the same source
FileMaker Pro makes it easy for you to manage scripts. You can display a
default script to use as a template when writing your own scripts. You can open
several scripts at once to compare them. You can copy and paste entire scripts
between files. You can copy and paste script steps from one script to another
script in the same file or to a script in a different file. You can assign scripts to
groups to make it easy to find scripts of a specific type (for example, copy an
entire group of scripts to another file or delete an entire group of scripts). And
you can design scripts to run when a particular event occurs (such as when
users enter a field, press a key, or add a new record to the database).
Procedures for creating and managing scripts and a reference to all
FileMaker
Pro script steps (organized alphabetically or by category) are
available in Help.
Backing up database files
Routine backups are imperative for any document stored on a computer. It is
easier to restore a backed up database than it is to recreate it. How often you
should back up depends on the amount of data you are adding to your
databases, and how difficult it would be to recreate your files if they become
corrupt.
For very important files, it’s a good idea to routinely store backups at an off-
site location.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 68 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ