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
11-12
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.
Important Parameters should be in quotes (" "), or you can specify a
field name for any parameter and return information about the item
typed in that field. In this case, do not put the fieldname parameter in
quotes.
Status (CurrentPrinterName) Returns the identification of the current
default printer, the driver name, and the name
of the printer port (Windows) or printer
(Mac OS.)
Status (CurrentRecordCount) Returns the number of records in a file.
Status (CurrentRecordID) Returns the unique ID of the current record.
For more information, see FileMaker Pro
Help.
Status
(CurrentRecordModificationCo
unt)
Returns the number of times changes have
been saved for the current record since this
record was created.
Status (CurrentRecordNumber) Returns the number of the current record in
the current found set.
Status
(CurrentRepetitionNumber)
Returns the current repetition number
(counting the first repetition as 1) of the
current repeating field. When the current
field is non-repeating, returns 1.
Status (CurrentRequestCount) Returns the number of find requests defined
in the database.
Status (CurrentScreenDepth) Returns the number of bits needed to
represent the color of a pixel on the main
computer screen.
Status (CurrentScreenHeight) Returns the number of pixels displayed
vertically on the screen on which the current
file is open.
When the window spans more than one
screen, uses the screen that contains the
largest percentage of the FileMaker Pro
window.
Syntax Definition
Status (CurrentScreenWidth) Returns the number of pixels displayed
horizontally on the screen on which the
current file is open.
When the window spans more than one
screen, uses the screen that contains the
largest percentage of the FileMaker Pro
window.
Status (CurrentScriptName) Returns the name of the script currently
running or paused.
Status (CurrentSortStatus) Returns a number representing the current
sort status. Returns 0 for unsorted, 1 for
sorted, or 2 for semi-sorted.
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 and Data
Access Companion users are not counted.)
Status (CurrentUserName) Returns the identification of the current
FileMaker Pro user, as specified in
Application preferences.
Syntax Definition