User manual
Table Of Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Working with data in Table View
- Finding records
- Performing quick finds in Browse mode
- Making find requests in Find mode
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Viewing, repeating, or changing the last find
- Saving find requests
- Deleting and reverting requests
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 3 Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Working with layout themes
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with layout parts
- Working with layout object, part, and background styles
- Creating and editing charts
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- Setting up recurring imports
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing databases on the web
- Chapter 6 Protecting databases
- Protecting databases with accounts and privilege sets
- Creating accounts and privilege sets
- Viewing extended privileges
- Authorizing access to files
- Security measures
- Enhancing physical security
- Enhancing operating system security
- Establishing network security
- Backing up databases and other important files
- Installing, running, and upgrading antivirus software
- Chapter 7 Converting databases from FileMaker Pro 11 and earlier
- Index
157
Boolean values
described 36, 58, 70
finding 36
formatting 95
Break fields 101
Browse mode
creating charts in 105
described 22
finding data in 31
Browser, web, working with published database in 136
Browsing records 22
Bubble charts 105
Buttons, including in tab order 27
C
Calculation fields
creating 63
described 58
formulas 63
stored and unstored results 71
Calculations
See also Calculation fields
formatting 95
related fields
field references to 64
summarizing data 120
Calendars, displaying in fields 91
Case-sensitive text, finding 35
Changing
data in fields 28
find requests 41
lookups 123
preferences 50
relationships 119
Characters
maximum in fields 28
not allowed in field names 57
Charting data
creating charts in Browse mode 105
creating charts in Layout mode 105
described 105
editing charts in Layout mode 107
quick charts 105
Checkboxes, displaying fields as 91
Clients
described 125
performing tasks 128
saving files 125
Clones (files) 21
Closing windows and files 20
Color, changing for text 94
Column charts 105
Columns
changing width 80
printing records in 79
resizing in tables 29
Combo boxes, displaying fields as 92
Comma-separated text format 130
Compacted copies of files 21
Comparison operators 64
Container fields
See also Fields
aligning to text 98
described 58
formatting 98
inserting files into 29
saving content in single copy of file 21
storage options for 68
Context menu, choosing from 14
Control styles for fields 91
Control-click to display shortcut menu 14
Converting files 154
Copying
field definitions 21
files 20
records 25
related records 26
scripts 21
Count of, for summary fields 66
Creating See Adding; Defining
Cross-platform, file sharing 18
Currency, formatting 95
Current
date, formatting 95
time, formatting 96
Custom menus, FileMaker Pro Advanced 9
D
Data
charting 105
described 14
entering automatically 25
, 68
exporting 130
formatting 83
importing 130
privileges for sharing 138
view as form, list, table 22
viewing in Table View 29
Data entry 28
, 67–70
Data Entry Only privilege set, described 140
Data sources
described 136
fixing FileMaker references 18
Data types
See also Field types
and calculation results 65
Database locks. See Accounts; Privilege sets
Database solutions
See also Databases; Files
described 10