U.M. (Mac OS)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- _
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- _
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Index
Importing and exporting data 8-11
6. Select a format option for the fields, and then click Export.
Suppose the current layout has a number field that’s formatted to
display two decimal digits and a currency symbol ($). When you
enter 3.7 into the field, FileMaker Pro displays $3.70 in Browse
mode. You can export the value with or without the formatting.
Export fields from a
related file
Choose a relationship from the Relationship pop-up menu,
and then move fields to the Field Order list. (See
“Understanding relationships” on page 10-9.)
Prevent data from
being exported
Select a field in the Field Order list, and then click Clear. To
move all fields out of the list, click Clear All.
Change the export order In the Field Order list, drag the double arrow for the field
name.
To export Select this option
Unformatted values (for example, 3.7) Don’t format output
Values with the number, date, and time
formats from the current layout (for
example, $3.70)
Format output using current layout. Symbols and
other non-numeric values are exported as text.
You can’t select this option for SYLK, DBF, or
DIF formats.
Choose FileMaker Help Index from the or Help menu, and then type:
E exporting, data
To Do this
FileMaker Pro
exports these
fields
Select fields from this list
Relationship pop-up menu
Choose a formatting option