User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 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
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- 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
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- 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 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 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
- 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
- Publishing databases on the web
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
Chapter 2
|
Creating databases 65
1. In Layout mode, select one or more date fields or calculation fields
with a date result.
2. Choose Format menu > Date.
3. In the Date Format dialog box, select the formats you want to use.
You see examples of the options you choose in the Sample area.
4. Click OK.
Specifying formats for time fields
You can control how FileMaker Pro displays time values in fields.
1. In Layout mode, select one or more time fields, or calculation fields
with a time result.
2. Choose Format menu > Time.
3. In the Time Format dialog box, select the formats you want to use.
You see examples of the options you choose in the Sample area.
4. Click OK.
If you want to format the seconds component to display fractional
seconds, continue with the next step.
5. Choose Format menu > Number.
6. In the Number Format dialog box, select the formats you want to
use.
Only two options affect the display of the seconds component: Fixed
number of decimal digits
and Decimal separator. The remaining options
have no effect.
7. Click OK.
8. Click OK.
Specifying formats for timestamp fields
You can control how FileMaker Pro displays timestamp values in
fields. You format a timestamp field by separately formatting its three
components: date, time (excluding the seconds portion), and seconds
(including fractional seconds).
1. In Layout mode, select one or more timestamp fields, or calculation
fields with a timestamp result.
Set font, style, size,
color, line spacing,
and alignment
Choose
options for
day, month,
date, year,
and
separator
characters
Choose to display
numbers either as
entered, in a
predetermined
format, or in a
format you specify
Choose options for
displaying
Japanese dates
Set font, style, size, color,
line spacing, and alignment
Choose to display times
either as entered, in a
predetermined format, or
in a format you specify
Choose options for
displaying Japanese times