Functions Reference

Get functions example
This script uses the function Get(CurrentDate) to check each record in the found set
to see if an account is past due. If an account is past due, the script shows a message
and prompts the user to click a button labeled Ignore, Send letter, or Send mail (set up
through the Show Custom Dialog script step). The script captures the user's response
using Get(LastMessageChoice). Then, based on the user's response, the script
performs an action: it cancels the rest of the script, prints a "payment is late" letter, or
sends email to the associated account.
Get(SystemVersion), page 113 The version of the operating system of the machine on which the
function is executed.
Get(TextRulerVisible), page 113 A Boolean value representing whether or not the text ruler is
visible.
Get(TotalRecordCount), page 114 The total number of records in the current table.
Get(UserCount), page 114 The number of users who are currently accessing the file.
Get(UserName), page 115 The name of the FileMaker Pro user, as specified in the General
tab of the Preferences dialog box.
Get(UseSystemFormatsState), page
116
A Boolean value representing the state of the Use System
Formats menu command.
Get(WindowContentHeight), page
116
A number representing the height, in pixels, of the content area.
Get(WindowContentWidth), page 117 A number representing the width, in pixels, of the content area.
Get(WindowDesktopHeight), page
117
A number representing the height, in pixels, of the desktop space.
Get(WindowDesktopWidth), page
118
A number representing the width, in pixels, of the desktop space.
Get(WindowHeight), page 119 A number representing the height, in pixels, of the current window
of the file in which the calculation is defined.
Get(WindowLeft), page 119 A number representing the horizontal distance, in pixels, of the
outer edge of the current window relative to the left-most edge of
the screen.
Get(WindowMode), page 120 A number representing whether FileMaker Pro is in Browse
mode, Find mode, Preview mode, or printing when the function is
evaluated.
Get(WindowName), page 120 The name of the current window of the file in which the calculation
is defined.
Get(WindowTop), page 121 A number representing the vertical distance, in pixels, of the outer
edge of the current window relative to the bottom edge of the
menu bar or toolbar
.
Get(WindowVisible), page 122 A Boolean value representing whether or not the current window
is visible.
Get(WindowWidth), page 122 A number representing the width, in pixels, of the current window
of the file in which the calculation is defined.
Get(WindowZoomLevel), page 123 The zoom level of the current window.
This function Returns