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 and managing layouts and reports
6-17
To remove a field from a layout, in Layout mode, click the field to
select it, then press Backspace or Delete, or choose Edit menu > Clear.
Removing a field from a layout does not delete the field or its data
from your database. (To delete a field and its data, see “Deleting field
definitions and data” on page 5-12.)
Keep these points in mind:
1 If you include field labels when you place a field and you then
rename the field in the Define Fields dialog box, the field label
changes to match the new field name on each layout where the field
label appears.
1 You can make data entry for a field easier and more consistent by
defining a value list, associating it with the field, then formatting the
field as a pop-up menu, pop-up list, checkboxes, or radio buttons.
See “Defining a list of values for data entry” on page 7-3.
1 To have FileMaker Pro insert field data into a line or block of text,
use merge fields (see the next section, “Placing merge fields”).
1 To “close up” space between fields and other layout objects, omit
empty repetitions of repeating fields or empty portal rows, or reduce
the size of an enclosing layout part, specify sliding options. (See
“About removing blank space from printed data” on page 7-22.)
1 To put a static image (like a logo or graphic embellishment) on a
layout so it appears in every record, create, paste, or import the
graphic directly onto the layout instead of using a container field. See
“Inserting graphics onto a layout” on page 7-16.
1 Instead of placing fields, you can copy fields from other layouts
and other databases. See “Copying, duplicating, and deleting
objects” on page 6-13.
Keep these points about related fields in mind:
1 Before placing related fields on a layout, you should understand
the concepts in chapter 8, “Working with related files.”
1 In general, you work with related fields (for example, selecting,
resizing, formatting, customizing, and removing) in the same way
that you work with non-related fields. When you place a related field
on a layout, you need to know whether it should be located on the
layout or in a portal (see “Deciding where to place related fields” on
page 6-18).
1 In Layout mode, the field name displayed within the field on the
layout appears as ::Field Name for related fields.
1 When you include a related field on a layout (not in a portal) and
there is more than one related record, you see only the value from the
first related record. (The order of the related records depends on
whether a sort order was specified when the relationship was
created.) See “Deciding where to place related fields” on page 6-18
and “Defining relationships for relational databases and lookups” on
page 8-10.
Placing merge fields
Use a merge field—placeholder text in Layout mode that is replaced
by the field’s value when you browse, preview, or print the layout—
for documents like form letters, labels, envelopes, or contracts.
Merge fields shrink or expand to fit the amount of text in the field for
each record. (This behavior includes collapsing an entire line, such
as an empty Address Line 2 field, if the field is by itself on a line and
the field contains no data.)
For example, when the merge field <<First Name>> is between the
text Dear and :, (in other words, Dear <<First Name>>:) FileMaker Pro
displays Dear Charles: in Browse mode or Preview mode if the First
Name field contains Charles.
FileMaker Pro uses merge fields to create Labels and Envelope
layouts.
Note You can’t edit or enter values into a merge field.