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
2-8
FileMaker Pro User’s Guide
1 There are other ways to enter data in a field besides typing, like
importing or copying it from another source, using a related file, or
having FileMaker Pro automatically enter the data when you create
a record. See “About import and export” on page 12-1,“Displaying
data from related files” on page 8-1, and “Defining automatic data
entry” on page 5-8.
1 For more information about entering and changing data, see
FileMaker Pro Help. Choose Help menu > Contents and Index, click
the Index tab, and type entering data.
Using URLs in a field
If you have a valid URL (web address) in a field, you can open the
URL in an application that you specify:
1. Click the field to select it.
2. Right-click (Windows) or Control+click (Mac OS) any part of the
URL.
3. Choose Open <URL> from the context menu.
Note This feature requires the URL.DLL file (Windows) or Internet
Config 1.1 or later (Mac OS). These components are described in
Help. Choose Help menu > Contents and Index, click the Index tab, and
type
URLs.
Copying and moving data in records
You can copy values from any field type, including fields that are
formatted as radio or option buttons, checkboxes, lists, or menus.
Keep these points in mind:
1 When you copy a record, everything is copied except data in
container fields. Data is copied in tab-delimited format, in the order
the fields appear on the layout. Text styles, like bold or italics, aren’t
copied.
1 You can drag and drop information between fields, records, and
applications. See “Moving data with drag and drop” on page 2-9.
1 For more information about copying and moving data, see
FileMaker Pro Help. Choose Help menu > Contents and Index, click
the Index tab, and type data,moving.
Entering preset data from a value list
A field can display values as radio or option buttons, checkboxes,
pop-up or drop-down lists, or pop-up menus. You can use these
options to quickly enter preset data. The data is defined in value lists.
To Do this in Browse mode
Copy or move a value from
one field to another
Select the contents of the field, then choose
Edit menu > Copy or Cut. Display another record,
if needed. (See “Moving through records” on
page 2-4). Select the field to hold the data, then
choose Edit menu > Paste.
Copy a value from a field in
the last record that you
accessed (by clicking or
pressing Tab)
Click the field that you want to hold the data.
Choose Insert menu > From Last Record.
Copy values in a record to
another application, like a
word processor
With no field selected, choose Edit menu > Copy.
In the other application, paste the values that are
in the Clipboard.
Copy data in a master record
and in all related records in a
portal
With no fields and no records in a portal selected,
choose Edit menu > Copy.
Copy one related record in a
portal
Select a related record, then choose Edit menu >
Copy.
Copy the found set of
records to the Clipboard
With no fields selected, press Shift (Windows) or
Option (Mac OS) while choosing Edit menu >
Copy.
Duplicate data from another
record into the current record
See “Adding and duplicating records” on
page 2-4.
To Do this in Browse mode