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
Adding and viewing data
2-9
Note If you have layout design privileges, you can set field format
options to determine how fields appear on a layout. For example, the
format determines whether the Other or Edit items appear in radio
buttons, checkboxes, and pop-up lists or menus. See “Formatting
fields to use a pop-up list, pop-up menu, checkboxes, or radio
buttons to display a value list” on page 7-6.
Moving data with drag and drop
You can use drag and drop to transfer information within a
FileMaker Pro file, or between FileMaker Pro and other applications
that support drag and drop.
For example, you can drag a number from one field and drop it in
another field in the same database. Or, you can drag an object from
a FileMaker Pro layout and drop it into a Microsoft Word document.
In FileMaker Pro, you can use drag and drop in Browse mode, Find
mode, or Layout mode. To enable or disable the drag and drop
feature for text in Browse mode or Find mode, select or clear Enable
drag and drop text selection in the General area of the Application
Preferences dialog box. See “Setting general application
preferences” on page A-1.
For more information about drag and drop, choose Help menu >
Contents and Index, click the Index tab, and type
drag and drop.
To Do this in Browse mode
Choose preset value from
a pop-up (drop-down) list
or menu
Click the field, then choose the value from the pop-
up list or menu.
Deselect a list Press Esc, or click the field again.
Type a value that isn’t
included in a pop-up list
Click the field again, then type the value.
Note You must type a value that’s in the list if the
Member of value list validation option is selected for
the field. See “Defining field validation” on
page 5-9.
Select or clear a radio
(option) button
Click the button to select a value.
To clear a button, Shift+click it.
Select or clear a checkbox Click a checkbox to select or clear a value.
Enter a value that isn’t
included in a value list
Choose or click Other. Type a value in the dialog
box, then click OK.
Clear an Other item Choose or click Other, then delete the associated
value (and its carriage returns) in the dialog box.
Click OK. (This action clears the field.)
Edit a value list Choose Edit, then change the values in the dialog
box. Click OK.
Checkboxes
Radio buttons
Pop-up list
Pop-up menu
Click to enter a value that
isn’t included in the list
Choose to edit
values in the list