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
5-8
FileMaker Pro User’s Guide
Defining global fields
A global field contains one value that’s used for all records in a file.
(You can’t use a global field for finding data.) Use the value of a
global field:
1 as a fixed value to be used in calculations in all records in a file
1 to declare variables in If, Else, End If, Loop, End Loop, and Exit
Loop If script steps
1 for fields that rarely need to be updated. For example, use a global
field to put your company logo and address on several layouts. You
can quickly update a global field without having to update each layout.
To define global fields:
1. Choose File menu > Define Fields.
2. In the Define Fields dialog box, for Field Name, type a unique name
for the field.
See “About naming fields” on page 5-3.
3. For Type, select Global, then click Create.
4. In the Options for Global Field dialog box, select options.
5. Click OK.
6. Continue defining fields, or click Done.
If you’re working with global fields in a shared file, see “Working
with shared files” on page 13-2. For more information about global
fields, choose Help menu > Contents and Index, click the Index tab, and
type global fields.
Setting options for fields
You can set options for:
1 entering default data into a text, number, date, time, or container
field
1 checking data against validation requirements
1 making a repeating field
1 creating an index
1 indexing and storing data
Some field options help ensure the accuracy of your data. For
example, if you type Frnc instead of France into the Country field,
you won’t find that record when you later search for all customers
from France. To be sure that all country names are entered correctly,
you can define a value list containing the names, then select the
Member of value list validation option for the Country field. When you
enter data into the field, the data must match a value in the list. See
“Defining a list of values for data entry” on page 7-3.
To set options for summary fields, see “Defining summary fields” on
page 5-6.
Defining automatic data entry
To automatically enter a default value into a field for each record:
1. Choose File menu > Define Fields.
2. In the Define Fields dialog box, double-click a field name.
To Do this
Choose a data type for
the field
For Data type, choose a type from the list. See “About
choosing a field type” on page 5-4.
Make the field
repeating
Click the Storage tab, then select Repeating field with a
maximum of
n
repetitions. Type the number of
repetitions, then click OK. See “About repeating fields”
on page 5-11.
Choose a data
type for the field
Select to make the field repeating