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










