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
Using formulas and functions
11-11
If you use status functions in defined calculation fields, the
calculation results must be unstored. Otherwise, the calculation does
not update when the status changes. See chapter 5, “About storage
and indexing options.” The functions below appear in the list of
functions in the Specify Calculation dialog box when you choose
View status functions or View all by type. When you view all functions
by name, you see Status (status flag), which is a temporary
placeholder.
Syntax Definition
Status (CurrentAppVersion) Returns the FileMaker Pro version currently
in use.
Status (CurrentDate) Returns the current date.
Status (CurrentError) Returns a number for the current error value.
Use Status (CurrentError) to check error
results when FileMaker Pro performs a
script. For a list of error numbers, choose
Help menu > Contents and Index, click the
Index tab, and type error messages.
Status (CurrentFieldName) Returns the name of the current field.
Status (CurrentFileName) Returns the name of the current file.
Status (CurrentFileSize) Returns the size (in bytes) of the current file.
Status (CurrentFoundCount) Returns the number of records in the current
found set.
Status (CurrentGroups) Returns the group (or groups) that the current
user is a member of, based on the current
password.
Status (CurrentHostName) Returns the host name FileMaker Pro
registers on the network.
Status (CurrentLanguage) Returns the language currently set on the
current operating system.
Status (CurrentLayoutCount) Returns the number of layouts in the
database.
Status (CurrentLayoutName) Returns the name of the current layout.
Status (CurrentLayoutNumber) Returns the number of the current layout
according to the order specified in Set Layout
Order. See “Working with, duplicating,
deleting, or renaming layouts” on page 6-8
Status (CurrentMessageChoice) Returns a number corresponding to the
button clicked in an alert message displayed
using the Show Message step in a script.
Returns 1 for OK, 2 for Cancel, and 3 for the
third defined button. See “Miscellaneous
script steps” on page 10-9
Status (CurrentMode) Returns a number representing the mode
FileMaker Pro is in when the function is
evaluated. Returns 0 for Browse mode, 1 for
Find mode, 2 for Preview mode, or 3 if
printing is in progress.
Status (CurrentModifierKeys) Returns a number representing which
keyboard modifier keys (for example, Shift)
are being pressed by the user. For more
information, see FileMaker Pro Help.
Status (CurrentMultiUserStatus) Returns 0 for a single user file, 1 for a
multiuser file if the computer is the host, or 2
for a multiuser file if the computer is a guest.
Status (CurrentNetworkChoice) Returns the name of the network protocol.
Status (CurrentPageNumber) Returns the page number currently printing
or being previewed. When no page is
printing or being previewed, returns 0.
Status (CurrentPlatform) Returns a number for the platform currently
in use. Returns 1 for Mac OS, 2 for Windows
95/98, or -2 for Windows NT.
Status (CurrentPortalRow) Returns the number of the currently selected
row in a portal. When no portal is selected,
returns 0.
Syntax Definition