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
6-8
FileMaker Pro User’s Guide
Note FileMaker Pro uses merge fields when you create an Envelope
layout. You can’t enter or edit data using merge fields. Switch to
Table view (in Browse mode, choose View menu > View as Table) or
use another layout for that purpose. For more information about
working with merge fields, see “Placing merge fields” on page 6-17.
For more information about different views, see “Viewing records”
on page 2-2.
Working with, duplicating, deleting,
or renaming layouts
Once you’ve created more than one layout, use the layout pop-up
menu, or, in Layout mode, the book to easily switch between layouts.
Keep these points in mind:
1 It’s good practice to duplicate a complex layout before you modify
it, because you can’t undo major changes or revert to a previously
saved version.
1 A database must have at least one layout, so you can’t delete the
last one.
1 Layout names do not have to be unique.
1 In a multiuser database, only the host can reorder layouts, and only
when the database isn’t being shared (see “About sharing files on a
network” on page 13-1).
1 You can create, duplicate, or delete layouts using buttons on the
Standard toolbar (choose View menu > Toolbars > Standard). See
“Using toolbars” on page 1-5.
1 You can’t copy an entire layout to another FileMaker Pro file, but
you can accomplish the same thing by saving a clone of the file. (See
“Saving files” on page 1-7.) You can also copy and paste fields and
layout objects to another file. (See “Copying, duplicating, and
deleting objects” on page 6-13.)
1 All layouts are displayed in the layout pop-up menu in Layout
mode, whether Include in layouts menu is selected or not.
Setting up to print records in columns
You can choose to print (or preview) records in columns, for
example, for a directory of names and addresses. This is in contrast
to a Columnar list/report layout, which arranges fields in columns.
To In Layout mode, do this
Duplicate a layout From the layout pop-up menu, choose the layout to
duplicate, then choose Layouts menu > Duplicate Layout.
You see the duplicated layout, and FileMaker Pro adds its
name—with Copy appended—as the last choice in the
layout pop-up menu.
Delete a layout From the layout pop-up menu, choose the layout to delete.
Choose Layouts menu > Delete Layout, then click Delete in
the alert message. You can’t undo deleting a layout.
Rename a layout From the layout pop-up menu, choose the layout to
rename. Choose Layouts menu > Layout Setup and for
Layout Name, type a descriptive name, then click OK.
Reorder layouts in
the layout pop-up
menu
Choose Layouts menu > Set Layout Order. Position the
pointer over the layout name and drag the layout name to
a new position, then click OK.
Include or exclude
a layout in the
layout pop-up
menu in Browse,
Find, and Preview
modes
Choose Layouts menu > Set Layout Order, then click a
layout name. To include the layout, select Include in layouts
menu. To exclude the layout, clear this option. (You can
also click to the left of the layout name to select or clear
this option.)
You see a checkmark next to the name of a layout that’s
included in the layout pop-up menu.
To In Layout mode, do this