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
C-18 FileMaker Pro User’s Guide
Design functions
Design functions return information about the structure of any specified
database that is currently open on your computer. For example, you could
determine the names of all the layouts or fields in an open database.
Note If you enclose the field name parameter in quotes (""), the design
function returns information about the field itself. If you do not enclose
the field name parameter in quotes, the design function returns
information based on the entry in the field.
Status (CurrentSystemVersion) Returns the system version currently in use
Status (CurrentTime) Returns the current time
Status (CurrentUserCount) Returns the number of users accessing the file.
Returns 1 for a single user, or 1 plus the number of
guests for multiple users using FileMaker Pro
networking. (Web users are not counted.)
Status (CurrentUserName) Returns the identification of the current
FileMaker Pro user, as specified by the general
preference
Choose FileMaker Help Index from the or Help menu, and then type:
E status functions
Syntax Definition
FieldRepetitions (database name,
layout name, field name)
Returns the number of repetitions of a specified
repeating field
FieldNames (database name,
layout name)
Returns the names of fields in the database and
layout you specify. You can also type two quotes
("") in place of a layout name to return the names of
all fields in the specified database.
FieldBounds (database name, layout
name, field name)
Returns the location and size of a specified field
FieldStyle (database name, layout
name, field name)
Returns how a specified field is formatted on a
layout (for example, radio button), and whether a
value list is associated with the field
FieldType (database name, field
name)
Returns the field definition for a specified field
LayoutNames (database name) Returns the names of layouts in a specified
database file
DatabaseNames Returns the names of the currently opened databases
Syntax Definition