Functions Reference

FILEMAKER FUNCTIONS REFERENCE 78
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.
Go to Layout ["LayoutName"]
Go to Record/Request/Page [First]
Loop
If [DatabaseName::Date < Get(CurrentDate) - 30]
Show Custom Dialog ["30 or more days late"]
If [Get(LastMessageChoice) = 1]
Halt Script
Else If [Get(LastMessageChoice) = 2]
Go to Layout ["Late Notice"]
Print []
Else
Send Mail [To: DatabaseName::Client; Subject: "Late Notice";
Message: "Your account is past due."]
End If
Get(WindowLeft) 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) A number representing whether FileMaker Pro is in Browse
mode, Find mode, Preview mode, or printing when the function is
evaluated.
Get(WindowName) The name of the current window of the file in which the calculation
is defined.
Get(WindowStyle) A number indicating whether the top-most open window is a
document window, a floating document window, or a dialog
window.
Get(WindowTop) 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.
Get(WindowVisible) A Boolean value representing whether or not the current window
is visible.
Get(WindowWidth) A number representing the width, in pixels, of the current window
of the file in which the calculation is defined.
Get(WindowZoomLevel) The zoom level of the current window.
This function Returns