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
- 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
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
58 FileMaker Pro User’s Guide
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.
2. To format the date component, choose Format menu > Date.
3. In the Date Format dialog box, select the formats you want to use
and click OK.
4. To format the time component (except the seconds portion),
choose Format menu > Time.
5. In the Time Format dialog box, select the formats you want to use
and click OK.
6. To format the seconds and fractional seconds component, choose
Format menu > Number.
7. In the Number Format dialog box, select the formats you want to
use and click OK.
Only two options affect the display of the seconds component: Fixed
number of decimal digits
and Decimal separator. The remaining options
have no effect.
You see examples of the options you choose in the Sample area.
Specifying formats for container fields
You can control how FileMaker Pro displays images and file icons
in container fields.
Note The following instructions also apply to formatting graphic
objects that you insert onto a layout.
1. In Layout mode, select one or more container fields or inserted
graphics.
2. Choose Format menu > Graphic.
3. In the Graphic Format dialog box, select the formats you want to use.
You see examples of the options you choose in the Sample area. File
icons do not scale.
4. Click OK.
Formatting fields and text for vertical writing
If your operating system is configured to support Japanese text entry,
you can format field objects and text objects that display Japanese
text in vertical writing format. In vertical writing, characters are
displayed and read from top-to-bottom, with successive columns
displayed vertically from right-to-left. This is useful when printing
addresses on labels.
When you select one or more fields, then choose Format menu >
Orientation > Sideways (Asian text only), the characters are rotated 90
degrees counter-clockwise within the field. The field itself is not
rotated. To rotate the selected fields, choose
Arrange menu > Rotate.
Depending on how you want the text to print, you may want to
change the page orientation of the layout. To do so, choose
File
menu
> Print Setup (Windows) or Page Setup (Mac OS), and change
the page orientation to
Landscape or Portrait.
Choose how to
align the graphic
vertically
Choose how to fit the
graphic in the frame
Choose how to align the
graphic horizontally