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
I-2
FileMaker Pro User’s Guide
viewing databases in 14-3,
14-6, 14-14
views for 14-14
Browsing records
access privileges 9-1
described 2-1
groups of 2-1
in a list 2-2
individually 2-2
on Web 14-14
sorted 3-8
Built-in home page 14-3, 14-6,
14-8
hiding databases on 14-6
Buttons
borders 7-17
changing appearance 7-14
copying or deleting 10-13
defining 10-12
described 10-12
non-printing 7-25, 10-13
performing scripts 10-2, 10-12
showing 10-13
C
Cache, setting size A-3
Calculation fields
changing 5-12
defining 5-5
described 5-4
formulas 5-5, 11-1
functions 11-5
importing 12-2
moving to 2-7
stored results 5-11
unstored results 5-11
Calculations
See also Calculation fields
formatting 6-22
formulas in match fields 8-5
functions 11-5
importing 12-2
related fields
field references to 5-5
summarizing data 8-12
Cascading style sheets 14-2,
14-11
Case-sensitive text, finding 3-3
CGI applications 14-2
CGM format 2-12
Changing
See also Editing
access privileges 9-3
calculation fields 5-12
dictionary terms 2-14
field definitions 5-11
formulas 5-11, 5-12
layout parts 6-26, 6-29, 6-30
layouts 6-8
passwords 9-3
portals 6-19
preferences A-1
related fields 6-17
relationships 8-12
scripts 10-10
serial numbers 2-10
stacking order 7-18
units 7-12
value lists 2-9
Characters, deleting 2-14
Charts, with FileMaker Pro data
15-2
Checkboxes
See also Value lists
choosing from 2-9
displaying field values 7-6
editing 2-9
ClarisWorks file format 12-1
Client application, ODBC 15-1
Clients. See Guests
Clones 1-7
Closing FileMaker Pro 1-8
Closing files 1-7, 13-4
Coffee cup icon 13-2
Color
cross-platform A-2
fill 7-15
in layout themes 6-5
in web views 14-11
palette 7-15, A-2
pen 7-15
text 7-12
Columnar list/report layout
See also Layouts
described 6-3
reports with grouped data 6-5
Columns
in Excel spreadsheets 12-4,
12-6
in ODBC tables 15-1, 15-8
in tables 2-2, 6-10
page breaks 6-29
printing 4-2
printing records in 6-8
resizing 7-22
setup 6-9
Commands. See Script steps
Comma-Separated Text format
12-1
Comments, in scripts 10-9
Comparison operators 11-3
Complex key fields 8-6
Compressed copies of files 1-7,
B-2
Confidential information. See
Access privileges
Connecting files. See OLE
objects; Relational databases
Constants 11-2
Container fields
See also Fields
comparing contents of 11-5
deleting 2-13
described 2-11, 5-4
exporting 12-8
formatting 6-24
importing 12-2
inserting graphics, movies,
and sounds into 2-11
on the Web 14-4
searching by 3-2
Context menus 1-5
Converting
field names in importing 12-6
files 1-7
files from other applications
12-6
Copying
buttons 6-13
field definitions 1-7
fields
between fields 12-2
between files 6-13, 12-1
from previous record 2-8
found set 2-8
graphics, movies, and sounds
2-8
layouts 6-8
objects 6-13
OLE objects 13-3
records 2-4, 2-8
related records 2-5, 2-8
scripts 1-7, 10-10
text 2-14
text using drag and drop A-2
value lists 7-5
values 2-8
versus importing or exporting
12-1
Count for summary fields 5-7
Creating. See Adding; Defining
Cross-platform
considerations 13-2