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-6
FileMaker Pro User’s Guide
Form View, Web
setting up 14-10
viewing in browser 14-14
Formats
default 6-22
display 6-22
international 1-7
Formatting
calculations 6-22
custom line spacing 7-13
dates 6-23
export data 12-7
fields
defaults 6-22
text 7-12
graphics 6-24
import data 12-1
merge fields 6-18
paragraphs 7-12
repeating fields 7-7
scroll bars 7-2
tables 6-10
text 6-22, 7-12, 7-13
times 6-24
Forms
See also Layouts
Standard form layout 6-3
viewing records as 2-2
Formulas
calculation fields 5-5
changing 5-11, 5-12
constants 11-2
described 11-1
expressions 11-2
field references 11-2
functions 11-5
operators 11-3
results 11-1
syntax 11-1
Found set
copying 2-8
deleting 12-5
described 2-1, 3-1
import data 12-5
switching with omitted set 3-7
FP5 filename extension 1-6
Fraction of Total for summary
fields 5-7
Functions
described 11-5
parameters 11-5
Web Companion 11-13
G
Getting help. See FileMaker Pro
Help
Global fields
See also Fields
defining 5-8
described 5-4, 5-8
examples 10-13
importing 12-2
shared files 13-2
Glossary, in FileMaker Pro Help
x, xi
Grand summaries
See also Grand summary parts
described 6-26
exporting 12-8
Grand summary parts
See also Subsummary parts
described 6-26
leading 6-26
page breaks 6-29
printing 6-28
trailing 6-26
Graphic
objects
adding to layouts 7-14,
7-16
rulers
described 7-20
showing/hiding 7-20
Graphics
adding to layouts 7-16
comparing 11-5
copying 2-8
deleting 2-13
file formats 2-12
finding 3-2
inserting into fields 2-11
on the Web 14-4
pasting 2-13
positioning 6-14, 7-19
rotating 7-18
saving in Macintosh PICT
format A-5
storing methods 2-11
Grids
in tables 6-10
on layouts 7-20
Grouping objects 7-17
Groups
access privileges 9-1, 9-3
associating with passwords
9-4
changing 9-5
defining 9-3
deleting 9-5
embedded 7-18
examples 9-4
limiting access 9-1
master passwords 9-5
versus passwords 9-6
Guest book, on Web 14-11
Guests
closing files 13-4
described 13-1
limits, on the Web 14-2
opening files 13-5
performing tasks 13-2
saving files 13-2, 13-4
sending messages to 13-3
Guides. See Object Grid; Ruler
lines; T-squares
H
Headers
described 6-25
Envelope layout 6-7
showing in table view 6-10
title 6-25
Help
for databases in browser 14-6,
14-14
for FileMaker Pro ix
Hiding objects
See also Showing/hiding
during printing 7-22, 7-25
Hiding shared files 13-4
Home page
built-in 14-3, 14-6, 14-8
customizing 14-6
directing Web users to 14-3
logging activity 14-8
replacing built-in 14-6
specifying default 14-8
Host
closing files 13-4
database on Web 14-1, 14-5
described 13-1
FileMaker Server 13-1, 13-5
opening files 13-3
performing tasks 13-2
saving files 13-2, 13-4
sending messages to guests
13-3
HTML files
described 14-1
HTML table format 12-1
HTTP commands 14-9
HyperText Markup Language.
See HTML